首页 > 代码库 > JDBC初步
JDBC初步
JDBC
1 import java.sql.*; 2 3 public class TestJDBC { 4 public static void main(String[] args) { 5 ResultSet rs = null; 6 Statement stmt = null; 7 Connection conn = null; 8 try { 9 // Class是java.lang的包, 给名子把类的实例new出来 可能找不到类 抛异常ClassNotFoundException10 // 自动向drivermanager注册11 Class.forName("com.mysql.jdbc.Driver");12 String url = "jdbc:mysql://127.0.0.1:3307/world";13 conn = DriverManager.getConnection(url, "hill", "hill");14 stmt = conn.createStatement();15 rs = stmt.executeQuery("select * from city");16 while (rs.next()) {17 System.out.println(rs.getString("Name"));18 }19 } catch (ClassNotFoundException e) {20 e.printStackTrace();21 } catch (SQLException e) {22 e.printStackTrace();23 } finally {24 try {25 if (rs != null) {26 rs.close();27 }28 if (stmt != null) {29 stmt.close();30 }31 if (conn != null) {32 conn.close();33 }34 } catch (SQLException e) {35 e.printStackTrace();36 }37 }38 39 }40 41 }
DML1
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestDML { public static void main(String[] args) { Statement stmt = null; Connection conn = null; try { // Class是java.lang的包, 给名子把类的实例new出来 可能找不到类 抛异常ClassNotFoundException // 自动向drivermanager注册 Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://127.0.0.1:3307/samp_db"; conn = DriverManager.getConnection(url, "hill", "hill"); stmt = conn.createStatement(); String sql = "insert into tab_user values (02,‘hehe‘)"; stmt.executeUpdate(sql); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } }}
DML2
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestDML2 { public static void main(String[] args) { if (args.length != 2) { System.out.println("Parameter Error!"); System.exit(-1); } int num = 0; try { num = Integer.parseInt(args[0]); } catch (NumberFormatException e) { System.out.println("Parameter Error! NumberFormatException!"); System.exit(-1); } String name = args[1]; Statement stmt = null; Connection conn = null; try { // Class是java.lang的包, 给名子把类的实例new出来 可能找不到类 抛异常ClassNotFoundException // 自动向drivermanager注册 Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://127.0.0.1:3307/samp_db"; conn = DriverManager.getConnection(url, "hill", "hill"); stmt = conn.createStatement(); String sql = "insert into tab_user values " + "(" + num + ",‘" + name + "‘)"; System.out.println(sql); stmt.executeUpdate(sql); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } }}
PreparedStatement
import java.sql.*;public class TestPrepStmt { public static void main(String[] args) { if (args.length != 2) { System.out.println("Parameter Error!"); System.exit(-1); } int num = 0; try { num = Integer.parseInt(args[0]); } catch (NumberFormatException e) { System.out.println("Parameter Error! NumberFormatException!"); System.exit(-1); } String name = args[1]; PreparedStatement pstmt = null; Connection conn = null; try { // Class是java.lang的包, 给名子把类的实例new出来 可能找不到类 抛异常ClassNotFoundException // 自动向drivermanager注册 Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://127.0.0.1:3307/samp_db"; conn = DriverManager.getConnection(url, "hill", "hill"); pstmt = conn.prepareStatement("inset into tab_user values(?,?,?)"); pstmt.setInt(1,num); pstmt.setString(2,name); pstmt.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (pstmt != null) { pstmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } }}
批处理
Transaction
可滚动的结果集
JDBC初步
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。