arraylist导入mysql_list集合导入数据库

packagecn.itcast.tx;importorg.dom4j.Document;importorg.dom4j.Element;importorg.dom4j.io.SAXReader;importjava.io.File;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.util.ArrayList;importjava.util.Iterator;importjava.util.List;public classup {public static voidmain(String[] args){//插入数据的sql语句

String sql="insert into T_XML(A, B, C, D) values (?, ?, ?, ?)";

Connection conn=null;

PreparedStatement pstmt=null;try{

conn=DbUtil.getConnection();

pstmt=conn.prepareStatement(sql);//读取xml文件

Document doc=new SAXReader().read(new File("D:/1.XML"));//选择xml文件的节点//List itemList=doc.selectNodes("ACCESOS/item/SOCIO");

List itemList = newArrayList();

H h1=new H("a1","a2","a3","a4");

H h2=new H("b1","b2","b3","b4");

itemList.add(h1);

itemList.add(h2);//itemList.add("a3");//itemList.add("a4");//for(int i=1;i<3;i++) {//itemList.add("h"+i);//}

System.out.println("list::::::"+itemList);for(H s:itemList) {

pstmt.setString(1,s.getA());

pstmt.setString(2, s.getB());

pstmt.setString(3, s.getC());

pstmt.setString(4, s.getD());

pstmt.addBatch();

}//遍历读出的xml中的节点

/*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");

//遍历TURNOS节点中的内容

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);

}*/

//为sql语句赋值//}

pstmt.executeBatch();

System.out.print("将XML导入数据库成功");

}catch(Exception e){

e.printStackTrace();

}finally{

DbUtil.closeAll(conn,pstmt,null);//DbUtil.close(conn);

}

}

}