jdbc工具类

package com.jdbctest.Util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCUtil {//使用静态代码块static{try {    //加载数据库驱动Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}}//连接数据库参数private static final String URL="jdbc:mysql://127.0.0.1:3306/test";         private static final String USER="root";private static final String PASSWORD="******";/** * 获取数据库连接对象 * @return Connection * @throws SQLException */public static Connection getConnection(){//return DriverManager.getConnection(URL, USER, PASSWORD);throws SQLExceptionConnection conn = null;try {conn=DriverManager.getConnection(URL,USER,PASSWORD);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}/** * 关闭已经打开的 * @param rs ResultSet 数据库结果对象 * @param stmt Statement 数据库操作对象 * @param conn Connection 数据库连接对象 */public static void close(ResultSet rs,Statement stmt,Connection conn){try {if(rs!=null) rs.close();if(stmt!= null) stmt.clearBatch();if(conn!=null) conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}