Connectionstatement resultSet
package com.suanfa; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement ; public class MySqlTest { public static void main(String[] args) { // TODO Auto-generated method stub //准备访问数据的资源 String driver="com.mysql.jdbc.Driver"; String url="jdbc:mysql://localhost:3306/student"; String user="root"; String pwd="admin"; String sql="select * from stu"; //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(); } } }
