import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* http://www.cnblogs.com/wuyuegb2312/p/3872607.html 不错的jdbc介绍博客
* http://www.cnblogs.com/S-E-P/archive/2010/09/20/2045053.html 通用Dao实现
* http://blog.csdn.net/luxiaoyu_sdc/article/details/7361714 DBUtils不错的总结说明
* @author 01
*
*/
public final class JDBCUtils {
private static final String Driver = "jdbc.mysql.jdbc.Driver";
private static final String url = "jdbc:mysql://localhost:3306/dbName";
private static final String user = "root";
private static final String password = "root";
private static Connection conn = null;
private static PreparedStatement ps = null; //SQL 语句被预编译并存储在 PreparedStatement 对象中
private static ResultSet rs = null;
private JDBCUtils(){
}
static{
try {
Class.forName(Driver);
} catch (ClassNotFoundException e) {
System.out.println("找不到驱动程序类,加载驱动失败");
e.printStackTrace();
}
}
public static Connection getConnetion(){
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
System.out.println("数据库连接失败");
e.printStackTrace();
}
return conn;
}
public static void release(Connection conn,PreparedStatement ps,ResultSet rs){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
使用properties配置文件
注意事项:配置项等号后面值均无双引号””,否则你的程序执行了不会报错,
但是没有任何反映,自动终止。
首先新建一个 jdbc.properties,新建目录为Java 项目下的scr文件夹下。
以记事本格式打开,并写入如下信息:
Driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/myProTest
user=root
password=123456
package com.jdbc;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class JDBCProperties {
private static String Driver = null;
private static String url = null;
private static String user = null;
private static String password = null;
private Connection conn = null;
static{
Properties properties = new Properties();
InputStream is =
JDBCProperties.class.getResourceAsStream("/jdbc.properties");
try {
properties.load(is);
Driver = properties.getProperty("Driver");
url = properties.getProperty("url");
user = properties.getProperty("user");
password = properties.getProperty("password");
Class.forName(Driver);
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
if(is!=null){
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
public Connection getConnection(){
try {
conn = DriverManager.getConnection(url, user, password);
if(conn!=null){
System.out.println("数据库连接成功");
}
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
JDBCProperties jdbcp = new JDBCProperties();
jdbcp.getConnection();
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* http://www.cnblogs.com/wuyuegb2312/p/3872607.html 不错的jdbc介绍博客
* http://www.cnblogs.com/S-E-P/archive/2010/09/20/2045053.html 通用Dao实现
* http://blog.csdn.net/luxiaoyu_sdc/article/details/7361714 DBUtils不错的总结说明
* @author 01
*
*/
public final class JDBCUtils {
private static final String Driver = "jdbc.mysql.jdbc.Driver";
private static final String url = "jdbc:mysql://localhost:3306/dbName";
private static final String user = "root";
private static final String password = "root";
private static Connection conn = null;
private static PreparedStatement ps = null; //SQL 语句被预编译并存储在 PreparedStatement 对象中
private static ResultSet rs = null;
private JDBCUtils(){
}
static{
try {
Class.forName(Driver);
} catch (ClassNotFoundException e) {
System.out.println("找不到驱动程序类,加载驱动失败");
e.printStackTrace();
}
}
public static Connection getConnetion(){
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
System.out.println("数据库连接失败");
e.printStackTrace();
}
return conn;
}
public static void release(Connection conn,PreparedStatement ps,ResultSet rs){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
使用properties配置文件
注意事项:配置项等号后面值均无双引号””,否则你的程序执行了不会报错,
但是没有任何反映,自动终止。
首先新建一个 jdbc.properties,新建目录为Java 项目下的scr文件夹下。
以记事本格式打开,并写入如下信息:
Driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/myProTest
user=root
password=123456
package com.jdbc;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class JDBCProperties {
private static String Driver = null;
private static String url = null;
private static String user = null;
private static String password = null;
private Connection conn = null;
static{
Properties properties = new Properties();
InputStream is =
JDBCProperties.class.getResourceAsStream("/jdbc.properties");
try {
properties.load(is);
Driver = properties.getProperty("Driver");
url = properties.getProperty("url");
user = properties.getProperty("user");
password = properties.getProperty("password");
Class.forName(Driver);
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
if(is!=null){
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
public Connection getConnection(){
try {
conn = DriverManager.getConnection(url, user, password);
if(conn!=null){
System.out.println("数据库连接成功");
}
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
JDBCProperties jdbcp = new JDBCProperties();
jdbcp.getConnection();
}
}