//数据库连接工具类
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ResourceBundle;
public class JdbcUtil {
private static final String DRIVER;
private static final String URL;
private static final String NAME;
private static final String PWD;
static{
ResourceBundle rb=ResourceBundle.getBundle(“db”);
DRIVER=rb.getString(“oracledriver”);
URL=rb.getString(“url”);
NAME=rb.getString(“name”);
PWD=rb.getString(“pwd”);
}
static{
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
static Connection conn=null;
public static Connection getConnection(){
try {
封装sql语句查询(简单版),你只需要输入sql语句和所需参数就可以得到结果了
最新推荐文章于 2022-12-30 21:27:44 发布