java jdbc 工具_实现JDBC的工具类

package mysql;

/*

* 实现JDBC的工具类

* 定义方法，直接返回数据库的连接对象

*/

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class JDBCUtils {

private JDBCUtils() {

};

public static Connection con;

static {

try {

Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection

("jdbc.mysql://localhost:3306/mybase","root","root");

} catch (Exception e) {

e.printStackTrace();

}

}

/*

* 定义静态方法，返回数据库的连接对象

*/

public static Connection getConnection() {

return con;

}

public static void close(Connection con,PreparedStatement pst,ResultSet rs) {

if(con != null) {

try {

con.close();

}catch(Exception ex) {

System.out .println();

}

}

if(pst != null) {

try {

pst.close();

}catch(Exception ex) {

System.out .println();

}

}

if(rs != null) {

try {

rs.close();

}catch(Exception ex) {

System.out .println();

}

}

}

}

package mysql;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class JDBCUtilstest {

public static void main(String[] args) throws Exception {

// TODO Auto-generated method stub

Connection con = JDBCUtils.getConnection();

PreparedStatement pst = con.prepareStatement("SELECT sname FROM sort");

ResultSet rs = pst.executeQuery();

while(rs.next()) {

System.out .println("sname");

}

JDBCUtils.close(con, pst, rs);

}

}