chaxun.java~8~

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

package pxzx.sql;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;

public class ChaXun {
    public ChaXun(xfhzb x) throws SQLException{
        try{
            Connection con = ConnectDB.connect();
            Statement st = con.createStatement();
            String St_id="3721";
            String cxsql="select *from 学费汇总表 where St_id=St_id";
            ResultSet rs=st.executeQuery(cxsql);
            while(rs.next())
            {
                String SSt_id=rs.getString(1);
                String SSt_name=rs.getString(2);
                float FTu_pay_mon=rs.getInt(3);
                float FTu_mon=rs.getInt(4);
                float FTu_re_mon=rs.getInt(5);
                float FTu_ny_mon=rs.getInt(6);
                System.out.println(SSt_id +" "+SSt_name+" "+FTu_pay_mon+" "+FTu_mon+" "+FTu_re_mon+" "+FTu_ny_mon);
            }

        }catch(Exception e){e.printStackTrace();}

    }

    /**
     * ChaXun
     */
    public ChaXun() {
    }

    public static void main(String [] argc) throws SQLException {
        xfhzb x=new xfhzb();
        ChaXun cx=new ChaXun(x);
    }
}