使用配置文件
//使用JDBC直接建立数据库连接, 从配置文件读取驱动程序信息
dbDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
dbIP=127.0.0.1
dbPort=1433
dbUserName=admin
dbPassword=xyz
defaultDbName=bookTest
import java.sql.*;
import java.util.Properties;
import java.io.*;
public class JdbcProp{
public static void main(String[] args){
try{
Properties prop=new Properties();
prop.load(new FileInputStream("db.cfg"));
String driver=prop.getProperty("dbDriver");
String ip=prop.getProperty("dbIP");
String port=prop.getProperty("dbPort");
String userName=prop.getProperty("dbUserName");
String password=prop.getProperty("dbPassword");
String dbName=prop.getProperty("defaultDbName");
String url ="jdbc:microsoft:sqlserver://"+ip+":"+port;
Class.forName(driver);
Connection con=DriverManager.getConnection(url,userName,password);
con.setCatalog(dbName);
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next())
System.out.println(rs.getString(1)+" "+rs.getString(2)
+" "+rs.getFloat(3)+" "+rs.getString(4));
rs.close();
stmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
}