package com.chai;
import java.io.File;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Iterator;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
import com.chai.dao.DbConn;
public class Xml {
public static void main(String[] args) throws DocumentException, SQLException {
SAXReader reader =new SAXReader();
Document doc=reader.read(new File("src/com/chai/stu.xml"));
Element element=doc.getRootElement();
Iterator it=element.elementIterator();
String colu="";
while(it.hasNext()){
Element element1=(Element)it.next();
String table_name=element1.attributeValue("table");
Iterator its=element1.elementIterator();
while(its.hasNext()){
Element ele =(Element)its.next();
colu+=ele.attributeValue("colum")+" "+ele.attributeValue("type")+",";
}
colu=colu.substring(0,colu.length()-1);
colu=colu.replace("String", "varchar2(20)");
String sql="create table "+table_name+"( "+colu+")";
System.out.println(sql);
DbConn db=new DbConn();
PreparedStatement pre=db.SetCon().prepareStatement(sql);
pre.execute();
}
}
}
<student-mapping> <class name="com.chai.vo.UserVo" table="userinf"> <property name="username" colum="username" type="String"/> <property name="password" colum="password" type="String"/> <property name="sex" colum="sex" type="int"/> </class> </student-mapping>