?

?文章來源地址http://www.zghlxwxcb.cn/news/detail-766866.html

package step2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class AddData {
    public  void run() throws SQLException, ClassNotFoundException {
        // ---------------------Begin------------------------
        //獲取數據庫連接
        Connection connection = this.getConnection();
        //獲取statement對象
        Statement statement = connection.createStatement();
        //向staff員工表中插入id為5，名字為:李敏，性別為：女，年齡為：21的數據
        String sql = "INSERT INTO `company`.`staff` (`id`, `name`, `sex`, `age`) VALUES ('5', '李敏', '女', '21')";
        statement.executeUpdate(sql);
        //關閉數據庫連接，釋放資源
        statement.close();
        connection.close();
// ---------------------End------------------------
    }
    public   Connection getConnection() throws ClassNotFoundException, SQLException {
        // ---------------------Begin------------------------
        //獲取數據庫連接，賬戶名：root,密碼：123123, 數據庫名：company,MySQL版本為8.0.20
        Class.forName("com.mysql.cj.jdbc.Driver");
        String username = "root";
        String password = "123123";
        String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
        return DriverManager.getConnection(url, username, password);
// ---------------------End------------------------
    }
}

package step3;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DelData {
    public  void run() throws SQLException, ClassNotFoundException {
        // ---------------------Begin------------------------
        //獲取數據庫連接
        Connection connection = this.getConnection();
        //獲取statement對象
        Statement statement = connection.createStatement();
        //刪除staff員工表中id為4的記錄
         String sql = "delete from staff where id = 4";
         statement.executeUpdate(sql);
        //關閉數據庫連接，釋放資源
        statement.close();
        connection.close();
 
    // ---------------------End------------------------
    }
    public   Connection getConnection() throws ClassNotFoundException, SQLException {
        // ---------------------Begin------------------------
        //獲取數據庫連接，賬戶名：root,密碼：123123, 數據庫名：company,MySQL版本為8.0.20
        Class.forName("com.mysql.cj.jdbc.Driver");
        String username = "root";
        String password = "123123";
        String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
        return DriverManager.getConnection(url, username, password);
// ---------------------End------------------------
    }
}

package step4;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class EditData {
    public  void run() throws SQLException, ClassNotFoundException {
        // ---------------------Begin------------------------
        //獲取數據庫連接
        Connection connection = this.getConnection();
        //獲取statement對象
        Statement statement = connection.createStatement();
        //修改staff表中id=3的性別為男
        String sql =  "update staff set sex = '男' where id = 3";
        statement.executeUpdate(sql);
        //關閉數據庫連接，釋放資源
        statement.close();
        connection.close();
// ---------------------End------------------------
    }
    public   Connection getConnection() throws ClassNotFoundException, SQLException {
        // ---------------------Begin------------------------
        //獲取數據庫連接，賬戶名：root,密碼：123123, 數據庫名：company,MySQL版本為8.0.20
        Class.forName("com.mysql.cj.jdbc.Driver");
        String username = "root";
        String password = "123123";
        String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
        return DriverManager.getConnection(url, username, password);
// ---------------------End------------------------
    }
}

package step5;
import java.sql.*;
public class QuerryData {
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        QuerryData querryData = new QuerryData();
        // ---------------------Begin------------------------
      //獲取數據庫連接
        try{
      Connection conn = querryData.getConnection();
        //獲取statement對象    
      Statement sta = conn.createStatement();
        //遍歷輸出staff表中的數據
String sql = "SELECT id, name, sex, age from staff";
//"SELECT id, first, last, age FROM student";
 ResultSet rs = sta.executeQuery(sql);
 while(rs.next()){
                // 通過字段檢索
                int id  = rs.getInt("id");
                String name = rs.getString("name");
                String sex = rs.getString("sex");
              String age = rs.getString("age");
                // 輸出數據
                System.out.print(id+",");
                System.out.print(name+",");
                System.out.print(sex+",");
                System.out.println(age);       
            }
        //關閉數據庫連接，釋放資源
  rs.close();
    sta.close();
        conn.close();
        }catch(Exception e){
          e.printStackTrace();
        }

// ---------------------End------------------------
    }
  public   Connection getConnection() throws ClassNotFoundException, SQLException {
      // ---------------------Begin------------------------
      //獲取數據庫連接，賬戶名：root,密碼：123123, 數據庫名：company,MySQL版本為8.0.20
       Class.forName("com.mysql.cj.jdbc.Driver");
      String username = "root";
      String password = "123123";
      String url = "jdbc:mysql://localhost:3306/company?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
    return DriverManager.getConnection(url, username, password);

// ---------------------End------------------------
  }
}

到了這里，關于JDBC增刪改查 頭歌實踐教學Java的文章就介紹完了。如果您還想了解更多內容，請在右上角搜索TOY模板網以前的文章或繼續(xù)瀏覽下面的相關文章，希望大家以后多多支持TOY模板網！