1.连接数据库工具类
package jdbc.jdbcutils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ResourceBundle;
//import java.util.Properties;
//import java.io.IOException;
//import java.io.InputStream;
public class JdbcUtils {
// static Properties pros=new Properties();
static String url = null;
static String user = null;
static String password = null;
static {
// pros.load(is);
ResourceBundle bundle=ResourceBundle.getBundle(“jdbc”);
url=bundle.getString(“url”);
user=bundle.getString(“user”);
password=bundle.getString(“password”);
//加载驱动
try {
Class.forName(bundle.getString(“driver”));
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}