利用Xml 创建表
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>
?