使用JDBC连接、使用Oracle数据库分为以下几步:
1、加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
2、获取Connection连接
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@127.0.0.1:1521:SCNUARAIN";
String user="scott";
Connection conn = DriverManager.getConnection(url, user, password);
3、获取操作sql语句的statement对象
Statement state=conn.createStatement();
4、使用statement对象执行sql语句
state.executeUpdate("insert into student1 select * from student1");
5、关闭statement对象
state.close();
完整的操作代码如下:
package jdbc;
import java.sql.*;
public class Jdbctest
{
public static void main(String[] args) throws SQLException
{
Jdbctest jdbc=new Jdbctest();
//1、获取数据库连接
Connection conn=jdbc.getConnection();
//2、准备插入的SQL语句
String sql="insert into student1 select * from student1";
//4、执行插入
//1)获取操作sql语句的statement对象,调用Connection的createstatement()来获取
Statement state=conn.createStatement();
//2)使用statement对象执行sql语句
state.executeUpdate(sql);
//5、关闭statement对象
state.close();
}
private Connection getConnection()
{
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@127.0.0.1:1521:SCNUARAIN";
String user="scott";
String password="tiger";
Connection conn=null;
try
{
// 1、加载驱动
Class.forName(driver);
// 2、得到连接
conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
}
catch (Exception e)
{
e.printStackTrace();
}
return conn;
}
}