java面向对象添加数据库SQL

Bertha 。 2022-05-14 04:47 182阅读 0赞

面向对象操作 封装 重写to string方法 空参构造方法

package SQL.work1;
    //面向对象操作
    public class pojo {
        private String stusum;
        private String stuname;
        private String studate;
        private String stuaddres;
        public pojo() {
        }
        public String getStusum() {
            return stusum;
        }
        public void setStusum(String stusum) {
            this.stusum = stusum;
        }
        public String getStuname() {
            return stuname;
        }
        public void setStuname(String stuname) {
            this.stuname = stuname;
        }
        public String getStudate() {
            return studate;
        }
        public void setStudate(String studate) {
            this.studate = studate;
        }
        public String getStuaddres() {
            return stuaddres;
        }
        public void setStuaddres(String stuaddres) {
            this.stuaddres = stuaddres;
        }
        @Override
        public String toString() {
            return "pojo{" +
                    "stusum='" + stusum + '\'' +
                    ", stuname='" + stuname + '\'' +
                    ", studate='" + studate + '\'' +
                    ", stuaddres='" + stuaddres + '\'' +
                    '}';
        }
    }

写入SQL

package SQL.work1;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;
    
    public class Mxdx {
        public static void main(String []args) throws SQLException, ClassNotFoundException {
            Mxdx mx=new Mxdx();
            mx.zeng();
        }
        public void zeng() throws ClassNotFoundException, SQLException {
            pojo po = new pojo();
            po.setStusum("js1");
            po.setStuname("小红");
            po.setStudate("2008-8-2");
            po.setStuaddres("山西");
            Class.forName("com.mysql.jdbc.Driver");
            //String sql = "INSERT INTO student VALUES ('j05','陈七','2018-08-03','地狱');";
            String sql = "INSERT INTO student  VALUES (?,?,?,?);";
            Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mydata", "root", "root");
            // 执行增删改除
            PreparedStatement pre = con.prepareStatement(sql);
           /* pre.setObject(1,"j05");
            pre.setObject(2,"陈七");
            pre.setObject(3,"2018-8-03");
            pre.setObject(4,"地狱");*/
            pre.setObject(1,po.getStusum());
            pre.setObject(2,po.getStuname());
            pre.setObject(3,po.getStudate());
            pre.setObject(4,po.getStuaddres());
            //executeUpdate();  执行增删改语句  返回值为int类型   成功为1   失败为0；
            int i = pre.executeUpdate();
            if (i == 1) {
                System.out.println("添加成功！");
            } else {
                System.out.println("添加失败！");
            }
            pre.close();
            con.close();
        }
    }