public class JDBCTest3 {
    @Test
    public void JDBCTest36() {
        Connection con=null;
        Statement stm=null;
        ResultSet rs=null;
        try {
            //加载驱动com.mysql.cj.jdbc.Driver
            Class.forName("com.mysql.cj.jdbc.Driver");
            con=DriverManager.getConnection("jdbc:mysql:///JDBC?useSSL=false&serverTimezone=Hongkong&useUnicode=true&CharacterEncoding=utf-8", "root", "123456");
            stm=con.createStatement();
            String sql="DELETE FROM  goods WHERE name='耳机';";
            //执行sql语句
            int i=stm.executeUpdate(sql);
            if(i>0) {
                System.out.println(i+" line effected");
                String sql_desplay="SELECT * FROM goods";
                rs=stm.executeQuery(sql_desplay);
                while(rs.next()) {
                    int id=rs.getInt("id");
                    String price= rs.getString("price");
                    String desp=rs.getString("desp");
                    System.out.println(id+"    "+price+"    "+desp);
                }
            }else {
                System.out.println("删除失败！");
            }
        }catch(Exception e) {
            e.printStackTrace();
        }finally {
            if(con!=null) {
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            con=null;

            if(stm!=null) {
                try {
                    stm.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            stm=null;

            if(rs!=null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            rs=null;
        }
    }
 }