下订单试验ccwp

最新推荐文章于 2024-12-04 10:24:14 发布

原创最新推荐文章于 2024-12-04 10:24:14 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#自动化测试学习--Selenium

Selenium 专栏收录该内容

22 篇文章

订阅专栏

本文介绍了一个Java程序，该程序从数据库中获取最大的运单号，并在此基础上递增生成新的运单号。通过配置文件读取数据库连接信息，使用PreparedStatement执行SQL查询，最后返回最新的运单号。

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;
public class Return_willnumber {
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) {
Connection con = getConnection();
Statement statement = null;
String sql0=null;
long V_WAYBILLNO_long=0;
String V_WAYBILLNO="";
// TODO Auto-generated method stub
try {

statement=con.createStatement();
sql0="select max(t.waybill_no) max_no from tt_bar_record t where t.waybill_no like '723%'";
ResultSet result = statement.executeQuery(sql0);
while(result.next()){
V_WAYBILLNO_long=result.getLong("max_no");
}
V_WAYBILLNO_long=V_WAYBILLNO_long+1;
V_WAYBILLNO=String.valueOf(V_WAYBILLNO_long);

//System.out.println(V_WAYBILLNO_long);//打印出要测试的运单号
System.out.println(V_WAYBILLNO);//打印出要测试的运单号
}
catch (SQLException e) {
e.printStackTrace();
}

}
public String receive_Bno(){
Connection con = getConnection();
Statement statement = null;
String sql0=null;
long V_WAYBILLNO_long=0;
String V_WAYBILLNO="";
// TODO Auto-generated method stub
try {

statement=con.createStatement();
sql0="select max(t.waybill_no) max_no from tt_bar_record t where t.waybill_no like '723%'";
ResultSet result = statement.executeQuery(sql0);
while(result.next()){
V_WAYBILLNO_long=result.getLong("max_no");
}
V_WAYBILLNO_long=V_WAYBILLNO_long+1;
V_WAYBILLNO=String.valueOf(V_WAYBILLNO_long);

//System.out.println(V_WAYBILLNO_long);//打印出要测试的运单号
System.out.println(V_WAYBILLNO);//打印出要测试的运单号
}
catch (SQLException e) {
e.printStackTrace();
}
return V_WAYBILLNO;
}
}