JDBC增删查改

一、增加

    package jdbc;
      
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.Statement;
      
    public class TestJDBC {
        public static void main(String[] args) {
      
            try {
                Class.forName("com.mysql.jdbc.Driver");
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
      
            try (
                Connection c = DriverManager.getConnection(");
                Statement s = c.createStatement();              
            )
            {
                String sql = "insert into 表名 values('数据1' , '数据2', '数据3');
                s.execute(sql);
                  
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }

二、删除

package jdbc;
  
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
  
public class TestJDBC {
    public static void main(String[] args) {
  
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
  
        try (
            Connection c = DriverManager.getConnection(");
            Statement s = c.createStatement();              
        )
        {
            String sql = "delete from 表名 where 更改后的数据 = 更改前的数据";
            s.execute(sql);
              
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

三、查

import java.sql.*;
import java.util.Scanner; 
/** *   设计一个方法，进行分页查询
     public static void list(int start, int count)
     start 表示开始页数，count表示一页显示的总数
     list(0,5) 表示第一页，一共显示5条数据 
     list(10,5) 表示第三页，一共显示5条数据     
     进行分页查询用到的SQL语句参考 ： 查询数据 
*/
     public class Exercise_02 {
          public static void main(String[] args) {
          //查询
          Scanner sc = new Scanner(System.in);       
          System.out.print("请输入需要查询第几页：");       
          int n = sc.nextInt();        
          System.out.print("每页显示的条数为：");       
          int count = sc.nextInt();        
          //开始的索引        
          int index = (n - 1) *  count;        
          System.out.println("第"+n+"页的结果为:");        
          list(index, count);     
          }      
          public static void driver(String sql) { 
          try {
                //注册驱动            
                Class.forName("com.mysql.jdbc.Driver");        
                } catch (ClassNotFoundException e) {
                e.printStackTrace();        
           }         
           try(               
           //建立连接数据库对象                
           Connection conn =  DriverManager.getConnection("");                 
           //建立执行sql语句的对象                
           Statement stmt = conn.createStatement();        
           ) {            
           //执行sql对象            
           ResultSet rs = stmt.executeQuery(sql);            
           //查询结果            
           while(rs.next()) {                
           int id = rs.getInt("id");                
           String name = rs.getString("name");                
           double balance = rs.getDouble("balance");                
           System.out.println("id:" + id + "\nname:" + name + "\nbalance:" + balance);                
           System.out.println();            
           }
           } catch (SQLException e) {
                 e.printStackTrace();        
          }      
    }      
          //进行分页查询    
          public static void list(int start, int count) {
                   String sql = "select * from account limit "+start+","+ count+"";        driver(sql);     
          } 
  }

四、改

package jdbc;
  
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
  
public class TestJDBC {
    public static void main(String[] args) {
  
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
  
        try (
            Connection c = DriverManager.getConnection(");
            Statement s = c.createStatement();              
        )
        {
            String sql = "delete from 表名 where id = 5";
            s.execute(sql);
              
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}