jiaofei.java~3~

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

package pxzx.sql;

import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;

public class JiaoFei {
    public JiaoFei(xfjf x,xfbzpz pz) throws SQLException {
        try{
            Connection con = ConnectDB.connect();
            Statement st = con.createStatement();
            String jfsql="insert into 学费收入表 (T_date,St_id,St_name,C_id,Tu_mon,Tu_check,Tu_check_id) values('"
                         +x.getT_date()+"','"+x.getSt_id()+"','"+x.getSt_name()+"',"+x.getC_id()+","+x.getTu_mon()+
                         ",'"+x.getTu_check()+"','"+x.getTu_check_id()+"')";
            st.executeUpdate(jfsql);

            String sql = "insert into 凭证库表(C_date,C_kind,C_abst,B_sub,B_mon,L_sub,L_mon,C_Ma_name,C_Au_name) values('"
                      +pz.getC_date()+"','"+pz.getC_kind()+"','"+pz.getC_abst()+"','"+pz.getB_sub()+"',"+pz.getB_mon()
                      +",'"+pz.getL_sub()+"',"+pz.getL_mon()+",'"+pz.getC_Ma_name()+"','"+pz.getC_Au_name()+"')";
            st.executeUpdate(sql);

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

    }
}