利用Xml 创建表

前端之家收集整理的这篇文章主要介绍了利用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>

猜你在找的XML相关文章