searchdate.java~1~

来自「培训中心办公自动化系统之财务管理模块 包括缴纳报名费、学费」· JAVA~1~ 代码 · 共 50 行

package pxzx.sql;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;
import java.util.*;
public class searchDate {
    public searchDate() {
    }
    public RegistEarn [] searchInfo(java.sql.Date d_s,java.sql.Date d_e){
       RegistEarn reArray[]=null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
       String sql = "";
       try{
           sql = "select * from 报名费收入表 where S_date between '"+d_s+"' and '"+d_e+"'";
           conn = ConnectDB.connect();
           stmt = conn.createStatement();
           rs = stmt.executeQuery(sql);
           rs.last();
           int length=rs.getRow();int i=0;
           reArray=new RegistEarn[length];
           rs.beforeFirst();
           while(rs.next()){
               RegistEarn re = new RegistEarn();
               re.setC_id(rs.getInt("S_id"));
               re.setSt_name(rs.getString("St_name"));
               re.setS_date(rs.getDate("S_date"));
               re.setS_mon(rs.getFloat("S_mon"));
               re.setC_id(rs.getInt("C_id"));
               reArray[i]=re;
           }
       }catch(Exception ex){
           ex.printStackTrace();
       }
       return reArray;
    }
}