xfzhinsert.java~3~

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

package pxzx.sql;
import java.sql.*;

public class XFZHInsert {
    public XFZHInsert(xfzhb xf){
        try{
            Connection con=ConnectDB.connect();
            Statement st=con.createStatement();

            String sql="insert into 学费转汇表 (St_id,St_name,Tu_pay_mon,Tu_mon,Remit_pay_mon,Remit_mon,Remit_amount,Remit_time,Remit_people,Remit_yet) value('"+
                xf.getSt_id()+"','"+xf.getSt_name()+"',"+xf.getTu_pay_mon()+","+xf.getTu_mon()+","+xf.getRemit_pay_mon()
                +","+xf.getRemit_mon()+","+xf.getRemit_amount()+","+xf.getRemit_time()+",'"+xf.getRemit_people()+"',"+xf.getRemit_yet()+")";
           st.executeUpdate(sql);

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