registearn.java~1~

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

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.Date;
import java.sql.*;

public class RegistEarn {
    private int s_id;
    private String st_name;
    private Date s_date;
    private float s_mon;
    private int c_id;

    public RegistEarn() {
    }

    public void setS_id(int s_id) {
        this.s_id = s_id;
    }

    public void setSt_name(String st_name) {
        this.st_name = st_name;
    }

    public void setS_date(Date s_date) {
        this.s_date = s_date;
    }

    public void setS_mon(float s_mon) {
        this.s_mon = s_mon;
    }

    public void setC_id(int c_id) {
        this.c_id = c_id;
    }

    public int getS_id() {
        return s_id;
    }

    public String getSt_name() {
        return st_name;
    }

    public Date getS_date() {
        return s_date;
    }

    public float getS_mon() {
        return s_mon;
    }

    public int getC_id() {
        return c_id;
    }

    public RegistEarn earnInfo(int id){
        RegistEarn re = new RegistEarn();
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String sql  = "";
        try{
            sql = "select * from 报名费收入表 where S_id ="+id;
            conn = ConnectDB.connect();
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while(rs.next()){
                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"));
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return re;
    }
}