package ccwp;
import java.io.IOException;
import java.io.InputStream;
import java.security.PublicKey;
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.Return_willnumber;
public class Ccw_push_record_temp_50 {
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;
Return_willnumber r=new Return_willnumber();
String bno=r.receive_Bno();
String sql10=null;
String sql11=null;
String sql2="commit";
//System.out.println(sql10);
try {
statement=con.createStatement();
sql10="delete from CCW_PUSH_RECORD_TEMP where BNO='"+bno+"'";
System.out.println(sql10);
statement.executeQuery(sql10);
statement.executeQuery(sql2);
sql11="insert into CCW_PUSH_RECORD_TEMP (ID, BNO, PHONE, B_TYPE, CREATE_TIME, UPDATE_TIME)"+
"values (seq_ccw_push_record_temp.nextval,'" +bno+"'"+", '13692212840', '50', sysdate, null)";
System.out.println(sql11);
statement.executeQuery(sql11);
statement.executeQuery(sql2);
}
catch (SQLException e) {
e.printStackTrace();
}
}
public String bno_from_recordtemp()
{
Connection con = getConnection();
Statement statement = null;
Return_willnumber r=new Return_willnumber();
String bno=r.receive_Bno();
String sql10=null;
String sql11=null;
String sql2="commit";
//System.out.println(sql10);
try {
statement=con.createStatement();
sql10="delete from CCW_PUSH_RECORD_TEMP where BNO='"+bno+"'";
System.out.println(sql10);
statement.executeQuery(sql10);
statement.executeQuery(sql2);
sql11="insert into CCW_PUSH_RECORD_TEMP (ID, BNO, PHONE, B_TYPE, CREATE_TIME, UPDATE_TIME)"+
"values (seq_ccw_push_record_temp.nextval,'" +bno+"'"+", '13692212840', '50', sysdate, null)";
System.out.println(sql11);
statement.executeQuery(sql11);
statement.executeQuery(sql2);
}
catch (SQLException e) {
e.printStackTrace();
}
return bno;
}
}
import java.io.IOException;
import java.io.InputStream;
import java.security.PublicKey;
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.Return_willnumber;
public class Ccw_push_record_temp_50 {
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;
Return_willnumber r=new Return_willnumber();
String bno=r.receive_Bno();
String sql10=null;
String sql11=null;
String sql2="commit";
//System.out.println(sql10);
try {
statement=con.createStatement();
sql10="delete from CCW_PUSH_RECORD_TEMP where BNO='"+bno+"'";
System.out.println(sql10);
statement.executeQuery(sql10);
statement.executeQuery(sql2);
sql11="insert into CCW_PUSH_RECORD_TEMP (ID, BNO, PHONE, B_TYPE, CREATE_TIME, UPDATE_TIME)"+
"values (seq_ccw_push_record_temp.nextval,'" +bno+"'"+", '13692212840', '50', sysdate, null)";
System.out.println(sql11);
statement.executeQuery(sql11);
statement.executeQuery(sql2);
}
catch (SQLException e) {
e.printStackTrace();
}
}
public String bno_from_recordtemp()
{
Connection con = getConnection();
Statement statement = null;
Return_willnumber r=new Return_willnumber();
String bno=r.receive_Bno();
String sql10=null;
String sql11=null;
String sql2="commit";
//System.out.println(sql10);
try {
statement=con.createStatement();
sql10="delete from CCW_PUSH_RECORD_TEMP where BNO='"+bno+"'";
System.out.println(sql10);
statement.executeQuery(sql10);
statement.executeQuery(sql2);
sql11="insert into CCW_PUSH_RECORD_TEMP (ID, BNO, PHONE, B_TYPE, CREATE_TIME, UPDATE_TIME)"+
"values (seq_ccw_push_record_temp.nextval,'" +bno+"'"+", '13692212840', '50', sysdate, null)";
System.out.println(sql11);
statement.executeQuery(sql11);
statement.executeQuery(sql2);
}
catch (SQLException e) {
e.printStackTrace();
}
return bno;
}
}