将数据库信息读取到xml中,部分代码
public class schemeXml
{
static Connection conn=null;
static String sql;
public static void main(String[] args)
{
try
{ //链接数据库,取得数据
//Class.forName("oracle.jdbc.driver.OracleDriver");//oracle数据库
Class.forName("com.mysql.jdbc.Driver");//mysql数据库
conn=DriverManager.getConnection("jdbc:mysql://192.168.1.109/cpsad?user=root&password=admin&useUnicode=true&characterEncoding=UTF-8");
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from user");
DocumentBuilderFactory factory=DocumentBuilderFactory.newInstance();
DocumentBuilder builder=factory.newDocumentBuilder();
Document doc=builder.newDocument();