jdbc.properties
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=COODB;integratedSecurity=false
jdbc.username=sa
jdbc.password=123456
initialSize=1
maxActive=20
minIdle=10
maxWait=60000
package com.yanshu.utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
/**
* JDBC连接数据库并访问
* @author DELL
*
*/
public class sql {
public static void main(String[] args) {
// TODO Auto-generated method stub
//准备访问数据的资源
/*String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;DatabaseName=COODB;integratedSecurity=false";
String user="sa";
String pwd="123456"; */
InputStream inputStream=JDBCUtil.class.getClassLoader().getResourceAsStream("jdbc.properties");
Properties pro=new Properties();
try {
pro.load(inputStream);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String diver=pro.getProperty("jdbc.driver");
String url=pro.getProperty("jdbc.url");
String user=pro.getProperty("jdbc.username");
String password=pro.getProperty("jdbc.password");
String sql="select * from dbo.articeList";
//1,装载驱动
try {
Class.forName(diver);
//2.获得连接
Connection cn = DriverManager.getConnection(url,user,password);
//3.声明
Statement st = cn.createStatement();
//4.执行声明,并提交SQL语句
ResultSet rs=st.executeQuery(sql);
//5.处理结果集
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("title");
System.out.println(rs.getInt("id")+" "
+rs.getString("title"));
//+" "+
//rs.getString("password"));
}
//6.关闭资源
rs.close();
st.close();
cn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException se){
se.printStackTrace();
}
}
}