增删改查 讲解代码

Dao接口如下：
public void insert(Object obj);
public void delete(Object obj);
public void update(Object obj);
public List select(Object obj);

实现如下：
加增删改查的方法实现，
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import Bean.Bean;

public class shixian implements DAO {

 public void delete(Bean bean) throws Exception {
  // 删除数据
  String sql = "delete  from person where name=?";
  Conn conn = new Conn();
  PreparedStatement pre;
  try {
   pre = conn.getConn().prepareStatement(sql);
   pre.setString(1, bean.getName());
   pre.executeUpdate();
   pre.close();

  } catch (Exception e) {
   e.printStackTrace();
  }

 }

 public void insert(Bean bean) throws Exception {
  // 增加数据
  String sql = "insert into person values(?,?)";
  Conn conn = new Conn();
  PreparedStatement pre = null;
  try {
   pre = conn.getConn().prepareStatement(sql);
   pre.setString(1, bean.getName());
   pre.setString(2, bean.getPassword());
   pre.executeUpdate();
   pre.close();
  }

  catch (Exception e) {
   e.printStackTrace();
  }

 }

 public Bean select(String name) throws Exception {
  // 查询数据

  String sql = "select name,password from person where name=?";
  Conn conn=new Conn();
  Bean bean = new Bean();
  PreparedStatement pre = null;
  try{
   pre = conn.getConn().prepareStatement(sql);
   pre.setString(1, name);
   ResultSet rs = pre.executeQuery();
   if (rs.next()) {
    bean.setName(rs.getString(1));
    bean.setPassword(rs.getString(2));

   }
   rs.close();
   pre.close();

  } catch (Exception e) {
   e.printStackTrace();
  }

  return bean;
 }

 public void update(Bean bean) throws Exception {
  // 修改数据
  String sql = "insert into person values(?,?)";
  Conn conn = new Conn();
  PreparedStatement pre = null;
  try {
   pre = conn.getConn().prepareStatement(sql);
   pre.setString(1, bean.getName());
   pre.setString(1, bean.getPassword());
   pre.executeUpdate();
   pre.close();
  }

  catch (Exception e) {
   e.printStackTrace();
  }

 }

}