JDBC PrepareStatement insert delete update DML

最新推荐文章于 2024-01-12 18:56:55 发布

#眼镜&

最新推荐文章于 2024-01-12 18:56:55 发布

阅读量327

点赞数 1

CC 4.0 BY-SA版权

分类专栏： JDBC 文章标签： java mysql 数据库

本文链接：https://blog.csdn.net/qq_45858803/article/details/122630992

JDBC 专栏收录该内容

14 篇文章

订阅专栏

本文展示了如何使用Java的PreparedStatement接口执行数据库操作，包括插入数据、更新记录和删除数据。通过预编译SQL语句，提高了代码的安全性和效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章目录

class PrepareStatementInsert

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class PrepareStatementInsert {
    public static void main(String[] args) {
        Connection connection =null;
        PreparedStatement preparedStatement=null;
        try {
            //第一步:注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //第二步：创建连接
            connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mobilemallsystem","root","123456");
            //第三步：获取SQL语句预编译对象
            String sql="insert into usermessage(uname,upassword) values(?,?)";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,"jack");
            preparedStatement.setString(2,"123456");
            //第四步：执行SQL语句
            int i = preparedStatement.executeUpdate();
            if(i==1){
                System.out.println("数据插入成功");
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

PrepareStatementUpdate

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class PrepareStatementUpdate {
    public static void main(String[] args) {
        Connection connection =null;
        PreparedStatement preparedStatement=null;
        try {
            //第一步:注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //第二步：创建连接
            connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mobilemallsystem","root","123456");
            //第三步：获取SQL语句预编译对象
            String sql="update usermessage set uname=?,upassword=? where uid=?";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,"jieke");
            preparedStatement.setString(2,"123456");
            preparedStatement.setInt(3,31);
            //第四步：执行SQL语句
            int i = preparedStatement.executeUpdate();
            if(i==1){
                System.out.println("数据插入成功");
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

PrepareStatementDelete

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class PrepareStatementDelete {
    public static void main(String[] args) {
        Connection connection =null;
        PreparedStatement preparedStatement=null;
        try {
            //第一步:注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //第二步：创建连接
            connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mobilemallsystem","root","123456");
            //第三步：获取SQL语句预编译对象
            String sql="delete from usermessage where uid=?";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1,31);
            //第四步：执行SQL语句
            int i = preparedStatement.executeUpdate();
            if(i==1){
                System.out.println("数据插入成功");
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}