fuzhuangdaoimpl.java~11~

用JSP制作的个人网站

package liangjuyan.dao;

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

public class fuzhuangdaoimpl
    implements fuzhuangdao{
  private conndb conn = new conndb();
  //执行插入操作
  public int insert(fuzhuang f) {
    chStr chStr = new chStr();
    int ret = -1;
    try {
      String sql = "Insert into fuzhuang (Wupinming,Yanse,Changjia,Cailiao,Shiyongnianxian,Shengchanriqi,Goumaichishu,Tuijianzhishu,Youdian,Tupian,Tebietuijian,Datupian,Price) values('" +
          chStr.chStr(f.getWupinming()) + "','" + chStr.chStr(f.getYanse()) +
          "','" + chStr.chStr(f.getChangjia()) +"','" + chStr.chStr(f.getCailiao()) + "','" + chStr.chStr(f.getShiyongnianxian()) +
          "','" + chStr.chStr(f.getShengchanriqi()) + "','" +
          chStr.chStr(f.getGoumaichishu()) + "','" + chStr.chStr(f.getTuijianzhishu()) +
          "','" + f.getYoudian() + "','" + chStr.chStr(f.getTupian()) + "','" + f.getTebietuijian()+ "','" + f.getDatupian()+ "','" + f.getPrice()+ "')";
       ret = conn.executeUpdate(sql);
    }
    catch (Exception e) {
      ret = 0;
    }
    conn.close();
    return ret;
  }

  //执行修改操作
  public int update(fuzhuang f) {
    int ret = -1;
    chStr chStr = new chStr();
    try {
      String sql = "update fuzhuang set wupinming='" +
          chStr.chStr(f.getWupinming()) +
          "',yanse='" + chStr.chStr(f.getYanse()) + "',changjia='" +
         f.getChangjia()+ "',cailiao='" + chStr.chStr(f.getCailiao()) +
          "',shiyongnianxian='" + chStr.chStr(f.getShiyongnianxian()) +
          "',Shengchanriqi='" + chStr.chStr(f.getShengchanriqi()) + "',goumaichishu='" +
          chStr.chStr(f.getGoumaichishu()) + "',tuijianzhishu='" + chStr.chStr(f.getTuijianzhishu()) +
          "',youdian='" + chStr.chStr(f.getYoudian()) + "',tupian='" + chStr.chStr(f.getTupian()) + "',tebietuijian='"+f.getTebietuijian()+"',datupian='" + chStr.chStr(f.getDatupian()) + "',price='" + f.getPrice() + "' where fuzhuangid=" + f.getFuzhuangid();
      ret = conn.executeUpdate(sql);
    }
    catch (Exception e) {
      ret = 0;
    }
    conn.close();
    return ret;
  }

  //执行删除操作
  public int delete(fuzhuang f) {
    String sql = "delect from fuzhuang where fuzhuangid=" +f.getFuzhuangid();
    int ret = conn.executeUpdate(sql);
    conn.close();
    return ret;
  }

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

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

  public fuzhuang select1() {
    return null;
  }

}