import java.sql.*;
public class Demo {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1注册驱动
Class.forName("com.mysql.jdbc.Driver");
//2建立连接
String url = "jdbc:mysql://localhost:3306/mydb01";
String usernName = "xxx"; //登录数据库的账号
String password = "xxxx"; //登录数据库的密码
Connection conn = DriverManager.getConnection(url, usernName, password);
//3获取执行sQL语句的对象
Statement statement = conn.createStatement();
//4获取数据库返回的结果
String sql = "delete from emp where empno = " +"xxx";
String sqlUpdate = "update emp set sal = "+10000+" where empno = " +"7369";
String sqlInsert = "INSERT INTO emp VALUES(2018,\"boss\",\"king\",NULL,\"2018-8-
8\",15000,10000,10);";
//5处理数据集
int i = statement.executeUpdate(sql);
int s = statement.executeUpdate(sqlUpdate);
int ins = statement.executeUpdate(sqlInsert);
System.out.println(i + "行受到影响----删除");
System.out.println(s + "行受到影响----更新");
System.out.println(ins + "行受到影响----插入");
//6关闭连接
statement.close();
conn.close();
}
}
1.加载JDBC驱动 oracle.jdbc.OracleDriver/com.mysql.jdbc.Driver
2.创建连接对象 connection
3.创建statement对象
statement(静态sql)
preparedStatement (动态sql)
executeQuery():查,返回数据集
executeUpdate():增删改,返回int的数据,影响的行数
4.获取操作对象 发送sql返回执行结果
5.处理执行结果
6.释放资源 关闭顺序 resultSet preparedStatement connection