用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();
    }
}

id	name	sex	brithday
1	张三	男	1999-02-13
2	李四	男	1999-08-16

 

最后：能力有限，如有不对之处，还请指教。