cqylxdaoimpl.java~2~

来自「客户关系管理系统,包括数据库,类,所有运行所需的代码及文件」· JAVA~2~ 代码 · 共 34 行

package com.dao;

import java.util.List;
import java.util.ArrayList;
import com.tool.JDBConnection;
import com.tool.SQLCode;
import java.sql.ResultSet;
import java.sql.*;
import com.domain.CqylxForm;
//对表tb_Client_qylx的操作
public class CqylxDaoImpl
    implements CqylxDao {
//查询的操作
  public List qylxSelect() {
    JDBConnection connection = new JDBConnection();
    CqylxForm form = null;
    List list = new ArrayList();
    String sql = SQLCode.getSQLCode("sql.qylx.select");
    try {
      ResultSet rs = connection.executeQuery(sql);
      while (rs.next()) {
        form = new CqylxForm();
        form.setQylx_id(rs.getString(1));
        form.setQylx_lxmc(rs.getString(2));
        form.setQylx_bz(rs.getString(3));
        list.add(form);
      }
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }
}