1加载驱动 2获得连接 3创建PreparedStatment 4执行SQL5获得结果集6释放资源
package cn.molesoft.yanShulcsy.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://电脑的IP: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 usersso"; //1，装载驱动 try { Class.forName(driver); //2.获得连接 Connection cn = DriverManager.getConnection(url,user,pwd); //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("name"); System.out.println(rs.getInt("id")+" " +rs.getString("name")); //+" "+ //rs.getString("password")); } //6.关闭资源 rs.close(); st.close(); cn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); }catch(SQLException se){ se.printStackTrace(); } } }
