增删改查——Statement接口

迷南。 2023-08-17 16:09 171阅读 0赞

1、增加数据表中的元组

package pers.datebase.zsgc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class JDBC {
        public static void main(String[] args) throws ClassNotFoundException,
                SQLException {
            // 加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 链接到数据库
            String url = "jdbc:mysql://localhost:3306/student mangement system";
            String username = "root";
            String password = "root";
            Connection con = DriverManager.getConnection(url, username, password);
    
            // 获取到SQL语句的执行者对象
            Statement stat = con.createStatement();
    
            // 增加
            stat.executeUpdate("insert into student(studentno,sname,sex,birthday,classno,point,phone,email)"
                    + "values('201712219','张涵','女','1989-12-18','080601','666','15878945612','han@163.com')");
    
            // 释放资源
            stat.close();
            con.close();
        }
    }

![1392562-20190819090356586-1957950305.png][]

2、删除元组

package pers.datebase.zsgc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class JDBC {
        public static void main(String[] args) throws ClassNotFoundException,
                SQLException {
            // 加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 链接到数据库
            String url = "jdbc:mysql://localhost:3306/student mangement system";
            String username = "root";
            String password = "root";
            Connection con = DriverManager.getConnection(url, username, password);
    
            // 获取到SQL语句的执行者对象
            Statement stat = con.createStatement();
    
            // 删除
            String sql = "delete from student where sname='张涵'"; // SQL语句
            stat.executeUpdate(sql); // 将sql语句上传至数据库执行
    
            // 释放资源
            stat.close();
            con.close();
        }
    }

3、修改元组

package pers.datebase.zsgc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class JDBC {
        public static void main(String[] args) throws ClassNotFoundException,
                SQLException {
            // 加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 链接到数据库
            String url = "jdbc:mysql://localhost:3306/student mangement system";
            String username = "root";
            String password = "root";
            Connection con = DriverManager.getConnection(url, username, password);
    
            // 获取到SQL语句的执行者对象
            Statement stat = con.createStatement();
    
            String sql="update student set classno='201718' where sname='平靖' ";   //SQL语句
            stat.executeUpdate(sql);         //将sql语句上传至数据库执行
    
            // 释放资源
            stat.close();
            con.close();
        }
    }

![1392562-20190819090830019-709951360.png][]

4、查询数据表

package pers.datebase.zsgc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class JDBC {
        public static void main(String[] args) throws ClassNotFoundException,
                SQLException {
            // 加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 链接到数据库
            String url = "jdbc:mysql://localhost:3306/student mangement system";
            String username = "root";
            String password = "root";
            Connection con = DriverManager.getConnection(url, username, password);
    
            // 获取到SQL语句的执行者对象
            Statement stat = con.createStatement();
    
            String sql="select * from score";           //sql语句
            ResultSet rs=stat.executeQuery(sql);          //ResultSet 是java中执行select后，返回的结果集类。 rs 就是结果集的变量。
            while(rs.next()){    //next（）获取里面的内容
                System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+""+rs.getString(4));
            }
    
            // 释放资源
            stat.close();
            con.close();
            rs.close();
        }
    }

![1392562-20190819091226398-598958132.png][]

转载于:https://www.cnblogs.com/zhai1997/p/11375243.html

[1392562-20190819090356586-1957950305.png]: /images/20230810/02e583d072e141068eddea2404df086b.png
[1392562-20190819090830019-709951360.png]: /images/20230810/208522f3081f4c899cb106ff0814fe41.png
[1392562-20190819091226398-598958132.png]: /images/20230810/5f11d6d1e0ad4058a758d238b18b18cd.png