使用properties属性文件做连接数据库的操作代码
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DBConn {
public Connection getconn()
{
Connection conn=null;
Properties pros=new Properties();
InputStream in=ClassLoader.getSystemResourceAsStream("data.properties");
//或者作用下面这种方式
//BufferedReader in =new BufferedReader(new FileReader("data.properties"));
try {
pros.load(in);
in.close();
String driver=pros.getProperty("jdbc.driver");
String url=pros.getProperty("jdbc.url");
String name=pros.getProperty("jdbc.username");
String pwd=pros.getProperty("jdbc.userpwd");
Class.forName(driver);
conn=DriverManager.getConnection(url, name, pwd);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
}
data.properties文件代码
jdbc.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc.url=jdbc:microsoft:sqlserver://localhost:1433;databasename=Bash
jdbc.username=sa
jdbc.userpwd=