前言

    前言不搭后語··················

內(nèi)容

    聽某個大牛說他們的公司常常會涉及到從xml文件中讀數(shù)據(jù)到寫入到數(shù)據(jù)庫，序列化的時候會遇到這這個問題，將要持久化的數(shù)據(jù)到xml文件存儲起來，為了方便數(shù)據(jù)的傳輸?？戳藊ml的讀取還是很有意思的。在DRP中，我勇哥講到從xml文件中讀節(jié)點值寫入到數(shù)據(jù)庫中。下面是這個小demo，小的學業(yè)不精，見到塊塊代碼需得及時收集。

<?xml version="1.0" encoding="utf-8"?><ACCESOS>	<item>		<SOCIO>			<NUMERO>00045050</NUMERO>			<REPOSICION>0</REPOSICION>			<NOMBRE>MOISES MORENO</NOMBRE>			<TURNOS>				<LU>T1</LU>				<MA>T2</MA>				<MI>T3</MI>				<JU>T4</JU>				<VI>T5</VI>				<SA>T6</SA>				<DO>T7</DO>			</TURNOS>		</SOCIO>	</item>	<item>		<SOCIO>			<NUMERO>00045051</NUMERO>			<REPOSICION>0</REPOSICION>			<NOMBRE>RUTH PENA</NOMBRE>			<TURNOS>			<LU>S1</LU>			<MA>S2</MA>			<MI>S3</MI>			<JU>S4</JU>			<VI>S5</VI>			<SA>S6</SA>			<DO>S7</DO>			</TURNOS>		</SOCIO>	</item></ACCESOS>
用到的jar包
后臺讀取數(shù)據(jù)并寫入數(shù)據(jù)庫代碼
String sql = "insert into T_XML(NUMERO, REPOSICION, NOMBRE, TURNOS) values (?, ?, ?, ?)";Connection conn = null;PReparedStatement pstmt = null;try {	conn = DbUtil.getConnection();	pstmt = conn.prepareStatement(sql);	Document doc = new SAXReader().read(new File("C:/Users/zhou/Workspaces/MyEclipse 10/test_xmlImport/xml/test01.XML"));	List itemList = doc.selectNodes("/ACCESOS/item/SOCIO");	for (Iterator iter=itemList.iterator(); iter.hasNext();) {		Element el = (Element)iter.next();		String numero = el.elementText("NUMERO");		String reposicion = el.elementText("REPOSICION");		String nombre = el.elementText("NOMBRE");		List turnosList = el.elements("TURNOS");		StringBuffer sbString = new StringBuffer();		for (Iterator iter1=turnosList.iterator(); iter1.hasNext();) {			Element turnosElt = (Element)iter1.next();			String lu = turnosElt.elementText("LU");			String ma = turnosElt.elementText("MA");			String mi = turnosElt.elementText("MI");			String ju = turnosElt.elementText("JU");			String vi = turnosElt.elementText("VI");			String sa = turnosElt.elementText("SA");			String doo = turnosElt.elementText("DO");			sbString.append(lu + "," + ma + "," + mi + "," + ju + "," + vi + "," + sa + "," + doo);		}		pstmt.setString(1, numero);		pstmt.setString(2, reposicion);		pstmt.setString(3, nombre);		pstmt.setString(4, sbString.toString());		pstmt.addBatch();	}	pstmt.executeBatch();	System.out.println("將XML導入數(shù)據(jù)庫成功！");} catch (Exception e) {	e.printStackTrace();} finally {	DbUtil.close(pstmt);	DbUtil.close(conn);}
小結(jié)
    菜鳥還需努力，go~~~
感謝您的寶貴時間···