使用preparedStatement进行删除，然后执行查询语句判断删除是否成功

艾克建站SEO

于 2024-05-29 09:26:50 发布

阅读量597

点赞数 20

文章标签： python java 开发语言

本文链接：https://blog.csdn.net/ikeseo/article/details/139283845

版权

使用preparedStatement进行删除，然后执行查询语句判断删除是否成功。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JdbcConn {
    public static void main(String[] args) throws SQLException {
        Connection conn = getConnect();
        Statement statement = conn.createStatement();
        PreparedStatement preparedStatement=conn.prepareStatement("delete from test where id =2");
        preparedStatement.execute();
        preparedStatement=conn.prepareStatement("select * from test;");
        ResultSet resultSet=preparedStatement.executeQuery();
        while (resultSet.next()){
            System.out.println(resultSet.getObject("id")+"  "+
                    resultSet.getObject("name"));
        }
        conn.close();
    }
    public static Connection getConnect() {
        String driver = "org.opengauss.Driver";
        String sourceURL = "jdbc:opengauss://10.244.50.251:33700/test_l?user=ltest&password=tiange1999?";
        Properties info = new Properties();
        Connection conn = null;
        try {
            Class.forName(driver);
        } catch (Exception var9) {
            var9.printStackTrace();
            return null;
        }
        try {
            conn = DriverManager.getConnection(sourceURL);
            System.out.println("连接成功！");
            return conn;
        } catch (Exception var8) {
            var8.printStackTrace();
            return null;
        }
    }
}