usergzbwdaoimpl.java~2~

客户关系管理系统,包括数据库,类,所有运行所需的代码及文件

package com.dao;

import java.util.List;
import com.domain.UserGzbwForm;
import com.tool.JDBConnection;
import java.util.ArrayList;
import com.tool.SQLCode;
import java.sql.ResultSet;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
//工作备忘
public class UserGzbwDaoImpl
    implements UserGzbwDao {
  private JDBConnection connection = new JDBConnection();
  //查询工作备忘记录
  public List userGzbwselect(UserGzbwForm form) {
    List list = new ArrayList();
    UserGzbwForm gzbw = null;
    String sql = SQLCode.getSQLCode("sql.userGzbw.select");
    sql = connection.editSqlCode(sql, form.getGzbw_manager());
    try {
      ResultSet rs = connection.executeQuery(sql);
      while (rs.next()) {
        gzbw = new UserGzbwForm();
        gzbw.setGzbw_id(rs.getString(1));
        gzbw.setGzbw_bt(rs.getString(2));
        gzbw.setGzbw_nr(rs.getString(3));
        gzbw.setGzbw_jsrq(rs.getString(4));
        gzbw.setGzbw_bz(rs.getString(5));
        gzbw.setGzbw_manager(rs.getString(6));
        gzbw.setId(Integer.valueOf(rs.getString(7)));
        list.add(gzbw);
      }
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }

}