cqyxzdaoimpl.java~5~

JSP+SQL实现了一个拥有添加、删除、查询基本功能的CRM系统

package com.dao;

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

public class CqyxzDaoImpl
    implements CqyxzDao {
//查找的操作
  public List qyxzSelect() {
    List list = new ArrayList();
    JDBConnection connection = null;
    String sql = SQLCode.getSQLCode("sql.qyxz.select");
      System.out.print(sql);
    CqyxzForm form = null;
    ResultSet rs = null;
    try {
      rs=connection.executeQuery(sql);
      System.out.print(rs);
      while (rs.next()) {
        form = new CqyxzForm();
        form.setQyxz_id(rs.getString(1));
        form.setQyxz_xzmc(rs.getString(2));
        form.setQyxz_bz(rs.getString(3));
        list.add(form);
      }
    }
    catch (SQLException ex) {
    }
    connection.close();
    return list;
  }
}