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();
}
}
}
基于java EE体系核心技术之一的JDBC(与数据连接)
最新推荐文章于 2024-05-01 22:10:54 发布