package JdbcDome;

 public class EmpL {

     private int uid;

     private String uNAME;

     private int age;

     private String sexs;

     public int getId() {

         return uid;

     }

     public void setId(int id) {

         this.uid = id;

     }

     public String getuNAME() {

         return uNAME;

     }

     public void setuNAME(String uNAME) {

         this.uNAME = uNAME;

     }

     public int getAge() {

         return age;

     }

     public void setAge(int age) {

         this.age = age;

     }

     public String getSexs(String sexs) {

         return this.sexs;

     }

     public void setSexs(String sexs) {

         this.sexs = sexs;

     }

     @Override

     public String toString() {

         return "EmpL{" +

                 "id=" + uid +

                 ", uNAME='" + uNAME + '\'' +

                 ", age=" + age +

                 ", sexs='" + sexs + '\'' +

                 '}';

     }

 }

 package JdbcDome;

 import java.sql.*;

 import java.util.*;

 public class JdbcDome1 {

     public static void main(String[] args) throws Exception {

             fun1();

     }

     public static void fun1() throws Exception {

         //创建一个对象。

         EmpL e = new EmpL();

         //注册驱动。

         Connection conn = JDBCUtils.getConnection();

         //链接SQL表。

         PreparedStatement ptst = conn.prepareStatement("select * from students where uid = ?");

        //设置参数。

         ptst.setInt(1,3);

         ResultSet rs = ptst.executeQuery();

         if (rs.next()){

             //封装成对象。

             e.setId(rs.getInt("uid"));

             e.setuNAME(rs.getString("uNAME"));

             e.setAge(rs.getInt("ages"));

             e.getSexs(rs.getString("sexs"));

         }

         JDBCUtils.close(conn,ptst, rs);

         System.out.println(e);

     }

 }