userregist.java~1~

培训中心办公自动化系统之财务管理模块 包括缴纳报名费、学费

package pxzx.sql;

import java.sql.Date;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;

public class UserRegist {
    private int t_id;
    private String st_name;
    private String st_id;
    private
    private Date t_date;
    private float tu_mon;
    private int c_id;

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

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

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

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

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

public int getS_id() {
    return t_id;
}

public String getSt_name() {
    return st_name;
}

public Date getS_date() {
    return t_date;
}

public float getS_mon() {
    return tu_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;
}

}