思路感悟
![在这里插入图片描述](https://img-blog.csdnimg.cn/9a370f355004426a8925262a511421d9.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_20,color_FFFFFF,t_70,g_se,x_16)
原始数据1
![在这里插入图片描述](https://img-blog.csdnimg.cn/40c16f4f94094a86ad48e41fb4fc398c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_17,color_FFFFFF,t_70,g_se,x_16)
class JDBCInsert
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCInsert {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String url="jdbc:mysql://127.0.0.1:3306/mobilemallsystem";
String user="root";
String password="123456";
connection = DriverManager.getConnection(url, user, password);
statement=connection.createStatement();
String sql="insert into usermessage(uname,upassword) values(121,121121),(122,122122)";
int i = statement.executeUpdate(sql);
if(i==2){
System.out.println("数据插入成功");
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
if(statement!=null){
try {
statement.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(connection!=null){
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
插入数据之后
![在这里插入图片描述](https://img-blog.csdnimg.cn/38ddbb99c70a4a12ab34848c6472870e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_19,color_FFFFFF,t_70,g_se,x_16)
原始数据2
![在这里插入图片描述](https://img-blog.csdnimg.cn/a71c85d02fd94d28962cec2d0dd4563a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_20,color_FFFFFF,t_70,g_se,x_16)
JDBCDelete
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDelete {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String url="jdbc:mysql://127.0.0.1:3306/mobilemallsystem";
String user="root";
String password="123456";
connection = DriverManager.getConnection(url, user, password);
statement=connection.createStatement();
String sql="delete from usermessage where uid=25";
int i = statement.executeUpdate(sql);
if(i==1){
System.out.println("数据删除成功");
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
if(statement!=null){
try {
statement.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(connection!=null){
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
删除数据之后
![在这里插入图片描述](https://img-blog.csdnimg.cn/91ca6ffb07754c1fa02ce33d674102cd.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_13,color_FFFFFF,t_70,g_se,x_16)
原始数据
![在这里插入图片描述](https://img-blog.csdnimg.cn/3cb0d45a05ae4938a20a174571db372d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_18,color_FFFFFF,t_70,g_se,x_16)
class JDBCUpdate
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCUpdate {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String url="jdbc:mysql://127.0.0.1:3306/mobilemallsystem";
String user="root";
String password="123456";
connection = DriverManager.getConnection(url, user, password);
statement=connection.createStatement();
String sql="update usermessage set uname='123456789',upassword='123456789' where uid=24";
int i = statement.executeUpdate(sql);
if(i==1){
System.out.println("数据更新成功");
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
if(statement!=null){
try {
statement.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(connection!=null){
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
更新数据之后
![在这里插入图片描述](https://img-blog.csdnimg.cn/6911da0cb98141efa15980ed010fab27.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAI-ecvOmVnCY=,size_15,color_FFFFFF,t_70,g_se,x_16)