text_jf.java~16~

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

package pxzx.sql;

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

public class text_jf {
    public text_jf() {
    }
    public static void main(String [] argc) throws SQLException {
    Date date=java.sql.Date.valueOf("2008-4-4");
    float Tu_mon=2500;
    int newC_id=0;

    xfbzpz pz=new xfbzpz();
    pz.setC_date(date);
    pz.setC_kind("收款");
    pz.setC_abst("1");
    pz.setB_sub("现金");
    pz.setB_mon(Tu_mon);
    pz.setL_sub("人力");
    pz.setL_mon(Tu_mon);
    pz.setC_Ma_name("1");
    pz.setC_Au_name("1");
    PZInsert pzi=new PZInsert(pz);
    String sql="select max(C_id) as C_id from 凭证库表";
    Connection con=ConnectDB.connect();
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery(sql);
    if(rs.next())
    {
        newC_id=rs.getInt("C_id");
    }
    else
    {
        System.out.println("error1");
    }


    //System.out.println(newC_id);
    xfjf x=new xfjf();
    x.setT_date(date);
    x.setSt_id("3721");
    x.setSt_name("luxueling");
    x.setC_id(newC_id);
    x.setTu_mon(Tu_mon);
    x.setTu_check("Y");
    x.setTu_check_id("37458745");
    JiaoFei jiaofei=new JiaoFei(x);

    System.out.println("插入成功11");

    }

}