3、为了使JDBC用起来更加的方便,进行MyJDBCUtils的包装

来源：互联网发布：淘宝现金红包怎么领编辑：程序博客网时间：2024/06/13 19:06

1、为了使JDBC用起来更加的方便,进行MyJDBCUtils的包装，利用MyJDBCUtils对外提供,操作数据的方法

2、MyJDBCUtils的代码如下

package com.jdbc.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MyJDBCUtils {static String url = "jdbc:mysql://localhost:3306/testdatabase";static String username = "root";static String password = "1234";static {try {Class.forName("com.mysql.jdbc.Driver");} catch (Exception e) {throw new ExceptionInInitializerError(e);}}public static Connection getConnection() {Connection conn = null;try {conn = DriverManager.getConnection(url, username, password);} catch (SQLException e) {throw new RuntimeException("获取连接Mysql数据库连接失败");}return conn;}public static void release(Connection conn, Statement st, ResultSet rs) {if (rs != null) {try {rs.close();} catch (Exception e) {throw new RuntimeException("ResultSet关闭异常");}rs = null;}if (st != null) {try {st.close();} catch (Exception e) {throw new RuntimeException("Statement关闭异常");}st = null;}if (conn != null) {try {conn.close();} catch (Exception e) {throw new RuntimeException("Connection关闭异常");}conn = null;}}}

3、使用MyJDBCUtils进行Mysql的访问代码如下

package com.jdbc.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import org.junit.Test;public class TestMyJDBCUtils {@Testpublic void testMyJDBCUtils() {Connection conn = null;Statement st = null;ResultSet rs = null;try {conn = MyJDBCUtils.getConnection();st = conn.createStatement();rs = st.executeQuery("select * from user  ");while (rs.next()) {int id = rs.getInt(rs.findColumn("id"));String uname = rs.getString(rs.findColumn("uname"));int age = rs.getInt(rs.findColumn("age"));// 遍历输出System.out.println("id " + id + " " + "uname " + uname + " "+ "age " + age + " ");}} catch (Exception e) {throw new RuntimeException(e);} finally {// 释放资源MyJDBCUtils.release(conn, st, rs);}}}

4、程序的访问结果

1 0