Send_80_info

package ccwp;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
//import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import ccwp.Ccw_push_record_temp_50;
public class Send_80_info {
private static String db_config="db_config.properties";
public static String DRIVERS=null;
public static String USER=null;
public static String URL=null;
public static String PASSWORD=null;
public static  long V_WAYBILLNO2;


static{
Properties props=new Properties();
InputStream inStr=null;
try{
inStr=ClassLoader.getSystemResourceAsStream(db_config);
props.load(inStr);
}catch (IOException e){
e.printStackTrace();
}
DRIVERS=props.getProperty("drivers");
URL=props.getProperty("url");
USER=props.getProperty("user");
PASSWORD=props.getProperty("pwd");

  
}

public static Connection getConnection(){
Connection con = null;
 try{   
   con =  DriverManager.getConnection(URL , USER , PASSWORD ) ;   
    }catch(SQLException se){   
   System.out.println("数据库连接失败！");   
   se.printStackTrace() ;   
    } 
 return con;}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con = getConnection();
Statement statement = null;
String sql1=null;
String sql2=null;
String sql3="commit";
Ccw_push_record_temp_50 r=new Ccw_push_record_temp_50();
String V_WAYBILLNO=r.bno_from_recordtemp();
try {
statement=con.createStatement();
sql1="insert into tt_bar_record" +
"(" +
"BAR_RECORD_ID," +
"WAYBILL_NO," +
"ZONE_CODE," +
"OP_CODE," +
"OP_ATTACH_INFO," +
"COURIER_CODE," +
"BAR_OPR_CODE," +
"BAR_UPLOAD_TM," +
"OBJ_TYPE_CODE," +
"CONTNR_CODE," +
"PAY_FLG," +
"STAY_WHY_CODE," +
"SUBBILL_PIECE_QTY," +
"BAR_UPLOAD_TYPE_CODE," +
"WEIGHT_QTY," +
"FEE_AMT," +
"ACCOUNTANT_CODE," +
"OTHER_INFO," +
"OP_NAME," +
"ZONE_TYPE_CODE," +
"ENCRYPT_STRING," +
"BAR_SN," +
"SCHEDULE_CODE," +
"SIGN_TYPE_CODE," +
"SRC_CONTNR_CODE," +
"PHONE_ZONE," +
"PHONE," +
"STOP_OVER_FLG," +
"BATCH_CODE," +
"DEST_ZONE_CODE," +
"AUTOLOADING," +
"BAR_SCAN_TM," +
"BAR_SCAN_DT," +
"EXTEND_ATTACH_1," +
"EXTEND_ATTACH_2," +
"BAR_UPLOAD_OPR_CODE," +
"EXTEND_ATTACH_3," +
"EXTEND_ATTACH_4," +
"EXTEND_ATTACH_5," +
"EXTEND_ATTACH_6," +
"EXTEND_ATTACH_7," +
"BAR_UPLOAD_TM_STD," +
"BAR_SCAN_TM_STD" +
")" +
"values" +
"(" +
V_WAYBILLNO +
","+
V_WAYBILLNO +
","+
"'755A'," +
"'80'," +
"''," +
"'046154'," +
"'1000005565'," +
"sysdate," +
"20," +
"''," +
"0," +
"''," +
"0," +
"0," +
"'1.000'," +
"0.0000," +
"''," +
"'T4'," +
"'派件中'," +
"0," +
"'424'," +
"'V6.6.2'," +
"''," +
"0," +
"''," +
"'755'," +
"''," +
"0," +
"''," +
"''," +
"'1'," +
"sysdate," +
"sysdate," +
"''," +
"''," +
"'171403'," +
"''," +
"''," +
"''," +
"''," +
"sysdate," +
"sysdate," +
"sysdate" +
")";
V_WAYBILLNO2 = Long.parseLong(V_WAYBILLNO);
sql2="INSERT INTO tt_bar_record_log (record_id) SELECT bar_record_id FROM tt_bar_record WHERE waybill_no ='"+V_WAYBILLNO2+"'";
System.out.println(sql2);
statement.executeQuery(sql1);
statement.executeQuery(sql3);
statement.executeQuery(sql2);
statement.executeQuery(sql3);
}
catch (SQLException e) {
e.printStackTrace();
}
}
public long getBno(){
Connection con = getConnection();
Statement statement = null;
String sql1=null;
String sql2=null;
String sql3="commit";
Ccw_push_record_temp_50 r=new Ccw_push_record_temp_50();
String V_WAYBILLNO=r.bno_from_recordtemp();
try {
statement=con.createStatement();
sql1="insert into tt_bar_record" +
"(" +
"BAR_RECORD_ID," +
"WAYBILL_NO," +
"ZONE_CODE," +
"OP_CODE," +
"OP_ATTACH_INFO," +
"COURIER_CODE," +
"BAR_OPR_CODE," +
"BAR_UPLOAD_TM," +
"OBJ_TYPE_CODE," +
"CONTNR_CODE," +
"PAY_FLG," +
"STAY_WHY_CODE," +
"SUBBILL_PIECE_QTY," +
"BAR_UPLOAD_TYPE_CODE," +
"WEIGHT_QTY," +
"FEE_AMT," +
"ACCOUNTANT_CODE," +
"OTHER_INFO," +
"OP_NAME," +
"ZONE_TYPE_CODE," +
"ENCRYPT_STRING," +
"BAR_SN," +
"SCHEDULE_CODE," +
"SIGN_TYPE_CODE," +
"SRC_CONTNR_CODE," +
"PHONE_ZONE," +
"PHONE," +
"STOP_OVER_FLG," +
"BATCH_CODE," +
"DEST_ZONE_CODE," +
"AUTOLOADING," +
"BAR_SCAN_TM," +
"BAR_SCAN_DT," +
"EXTEND_ATTACH_1," +
"EXTEND_ATTACH_2," +
"BAR_UPLOAD_OPR_CODE," +
"EXTEND_ATTACH_3," +
"EXTEND_ATTACH_4," +
"EXTEND_ATTACH_5," +
"EXTEND_ATTACH_6," +
"EXTEND_ATTACH_7," +
"BAR_UPLOAD_TM_STD," +
"BAR_SCAN_TM_STD" +
")" +
"values" +
"(" +
V_WAYBILLNO +
","+
V_WAYBILLNO +
","+
"'755A'," +
"'80'," +
"''," +
"'046154'," +
"'1000005565'," +
"sysdate," +
"20," +
"''," +
"0," +
"''," +
"0," +
"0," +
"'1.000'," +
"0.0000," +
"''," +
"'T4'," +
"'派件中'," +
"0," +
"'424'," +
"'V6.6.2'," +
"''," +
"0," +
"''," +
"'755'," +
"''," +
"0," +
"''," +
"''," +
"'1'," +
"sysdate," +
"sysdate," +
"''," +
"''," +
"'171403'," +
"''," +
"''," +
"''," +
"''," +
"sysdate," +
"sysdate," +
"sysdate" +
")";
V_WAYBILLNO2 = Long.parseLong(V_WAYBILLNO);
sql2="INSERT INTO tt_bar_record_log (record_id) SELECT bar_record_id FROM tt_bar_record WHERE waybill_no ='"+V_WAYBILLNO2+"'";
System.out.println(sql2);
statement.executeQuery(sql1);
statement.executeQuery(sql3);
statement.executeQuery(sql2);
statement.executeQuery(sql3);
}
catch (SQLException e) {
e.printStackTrace();
}
return V_WAYBILLNO2;
}
}