Set-Get(?占位符)-Java(新手)
创建实体类:
1 package JdbcDome; 2 3 public class EmpL { 4 private int uid; 5 private String uNAME; 6 private int age; 7 private String sexs; 8 9 public int getId() { 10 return uid; 11 } 12 13 public void setId(int id) { 14 this.uid = id; 15 } 16 17 public String getuNAME() { 18 return uNAME; 19 } 20 21 public void setuNAME(String uNAME) { 22 this.uNAME = uNAME; 23 } 24 25 public int getAge() { 26 return age; 27 } 28 29 public void setAge(int age) { 30 this.age = age; 31 } 32 33 public String getSexs(String sexs) { 34 return this.sexs; 35 } 36 37 public void setSexs(String sexs) { 38 this.sexs = sexs; 39 } 40 41 @Override 42 public String toString() { 43 return "EmpL{" + 44 "id=" + uid + 45 ", uNAME='" + uNAME + '\'' + 46 ", age=" + age + 47 ", sexs='" + sexs + '\'' + 48 '}'; 49 } 50 }
运行:
1 package JdbcDome; 2 3 import java.sql.*; 4 import java.util.*; 5 6 7 public class JdbcDome1 { 8 public static void main(String[] args) throws Exception { 9 fun1(); 10 } 11 public static void fun1() throws Exception { 12 //创建一个对象。 13 EmpL e = new EmpL(); 14 //注册驱动。 15 Connection conn = JDBCUtils.getConnection(); 16 //链接SQL表。 17 PreparedStatement ptst = conn.prepareStatement("select * from students where uid = ?"); 18 //设置参数。 19 ptst.setInt(1,3); 20 ResultSet rs = ptst.executeQuery(); 21 if (rs.next()){ 22 //封装成对象。 23 e.setId(rs.getInt("uid")); 24 e.setuNAME(rs.getString("uNAME")); 25 e.setAge(rs.getInt("ages")); 26 e.getSexs(rs.getString("sexs")); 27 28 } 29 JDBCUtils.close(conn,ptst, rs); 30 System.out.println(e); 31 } 32 }