写dapingzhanshi.properties文件
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://192.168.1.119:1433;DatabaseName=factory
name=528factory
password=test\!123
存放在src文件夹中
//读取properties文件
Properties prop = new Properties();
String pathString = Thread.currentThread().getContextClassLoader().getResource("").getPath();//获得该类的存放位置
FileInputStream fis = null;
fis = new FileInputStream(pathString + "/dapingzhanshi.properties");//pathString + "/dapingzhanshi.properties就是properties文件的存放位置
prop.load(fis);
Class.forName(prop.getProperty("driver"));//加载驱动
String DBname = prop.getProperty("url");//url
String DBuser = prop.getProperty("name");
String DBcode = prop.getProperty("password");
Connection con = DriverManager.getConnection(DBname, DBuser, DBcode);