Java通过JDBC操纵mysql的例子

最新推荐文章于 2025-04-30 14:41:06 发布

wei_wei_hnu

最新推荐文章于 2025-04-30 14:41:06 发布

阅读量828

点赞数

分类专栏： java 文章标签： jdbc mysql java exception null string

本文链接：https://blog.youkuaiyun.com/wei_wei_hnu/article/details/6009911

版权

java 专栏收录该内容

4 篇文章

订阅专栏

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public final class JDBCUtils { private JDBCUtils() { } private static String url = "jdbc:mysql://localhost:3306/forum"; private static String user = "root"; private static String password = "root"; static { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { throw new ExceptionInInitializerError(e); } } public static Connection getConnection() throws SQLException { return DriverManager.getConnection(url, user, password); } public static void free(ResultSet rs, Statement st, Connection conn) { try { if (rs != null) rs.close(); } catch (SQLException e) { } finally { try { if (st != null) st.close(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } public static void main(String[] args) { // TODO Auto-generated method stub try { JDBCUtilsTest(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void JDBCUtilsTest() throws Exception { Connection conn = null; Statement st = null; ResultSet rs = null; try { conn = JDBCUtils.getConnection(); st = conn.createStatement(); rs = st.executeQuery("select * from user"); while (rs.next()) { System.out.println(rs.getObject(1) + "/t" + rs.getObject(2)); } } finally { JDBCUtils.free(rs, st, conn); } } }