1.获取连接 Connection conn=DButil.getConnection();
2.输入sql语句 PreparedStatement ps =conn.prepareStatement("select name from user where id = ? ");
3.处理结果集 ResultSet rs=ps.executeQuery();
publicclassUserDaoimplementsDao{//根据id查询姓名
@Override
public String selectName(int id){
System.out.println("进入UserDao界面");
Connection conn;
PreparedStatement ps;
ResultSet rs;
String s =null;try{
conn=DButil.getConnection();
ps =conn.prepareStatement("select name from user where id = ? ");
ps.setInt(1,id);
rs=ps.executeQuery();while(rs.next()){
s=rs.getString("name");}}catch(SQLException throwables){
throwables.printStackTrace();}return s;}}