基于javaEE的结构体系之jdbc

来源：互联网发布：淘宝客如何做推广编辑：程序博客网时间：2024/05/22 03:09
package com.neusoft.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JdbcOracleTest {/** * @param args */public static void main(String[] args) {// 2.建立同数据库的连接// url:统一资源定位符String url = "jdbc:oracle:thin:@10.25.85.247:1521:orcl";//ciassName表示类的描述符的字符串String user = "scott";String password = "tiger";Connection con = null;Statement st = null;       String sql = "select * from DEPT";String sql1 = "delete from USERTEST";ResultSet rs = null;PreparedStatement pst = null;  // 1.加载驱动try {Class.forName("oracle.jdbc.driver.OracleDriver");con = DriverManager.getConnection(url, user, password);System.out.println("数据库连接成功！");//取消自动提交事务con.setAutoCommit(false);// 3.取得statement对象st = con.createStatement();// 4.发送statement到oracle中，并且查询表rs = st.executeQuery(sql);// 5.取出结果集中的数据      while (rs.next()) {System.out.println("*************************");String deptno = rs.getString(1);System.out.println(deptno);String dname = rs.getString(2);System.out.println(dname);      String loc = rs.getString(3);System.out.println(loc);System.out.println("*************************");}//6.删除数据            //int i=st.executeUpdate(sqll);//System.out.println("删除的记录条数："+1)；//7.高级-->?占位符pst=con.prepareStatement("insert into USERTEST values(?,?,?)");//给占位符赋值-->通过serXxx（）方法pst.setString(1, "5");pst.setString(2, "u5");pst.setString(3, "p5");int i=pst.executeUpdate();System.out.println("插入的记录的条数:"+i);//事务处理-->提交con.commit();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();      } catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();try{//事务处理-->回滚con.rollback();}catch (SQLException e1){//TODO Auto-generated catch blocke1.printStackTrace();}}// 6.关闭资源try {if (rs != null) {rs.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}try {if (st != null) {st.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}try {if (con != null) {con.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}
输出结果
40
OPERATIONS
BOSTON
*************************
插入的记录的条数:1