gongqiudaoimpl.java~3~

用JSP制作的个人网站

package liangjuyan.dao;

import liangjuyan.gongqiu;
import liangjuyan.conndb;
import java.util.List;
import java.util.ArrayList;
import java.sql.ResultSet;
import java.sql.*;
import liangjuyan.chStr;

public class gongqiudaoimpl
    implements gongqiudao{
  private conndb conn = new conndb();
  //执行插入操作
  public int insert(gongqiu g) {
    chStr chStr = new chStr();
    int ret = -1;
    try {
      String sql = "Insert into addgongqiu(Username,Truename,Content,Address,Cardtype,Cardno,City,Youbian,Tel) values('" +
          chStr.chStr(g.getUsername()) + "','" + chStr.chStr(g.getTruename()) +
          "','" + chStr.chStr(g.getContent()) +"','" + chStr.chStr(g.getAddress()) + "','" + chStr.chStr(g.getCardtype()) +
          "','" + chStr.chStr(g.getCardno()) + "','" +
          chStr.chStr(g.getCity()) + "','" + chStr.chStr(g.getYoubian()) +
          "','" + chStr.chStr(g.getTel()) + "')";
       ret = conn.executeUpdate(sql);
    }
    catch (Exception e) {
      ret = 0;
    }
    conn.close();
    return ret;
  }

  //执行修改操作
  public int update(gongqiu g) {
    int ret = -1;
    chStr chStr = new chStr();
    try {
      String sql = "update addgongqiu set truename='" +
          chStr.chStr(g.getTruename()) +
          "',content='" + chStr.chStr(g.getContent()) + "',address='" +
          chStr.chStr(g.getAddress()) + "',cardtype='" + chStr.chStr(g.getCardtype()) +
          "',cardno='" + chStr.chStr(g.getCardno()) +
          "',city='" + chStr.chStr(g.getCity()) + "',youbian='" +
          chStr.chStr(g.getYoubian()) + "',tel='" + chStr.chStr(g.getTel()) +
          "' where ID=" + g.getID();
      ret = conn.executeUpdate(sql);
    }
    catch (Exception e) {
      ret = 0;
    }
    conn.close();
    return ret;
  }

  //执行删除操作
  public int delete(gongqiu g) {
    String sql = "delect from addgongqiu where ID=" + g.getID();
    int ret = conn.executeUpdate(sql);
    conn.close();
    return 0;
  }

  //执行查询操作
  public List select() {
    qiugou form = null;
    List list = new ArrayList();
    String sql = "select * from addqiugou";
    ResultSet rs = conn.executeQuery(sql);
    try {
      while (rs.next()) {
        form = new qiugou();
        form.setID(Integer.valueOf(rs.getString(1)));

        list.add(form);
      }
    }
    catch (SQLException ex) {
    }
    conn.close();
    return list;
  }

  public qiugou select1() {
    return null;
  }

}