基于java EE体系核心技术之一的JDBC（与数据连接）

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 {
	public static void main(String[] args) {
		//2.建立与数据库的连接
		   //ur1：统一资源定位符
			String url="jdbc:oracle:thin:@10.25.84.116:1521:orcl";
			String user="scott";
			String password="tiger";
			Connection con=null;
			Statement st=null;
			String sql="select*from EMP";
			String sql1="select*from DATA";
			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 empno=rs.getString(1);
					System.out.println("empno");
					String ename=rs.getString(2);
					System.out.println("ename");
					String job=rs.getString(3);
					System.out.println("job");
					String mgr=rs.getString(4);
					System.out.println("mgr");
					String hiredate=rs.getString(5);
					System.out.println("hiredate");
					String sal=rs.getString(6);
					System.out.println("sal");
					String comm=rs.getString(7);
					System.out.println("comm");
					String deptno=rs.getString(8);
					System.out.println("deptno");
					System.out.println("------------------");}
			//6.删除数据
			//int i=st.executeUpdate(sql1);
			//System.out.println("删除的记录的条数："+i);
			//7.高级-->?占位符
			pst=con.prepareStatement("insert into DATA values(?,?,?)");
			//给占位符赋值-->通过setXxx()方法
			pst.setString(1,"4");
			pst.setString(2,"LILI");
			pst.setString(3,"456");
			int i=pst.executeUpdate();
			System.out.println("插入的记录的条数："+i);
			//事务处理-->提交
			con.commit();
			}catch (ClassNotFoundException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				//事务处理-->回滚
					try {
						con.rollback();
					} catch (SQLException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
				}

				// 6.关闭资源
				try {
					if (rs != null) {
						rs.close();
					}

				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				try {
					if (st != null) {
						st.close();
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				try {
					if (con != null) {
						con.close();
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}

		}