DB 从zl.xml中导入数据库用户名及密码等!

时间:2023-03-08 22:15:51
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>