Check_50_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.Receive_50_info;


public class Check_50_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;

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("url2");
USER=props.getProperty("user2");
PASSWORD=props.getProperty("pwd2");

  
}

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 sql0=null;
String sql1=null;
String sql2=null;
int info_number_qq=0;
int info_number_apliay=0;
int info_number=0;
//Receive_50_info rec50=new Receive_50_info();Re
Receive_50_info r=new Receive_50_info();

long V_WAYBILLNO3=r.getBno();
System.out.println("变量值"+V_WAYBILLNO3);
try{Thread.sleep(40000);
}catch(InterruptedException e){e.printStackTrace();}

try {
 
statement=con.createStatement();
sql0="select count(1) info_number from ccw_push_record where bno='"+V_WAYBILLNO3+"'"+ "and order_channel=3"+ "and rsp_code in ('0','000','200')";
sql1="select count(1) info_number from ccw_push_record where bno='"+V_WAYBILLNO3+"'"+ "and order_channel=1"+ "and rsp_code in ('0','000','200')";
sql2="select count(1) nomber from TLS_ALIPAY_EXPRESS_STATE where phone ='13421841858' and bno='"+V_WAYBILLNO3+"'";
//statement.executeQuery(sql0);
ResultSet result1 = statement.executeQuery(sql0);
System.out.println(sql0);
//System.out.println("推送手 Q消息条数："+ info_number);

while(result1.next()){
info_number_qq=result1.getInt("info_number");
System.out.println("推送手Q消息条数："+info_number_qq);


}
if (info_number_qq==0)
{
System.out.println("手Q收件人50消息推送失败！");
}
else if(info_number_qq==1)
{
System.out.println("手Q收件人50消息推送成功！");
}
else
{System.out.println("手Q收件人50消息重复推送！");}
ResultSet result2 = statement.executeQuery(sql1);
while(result2.next()){
info_number_apliay=result2.getInt("info_number");
System.out.println("支付宝收件人50消息条数："+info_number_apliay);


}
if (info_number_apliay==0)
{
System.out.println("支付宝收件人50消息推送失败！");
}
else if(info_number_apliay==1)
{
System.out.println("支付宝收件人50消息推送成功！");
}
else
{System.out.println("支付宝收件人50消息重复推送！");}
ResultSet result3 = statement.executeQuery(sql2);
while(result3.next()){
info_number=result3.getInt("nomber");
System.out.println("进入TLS_ALIPAY_EXPRESS_STATE表的该运单记录数："+info_number);


}

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


//ResultSet result = statement.executeQuery(sql0);
}


}