userregist.java~5~

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

package pxzx.sql;

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

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

    public UserRegist() {
    }
    public void setT_id(String t_id) {
    this.t_id = t_id;
    }

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


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

   public void setTu_mon(float s_mon) {
    this.tu_mon = tu_mon;
   }
   public void setTu_check(String tu_check) {
       this.tu_check = tu_check;
   }

   public void setTu_check_id(String tu_check_id) {
       this.tu_check_id = tu_check_id;
   }

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

public String getT_id() {
    return t_id;
}

public String getSt_name() {
    return st_name;
}

public Date getT_date() {
    return t_date;
}

public float getTu_mon() {
    return tu_mon;
}

public String getC_id() {
    return c_id;
}
public

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;
}

}