pzinsert.java~4~

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

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

public class PZInsert {
    public PZInsert(xfbzpz pz) throws SQLException {
        try{
            Connection con=ConnectDB.connect();
        Statement st=con.createStatement();
        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);

       String term=null;
       java.sql.Date date=pz.getC_date();
       if(date.getMonth()>=3&&date.getMonth()<9)
       {
            term=(date.getYear()-1)+"--"+date.getYear()+"年第二学期";
       }
       else
       {
           if(date.getMonth()>=9)
               term=date.getYear()+"--"+(date.getYear()+1)+"年第一学期";
           else
               term=(date.getYear()-1)+"--"+date.getYear()+"年第一学期";
       }
       String querysql="select Sub_name from 科目余额表 where type=1 and Sub_nam='"+pz.getB_sub()+"' and Term='"+term+"'";
       ResultSet rs=st.executeQuery(querysql);
         if(rs.next())
         {
             float now_deb=rs.getFloat("Now_deb")+pz.getB_mon();
             float end_deb=rs.getFloat("End_deb")+pz.getB_mon();
             String  addB_subsql="update 科目余额表 set Now_deb ="+now_deb+",End_deb="+end_deb+"where type=1 and Sub_nam='"+pz.getB_sub()+"' and Term='"+term+"'";;
             st.executeUpdate(addB_subsql);
         }
         else
         {
             String addsql="insert into 科目余额表";
         }


       System.out.println("after insert");
        }
        catch(Exception e){e.printStackTrace();}

}}