如何使用JDBC查询指定的记录

//连接数据库

public class JdbcDao {
private Connection conn=null;
private String strSql=null;

public JdbcDao() {

       String driver ="com.mysql.jdbc.Driver";
       try {
           Class.forName(driver);
           String url ="jdbc:mysql://localhost:3306/dev?characterEncoding=utf8";
           conn=DriverManager.getConnection(url,"root", "");
           System.out.println("连接mysql数据库成功");

       } catch (Exception e) {
           // TODO: handle exception
           e.printStackTrace();
       }
   }

//指定id查询学生所有信息操作
   public Student queryOne(int id) {
       Statement stmt=null;
       ResultSet rs=null;
       Student stu=new Student();
       try {
           strSql=" select * from student where id= "+id;    /根据ID查询Sq语句
           stmt=conn.createStatement(rs.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_READ_ONLY);
           //执行SQL语句
           rs=stmt.executeQuery(strSql);     //查询返回结果
           while(rs.next()) {
               stu.setId(id);
               stu.setName(rs.getString("name"));
               stu.setPhone(rs.getString("phone"));
               stu.setStuNo(rs.getString("stuNo"));
               stu.setBirthday(rs.getString("brithday"));
               System.out.println("查询成功"+strSql);
           }
       } catch (Exception e) {
           // TODO: handle exception
           e.printStackTrace();
       }

｝

巴特西

如何使用JDBC查询指定的记录

最新文章

热门文章