文章目录
思路感悟原始数据1class JDBCInsert插入数据之后原始数据2JDBCDelete删除数据之后原始数据class JDBCUpdate更新数据之后思路感悟
原始数据1
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);//第三步:获取操作SQL语句的对象statement=connection.createStatement();//第四步:执行SQL语句String sql="insert into usermessage(uname,upassword) values(121,121121),(122,122122)";int i = statement.executeUpdate(sql);//i为更新的表中的数据的条数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();}}}}}
插入数据之后
原始数据2
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);//第三步:获取操作SQL语句的对象statement=connection.createStatement();//第四步:执行SQL语句String sql="delete from usermessage where uid=25";int i = statement.executeUpdate(sql);//i为更新的表中的数据的条数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();}}}}}
删除数据之后
原始数据
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);//第三步:获取操作SQL语句的对象statement=connection.createStatement();//第四步:执行SQL语句String sql="update usermessage set uname='123456789',upassword='123456789' where uid=24";int i = statement.executeUpdate(sql);//i为更新的表中的数据的条数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();}}}}}