jdbc操作数据库的步骤： 加载驱动->获得数据库连接->创建操作数据库的连接对象->写sql语句->执行sql语句。
1 //testODBC.OdbcTest.java 2 // 3 package testODBC; 4 5 import java.sql.Connection; 6 import java.sql.DriverManager; 7 import java.sql.SQLException; 8 import java.sql.Statement; 9 10 public class OdbcTest { 11 static Connection conn = null; 12 static Statement stm = null; 13 public static void main(String[] args) { 14 //不带参数的sql语句 ，删除语句 15 //String str = "delete emp where empno = 7456"; 16 17 //带参数的sql语句 18 String strname = "d国的"; 19 int empno = 7456; 20 //单引号的问题，字符注意带单引号。。更新语句 21 //String str = "update emp set ename = '" + strname + "' where empno = " + "'" + empno + "'"; 22 //插入语句 23 String str = "insert into emp(empno,ename) values ('"+empno + "','" + strname+"')"; 24 addDelModify(str); 25 } 26 private static void addDelModify(String str) { 27 try { 28 Class.forName( "oracle.jdbc.driver.OracleDriver");// 加载驱动 29 String url = "jdbc:oracle:thin:@localhost:1521:ORCL";// 访问oracle路径 30 conn = DriverManager.getConnection(url, "scott", "tiger");//获得数据库连接 31 stm = conn.createStatement(); 32 //执行sql语句并返回布尔值，返回false，表示执行成功。否则执行失败 33 /*boolean bool = stm.execute(str); 34 System.out.println(bool);*/ 35 //执行sql语句返回整数值，表示改变的行数 36 int lines = stm.executeUpdate(str); 37 System.out.println(lines); 38 } catch (ClassNotFoundException e) { 39 // TODO Auto-generated catch block 40 e.printStackTrace(); 41 } catch (SQLException e) { 42 // TODO Auto-generated catch block 43 e.printStackTrace(); 44 }finally{ 45 try { 46 //关闭statement 47 stm.close(); 48 //关闭数据库连接 49 if (conn.isClosed()) { 50 System.out.println("连接已经关闭！"); 51 } else { 52 conn.close(); 53 System.out.println("执行关闭连接！"); 54 } 55 } catch (SQLException e) { 56 // TODO Auto-generated catch block 57 e.printStackTrace(); 58 } 59 60 } 61 } 62 }
转载于:https://www.cnblogs.com/dgq-blog/p/6393915.html
