利用Xml 创建表
发布时间:2020-12-15 23:29:31 所属栏目:百科 来源:网络整理
导读: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.SAXRead
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> (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |