关键步骤
//1,导入驱动,加载具体驱动类
Class.forName("oracle.jdbc.OracleDriver");//加载具体驱动类
//2,与数据库建立连接
connection = DriverManager.getConnection(URL,USERNAME,PWD);
//3,执行sql语句,用来创建一个连接的statement即stmt ,有了stmt就可以执行了。
stmt = connection.createStatement();
String sql = "insert into student values(10,'李白',20,'s2')";
stmt.executeUpdate(sql);
增加操作
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCdemo01 {
private static final String URL="jdbc:oracle:thin:@localhost:1521:ORCL";
private static final String USERNAME="scott";
private static final String PWD="tiger";
public static void update() {//增删改
Connection connection =null;
Statement stmt = null;
try {
//1,导入驱动,加载具体驱动类
Class.forName("oracle.jdbc.OracleDriver");//加载具体驱动类
//2,与数据库建立连接
connection = DriverManager.getConnection(URL,USERNAME,PWD);
//3,执行sql语句,用来创建一个连接的statement即stmt
stmt = connection.createStatement();
//有了stmt就可以执行了。
String sql = "insert into student values(10,'李白',20,'s2')";
int count = stmt.executeUpdate(sql);//返回值表示增删改了 多少条数据
//4,处理结果集
if(count>0) {
System.out.println("操作成功!");
}
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}finally{
try {
if(stmt!=null) stmt.close();
if(connection!=null) connection.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
update();
}
}
修改操作
String sql = "update student set stuname='韩信' where stuno=1";
删除操作(只需要改sql即可)
String sql = "delete from student where stuno=2";