用Java实现增删改查-蒲公英云

1.先写一个student类：

public class student {
    private String name;
    private String sex;
    private String brithday;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public student() {
    }
    public student(String name, String sex, String brithday) {
        this.name = name;
        this.sex = sex;
        this.brithday = brithday;
    }
    public String getBrithday() {
        return brithday;
    }
    public void setBrithday(String brithday) {
        this.brithday = brithday;
    }
    @Override
    public String toString() {
        return "student{" +
                "name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", brithday='" + brithday + '\'' +
                '}';
    }
}

2.写一个可以获取文件上的资源并注册驱动的类（文件自己按照自己的数据库填）

public class Deu_tils {
    private static String diverClass;   //注册驱动的jar包地址值
    private static String url;  //数据库的表格地址值
    private static String user; //Mysql的用户名
    private static String password; //Mysql的用户密码
    static {
        ResourceBundle rb=ResourceBundle.getBundle("dbinfo");   //获取文件的资源
        diverClass=rb.getString("driverClass");
        url=rb.getString("url");
        user=rb.getString("user");
        password=rb.getString("password");
        try {
            Class.forName(diverClass);  //注册驱动
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    /**
     * 得到资源的方法
     * @return 资源
     * @throws SQLException
     */
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url,user,password);
    }
}

3.实现增删改查

public class DoLogin {
    private String sql;
    private PreparedStatement pstmt;
    private Connection conn;
    /**
     * 增加数据库里面一条学生对象信息的方法
     *
     * @param s
     * @return
     */
    public void Insert(student s) throws SQLException {
        Connection conn = Deu_tils.getConnection();
        int i = 0;
        sql = "INSERT INTO `text2`.`student`(`name`, `sex`, `brithday`) VALUES (?,?,?)";
            pstmt =conn.prepareStatement(sql);
            pstmt.setString(1, s.getName());
            pstmt.setString(2, s.getSex());
            pstmt.setString(3, s.getBrithday());
            i = pstmt.executeUpdate();
            pstmt.close();
            conn.close();
    }
    /**
     *
     * 根据数据库id改名字性别和生日的方法
     * @param s
     * @return
     * @throws SQLException
     */
    public void Update(int id,student s) throws SQLException {
        Connection conn = Deu_tils.getConnection();
        int i = 0;
        sql ="UPDATE `text2`.`student` SET `name` = '"+s.getName()+"', `sex` = '"+s.getSex()+"', `brithday` = '"+s.getBrithday()+"' WHERE `id` = "+id;
            pstmt =conn.prepareStatement(sql);
            i = pstmt.executeUpdate();
            pstmt.close();
            conn.close();
    }
    /**
     * 根据对象名删除数据库对象信息的方法
     * @param name
     * @return
     * @throws SQLException
     */
    public void Delete(String name) throws SQLException {
        Connection conn = Deu_tils.getConnection();
        int i = 0;
        sql ="DELETE FROM `text2`.`student` WHERE `name` = '"+name+"'";
            pstmt =conn.prepareStatement(sql);
            i = pstmt.executeUpdate();
            pstmt.close();
            conn.close();
    }
    /**
     *  查询表格的方法
     * @throws SQLException
     */
    public void Select() throws SQLException {
        Connection conn = Deu_tils.getConnection();
        sql = "SELECT * FROM student;";
        pstmt = conn.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        student s = new student();
        while (rs.next()) {
            System.out.println(rs.getObject("id"));
            System.out.println(rs.getObject("name"));
            System.out.println(rs.getObject("sex"));
            System.out.println(rs.getObject("brithday"));
            System.out.println("---------------------------");
        }
        conn.close();
        pstmt.close();
        rs.close();
    }
}

4.测试类：

public class Text {
    public static void main(String[] args) throws SQLException {
        Scanner sc=new Scanner(System.in);
        System.out.println("请输入录入对象的名字：");
        String names=sc.next();
        System.out.println("请输入录入对象的性别：");
        String sexs=sc.next();
        System.out.println("请输入录入对象的生日：");
        String bris=sc.next();
        student s1=new student(names,sexs,bris);
        DoLogin dl1=new DoLogin();
        dl1.Insert(s1);
        dl1.Select();
        System.out.println("请输入要改对象的id：");
        int id=sc.nextInt();
        System.out.println("请输入要改的数据值名字：");
        String name=sc.next();
        System.out.println("请输入要改的数据值性别：");
        String sex=sc.next();
        System.out.println("请输入要改的数据值生日：");
        String bri=sc.next();
        student s2=new student(name,sex,bri);
        DoLogin dl2=new DoLogin();
        dl2.Update(id,s2);
        dl2.Select();
        System.out.println("请输入您要删除的对象姓名：");
        String namess=sc.next();
        DoLogin dl3=new DoLogin();
        dl3.Delete(namess);
        dl3.Select();
    }
}