数据库工具类

来源：互联网发布：office for mac多少钱编辑：程序博客网时间：2024/05/21 14:58

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBUtil {

//URL="jdbc:oracle:thin:@localhost:1521:bookstore";              //Oracle  bookstore为数据库名
//URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookstore"; //SQL Server
private final static String URL="jdbc:mysql://localhost:3306/bookstore";          //MySQL
private final static String USERNAME="root";
private final static String PASSWORD="admin";
//DRIVER="oracle.jdbc.driver.OracleDriver";                                //Oracle
//DRiver="com.microsoft.jdbc.sqlserver.SQLServerDriver";             //SQL Server
private final static String DRIVER="com.mysql.jdbc.Driver";          //MySQL

public static Connection getConnect(){

Connection conn=null;

try {

//加载数据库驱动类
Class.forName(DRIVER);

//创建数据库连接对象
conn=DriverManager.getConnection(URL, USERNAME,PASSWORD);

} catch (ClassNotFoundException e) {

System.out.println("加载数据库驱动类失败");
e.printStackTrace();

  } catch (SQLException e) {
   System.out.println("创建数据库连接对象失败");
   e.printStackTrace();

}
return conn;
}

public static void closeAll(ResultSet rs,PreparedStatement ps,Connection conn){

if(conn!=null){

   try {
    conn.close();
   } catch (SQLException e) {
    System.out.println("关闭结果集");
    e.printStackTrace();
   }
  }
  if(ps!=null){
   try {
    ps.close();
   } catch (SQLException e) {
    System.out.println("关闭预执行语句");
    e.printStackTrace();
   }
  }if(conn!=null){
   try {
    conn.close();
   } catch (SQLException e) {
    System.out.println("关闭数据库连接对象");
    e.printStackTrace();
   }
  }
}

}

我是Java新手，希望以在后的学习中请大家赐教，我的QQ:1345383602;MSN:peiqianliu@msn.cn