封装的DButil.java,负责数据库连接:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.ethan.util;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Administrator
*/
public class DBUtil {
private static final String url = "jdbc:mysql://localhost:3306/test";
private static final String username = "root";
private static final String password = "";
//private DBUtil dbUtil = null;
private DBUtil() {
}
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
Logger.getLogger(DBUtil.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static Connection getConn() {
try {
return DriverManager.getConnection(url,username,password);
} catch (SQLException ex) {
Logger.getLogger(DBUtil.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
public static PreparedStatement getPstmt(Connection conn, String sql) {
try {
return conn.prepareStatement(sql);
} catch (SQLException ex) {
Logger.getLogger(DBUtil.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
public static ResultSet getRs(PreparedStatement pstmt) {
try {
return pstmt.executeQuery();
} catch (SQLException ex) {
Logger.getLogger(DBUtil.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
public static void close(Connection conn,Statement stmt, ResultSet rs) {
if(conn!=null) {
try {
conn.close();
conn = null;
} catch (SQLException ex) {
Logger.getLogger(DBUtil.class.getName()).log(Level.SEVERE, null, ex);
} finally {
if(stmt!=null) {
try {
stmt.close();
stmt = null;
} catch (SQLException ex) {
Logger.getLogger(DBUtil.class.getName()).log(Level.SEVERE, null, ex);
} finally {
if(rs!=null) {