servilet 增删改查

  @Test
    public  void DBtestt() throws ClassNotFoundException, SQLException {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/zhaosheng";
        String username = "root";
        String password = "root";
        Class.forName(driver);
        Connection connection = DriverManager.getConnection(url, username, password);
        System.out.println("Connection" + connection);

//    插入数据
        PreparedStatement ps= connection.prepareStatement("insert into admin(username,password) values (?,?)");
        ps.setString(1,"admin");
        ps.setString(2,"123456");

        int row  = ps.executeUpdate();
        if (row>0){
            System.out.println("添加成功");
        }


//        查询数据（单个）
        PreparedStatement ps= connection.prepareStatement("select * from admin where id=?");
        ps.setInt(1,1);
        ResultSet rs  = ps.executeQuery();
        if (rs.next()){
            Admin admin = new Admin();
            int id = rs.getInt("id");
            String  name = rs.getString("username");
            String  pass = rs.getString("password");
            admin.setId(id);
            admin.setUsername(name);
            admin.setPassword(pass);
            System.out.println(admin.toString());
        }


        查询全部
        PreparedStatement ps= connection.prepareStatement("select * from admin ");

        ResultSet rs  = ps.executeQuery();
        List<Admin> admins = new ArrayList<>();

        while (rs.next()){
            Admin admin = new Admin();
            int id = rs.getInt("id");
            String  name = rs.getString("username");
            String  pass = rs.getString("password");
            admin.setId(id);
            admin.setUsername(name);
            admin.setPassword(pass);
            admins.add(admin);
            System.out.println(admin.toString());
        }


//        修改

        PreparedStatement ps= connection.prepareStatement("updat  admin  set username=?,password=? where id=?");
        ps.setString(1,"admn");
        ps.setString(2,"1234");
        ps.setInt(3,13);
        int row  = ps.executeUpdate();
        if (row>0){
            System.out.println("修改成功");
        }


//        删除
        PreparedStatement ps= connection.prepareStatement("delete from  admin  where id=?");
        ps.setInt(1,13);
        int row  = ps.executeUpdate();
        if (row>0){
            System.out.println("删除成功");
        }
        rs.close();
        ps.close();
        connection.close();
    }

    }