java 动态拼接sql_用java 代码，动态修改，拼接sql、执行

1、用java 代码，动态修改，拼接sql、执行

waybillNo.sql 文件中内容

425787921414,

425404118389,

425067648257,

2、链接数据库

package test;

import java.sql.DriverManager;

import java.sql.SQLException;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.PreparedStatement;

public class DBHelper {

public static final String url = "jdbc:mysql://172.0.0.0/test";

public static final String name = "com.mysql.jdbc.Driver";

public static final String user = "root";

public static final String password = "test";

public Connection conn = null;

public PreparedStatement pst = null;

public DBHelper(String sql) {

try {

Class.forName(name);//指定连接类型

conn = (Connection) DriverManager.getConnection(url,user,password);//获取连接

pst = (PreparedStatement) conn.prepareStatement(sql);//准备执行语句

} catch (Exception e) {

e.printStackTrace();

}

}

public void close() {

try {

this.conn.close();

this.pst.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

3、

/**

*

*/

/**

* @author

*

*/

package test;

import java.io.BufferedReader;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;