两个服务器之间的数据数据交换的核…

//内容经供参考,以下代码是运行成功后的结果.切莫copy,拒绝只做理论帝,努力成为手工王,高手请留言,让大家一起学习进步,壮大我大程序员

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import OA.DBSql.OADBSql;  //这个是之前我发布的JDBC连接直接将两个连接类修改对应的数据库连接就可以了
import U8.DBSql.U8DBSql;  //这个是之前我发布的JDBC连接直接将两个连接类修改对应的数据库连接就可以了

public class InsertPINO {

 
 public boolean InsertPI(){
  //String OAsql="select * from BO_OM_PI where CONVERT(varchar(12) , UPDATEDATE, 23 )= CONVERT(varchar(12) , getdate(), 23 )";
  String OAsql="select UPDATEUSER,CUSTDH,BINDID,ID,DATE,PINO,ZBFL,CREATEUSER,REMARK,CUSTNAME,PITYPE from BO_OM_PI";
  String sql2 = "insert into BO_OM_PI values(?,?,?,?,?,?,?,?,?,?,?)";
  List OAlist=OADBSql.GetLIst(OAsql, 11);
  PreparedStatement pst = null;
  Connection conn = U8DBSql.getConnecton();
  try {
   pst = conn.prepareStatement(sql2);
  ResultSet rs = null;
  for(List OAuplist: OAlist){
   for(int i=0;i<11;i++){
    int t=i+1;
    pst.setString(t, (String) OAuplist.get(i));
   }
   pst.addBatch();
  }
  pst.executeBatch();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return true;
 }
 
 public boolean InsertPIS(){
  String OAsql="SELECT ID, BINDID, CREATEDATE, CREATEUSER, ITEM, DESCRIPTION, QTY, UNITPRICE, SUBTOTAL, REMARKS, SKUNO FROM dbo.BO_OM_PI_S";
  String sql2 = "insert into BO_OM_PI_S values(?,?,?,?,?,?,?,?,?,?,?)";
  List OAlist=OADBSql.GetLIst(OAsql, 11);
  PreparedStatement pst = null;
  Connection conn = U8DBSql.getConnecton();
  try {
   pst = conn.prepareStatement(sql2);
  ResultSet rs = null;
  for(List OAuplist: OAlist){
   for(int i=0;i<11;i++){
    int t=i+1;
    pst.setString(t, (String) OAuplist.get(i));
   }
   pst.addBatch();
  }
  pst.executeBatch();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return true;
 }
 public static void main(String[] args) {
  //InsertPINO.QUER().InsertPI();
  InsertPINO.QUER().InsertPIS();
  System.out.println("执行成功!");
   }
 public static InsertPINO QUER(){
  return new InsertPINO();
 }
}