package com.neusoft.hello;
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 Oracle {
/**
* @param args
*/
public static void main(String[] args) {
//2.建立同数据库的连接
//url:统一资源定位符
String url="jdbc:oracle:thin:@10.25.84.147:1521:orcl";//10.25.84.147为本机的Ip地址
String user="scott";
String password="tiger";
Connection con=null;
Statement st=null;
String sql="select * from DEPT";
String sql1="insert *from USERTEXT"; //两个数据库文件
ResultSet rs=null;
ResultSet rss=null;
PreparedStatement pst=null;
//1.加载驱动
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(url,user,password);
System.out.println("数据库连接成功!");
con.setAutoCommit(false);//取消自动提交事务
st=con.createStatement();//3.取得statement对象
rs=st.executeQuery(sql);//4.发送statement到Oracle中,并且查询表
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("*************");
}
//int i=st.executeUpdate(sql1);
//System.out.ptintln("删除的记录的条数为:"+i);//删除数据
//7.高级-->占位符
pst=con.prepareStatement("insert into USERTEXT values(?,?,?)"); //USERTEXT自己建的表,
pst.setString(1,"5");//给占位符赋值,通过setXXX方法
pst.setString(2,"55");
pst.setString(3,"555");
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 (pst != null) {
pst.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(); }
}//
}//