package com.zzk.cn; import java.sql.*; public class TestJdbc { public static void main(String[] args) { ResultSet rs=null; Statement stmt=null; Connection conn=null; try{ System.out.println("HelloWorld!"); Class.forName("oracle.jdbc.driver.OracleDriver"); //new oracle.jdbc.driver.OracleDriver; conn=DriverManager.getConnection("","",""); stmt=conn.createStatement(); rs=stmt.executeQuery("select * from dept"); while(rs.next()){ rs.getString("deptno"); rs.getInt("id"); } }catch(ClassNotFoundException e ){ e.printStackTrace(); }catch(SQLException e ) { e.printStackTrace(); }finally { try { if(rs!=null){ rs.close(); rs=null; } } catch (SQLException e) { e.printStackTrace(); } try { if(stmt!=null) { stmt.close(); stmt=null; } } catch (SQLException e) { e.printStackTrace(); } try { if(conn!=null) { conn.close(); conn=null; } } catch (SQLException e) { e.printStackTrace(); } } } }
package com.zzk.cn; import java.sql.*; public class TestDml { public static void main(String[] args) { Statement stmt=null; Connection conn=null; try { Class.forName("oracle.jdbc.driver.OracleDrivaer"); conn=DriverManager.getConnection(""); stmt=conn.createStatement(); String sql="insert into dep values(98,'game','id')"; stmt.executeUpdate(sql); }catch (ClassNotFoundException e) { e.printStackTrace(); }catch(SQLException e) { e.printStackTrace(); }finally { try{ if(stmt!=null) { stmt.close(); stmt=null; } if(conn!=null) { conn.close(); conn=null; } }catch (SQLException e) { e.printStackTrace(); } } } }