数据库编程

来源：互联网发布：淘宝双11总额编辑：程序博客网时间：2024/06/06 04:51

一：创建person表

1、创建oracle用户：haizhu/haizhu

参考oracle分类中的创建用户

2、创建person表

创建语句如下：

drop table person;drop sequence myseq;create sequence myseq;create table person(id int primary key not null,name varchar2(50) not null,age int,birthday date);

二：连接 oracle 数据库

准备工作：

将 oracle 中的 oracle\10.2.0\db_1\jdbc\lib 目录下的classes12.jar，添加到工程目录，不然会找不到驱动。

1、使用statement

package haizhu.com;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.Statement;public class JDBCConnectOralce {public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";public static final String DBUSER = "haizhu";public static final String DBPASSWORD = "haizhu";public static void main(String[] args) throws Exception{Class.forName(DBDRIVER);//加载驱动程序Connection conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//链接数据库String sql = "INSERT INTO person(id,name,age) VALUES(myseq.nextVal,'向北西行',26)";Statement stmt = conn.createStatement();//执行sql语句stmt.executeUpdate(sql);conn.close();}}

2、使用 PreparedStatement

package haizhu.com;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;public class JDBCConnectOralce {public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";public static final String DBUSER = "haizhu";public static final String DBPASSWORD = "haizhu";public static void main(String[] args) throws Exception{Class.forName(DBDRIVER);//加载驱动程序Connection conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//链接数据库String sql = "INSERT INTO person(id,name,age,birthday) VALUES(myseq.nextVal,?,?,?)";PreparedStatement pstmt = conn.prepareStatement(sql);pstmt.setString(1, "海竹");pstmt.setInt(2, 26);pstmt.setDate(3, new java.sql.Date(new java.util.Date().getTime()));pstmt.executeUpdate();//执行sql语句pstmt.close();conn.close();}}

三：查询操作：ResultSet

package haizhu.com;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.Date;public class JDBCConnectOralce {public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";public static final String DBUSER = "haizhu";public static final String DBPASSWORD = "haizhu";public static void main(String[] args) throws Exception{Class.forName(DBDRIVER);//加载驱动程序Connection conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//链接数据库String sql = "SELECT * FROM person";Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql);while(rs.next()){int id = rs.getInt("id");String name = rs.getString("name");int age = rs.getInt("age");Date date = rs.getDate("birthday");System.out.println("id："+id+"、name："+name+"、age："+age+"、birthday："+date);}conn.close();}}

四：处理大数据对象

1、CLOB

2、BLOB