Jdbc连接数据库做删除操作

- 日理万妓 2023-07-08 11:27 12阅读 0赞

## Jdbc连接数据库做删除操作 ##

package jdbc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    /**
     * @outhor liu
     * @dare 2020/2/26 14:36
     * Jdbc连接数据库做删除操作
     */
    public class JdbcDelete {
        
        public static void main(String[] args) {
        
    
            Connection conn=null;
            Statement stmt=null;
    
            //加载jar包
    
    
            try {
        
                //注册驱动
                Class.forName("com.mysql.cj.jdbc.Driver");
                //注册连接
                 conn = DriverManager.getConnection
                        ("jdbc:mysql:///test?serverTimezone=GMT%2B8", "root", "123456");
    
                //定义sql语句
                String sql="delete from users.user where uid=4";
    
                //获取执行sql对象
                 stmt = conn.createStatement();
                //执行sql
                int conut = stmt.executeUpdate(sql);
    
                if(conut>0){
        
                    System.out.println("删除成功");
                }else {
        
                    System.out.println("删除失败");
                }
            } catch (ClassNotFoundException e) {
        
                e.printStackTrace();
            } catch (SQLException e) {
        
                e.printStackTrace();
            }finally {
        
                if(conn != null){
        
                    try {
        
                        conn.close();
                    } catch (SQLException e) {
        
                        e.printStackTrace();
                    }
                }if (stmt != null){
        
                    try {
        
                        stmt.close();
                    } catch (SQLException e) {
        
                        e.printStackTrace();
                    }
    
                }        }
        }
    }

问题：sql语句报错，delete users.user where id=4 ,正确的应该是 delete from users.user where uid=4