通过属性文件来得到数据库的链接

Java的jdbc通过读取属性文件来得到数据库的链接

1.属性文件 sqlserver.properties

dbUseName=sa
dbPassWord=sa
dbdriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
dburl=jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=testdb3

2.用Java的jdbc得到数据库的链接(SqlHelper.java)

import java.io.InputStream;
import java.sql.*;
import java.util.Properties;


public class SqlHelper {


private Connection ct=null;
private PreparedStatement ps=null;
private ResultSet rs=null;

private static String username="";
private static String password="";
private static String driver="";
private static String url="";
private static InputStream fis=null;

static {
Properties pp=new Properties();
try {
fis=SqlHelper.class.getClassLoader().getResourceAsStream
("sqlserver.properties");
pp.load(fis);
username=pp.getProperty("dbUseName");
password=pp.getProperty("dbPassWord");
driver=pp.getProperty("dbdriver");
url=pp.getProperty("dburl");
Class.forName(driver);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}

public Connection getConnect(){

try {
ct=DriverManager.getConnection(url, username, password);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}

return ct;
}

}