利用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>