package com.dy.java; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Statement; public class DB { private String ip="127.0.0.1"; private String port="1433"; private String url ="jdbc:sqlserver://"+ip+":"+port+";"+"DatabaseName=txl"; private static String user=""; private static String password=""; private static String str=""; private Connection con; private String sql; private PreparedStatement sta; private static void init() { try { InputStream in =new FileInputStream("E:/zl.xml"); byte[] b =new byte[1024]; int y; while((y=in.read(b))!=-1) { str+= new String(b,0,y); } // System.out.println(str); if(str!=null&&str!=""&&str.length()!=0) { int n =str.indexOf("<user>")+"<user>".length(); int m =str.indexOf("</user>"); user =str.substring(n, m); // System.out.println(user); int n1 =str.indexOf("<password>")+"<password>".length(); int m1=str.indexOf("</password>"); password =str.substring(n1, m1); // System.out.println(password); } } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public DB() { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con=DriverManager.getConnection(url,user,password); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void go() { try { sta=con.prepareStatement(sql); sta.execute("insert into txl() values ()"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { DB.init(); DB db =new DB(); // db.go(); } }
zl.xml
<url>jdbc:sqlserver://</url> <ip>127.0.0.1</ip> <port>1433</port> <user>sa</user> <password>520</password>