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(); } } }
