sfzydaoimpl.java~1~

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

package com.dao;

import java.util.List;
import com.tool.JDBConnection;
import java.util.ArrayList;
import com.domain.FfzyForm;
import com.tool.SQLCode;
import java.util.List;
import com.tool.JDBConnection;

import java.util.ArrayList;
import java.sql.ResultSet;
import java.sql.*;


public class SfzyDaoImpl implements SfzyDao {
  private JDBConnection connection = new JDBConnection();

  public List sfzySelect() {
    List list =new ArrayList();
    FfzyForm form=null;
    String sql=SQLCode.getSQLCode("sql.sfzy.myd");
    try {
      ResultSet rs = connection.executeQuery(sql);
      while (rs.next()) {
        form=new FfzyForm();
        form.setSfzy_id(rs.getString(1));
        form.setSfzy_sfmc(rs.getString(2));
        form.setSfzy_zyms(rs.getString(3));
        list.add(form);
      }
    }
    catch (SQLException ex) {
    }connection.close();
    return list;
  }
}