userregist.java~8~

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

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 Date getT_date() {
    return t_date;
}
public int getSt_id() {
    return st_id;
}
public String getSt_name() {
    return st_name;
}



public float getTu_mon() {
    return tu_mon;
}

public String getC_id() {
    return c_id;
}
public String getTu_check() {
    return tu_check;
}
public String getTu_check_id() {
    return tu_check_id;
}

public UserRegist earnInfo(int id){
    UserRegist re = new UserRegist();
    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.setT_id(rs.getString("t_id"));
            re.setT_date(rs.getDate("t_date"));
            re.setSt_id(rs.getInt("st_id"));
            re.setSt_name(rs.getString("st_name"));
            re.setC_id(rs.getString("c_id"));
            re.setTu_mon(rs.getFloat("tu_mon"));
            re.setTu_check(rs.getString("tu_check"));
            re.setTu_check_id(rs.getString("tu_check_id"));

        }
    }catch(Exception ex){
        ex.printStackTrace();
    }
    return re;
}

}