mysql好java实例_最轨范的java连接mysql的实例

最规范的java连接mysql的实例

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestJDBC { public static void main(String[] args) { Connection conn = null; Statement stmt = null; ResultSet rs = null; String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost/mydata?user=root&password=root"; String sql = "select * from dept"; try { Class.forName(driver); conn = DriverManager.getConnection(url, "root", "root"); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next()) { System.out.println(rs.getString("deptno")); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { System.out.println("SQLException: " + e.getMessage()); System.out.println("SQLState: " + e.getSQLState()); System.out.println("VendorError: " + e.getErrorCode()); } finally { try { if (rs != null) { rs.close(); rs = null; } if (stmt != null) { stmt.close(); stmt = null; } if (conn != null) { conn.close(); conn = null; } } catch (SQLException e) { e.printStackTrace(); } } } }

欢迎大家阅读《最轨范的java连接mysql的实例》,跪求各位点评，by 搞代码

1 楼 wildpointer 2011-04-12

程序没问题。

就是没有注释。

应该再说说java-connect怎么设置。

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~