使用Jdbc操作数据库

使用Jdbc操作数据库

• 带入mysql的jar包，并将jar包配置到项目中
  
• 加载数据库驱动
  Class.forName(“com.mysql.jdbc.Driver”);
• 通过Drivermanager的getConnection方法获取数据库连接对象
  Connection conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/jdbc”,“root”,“123456”);
• 通过数据库连接对象获取statement对象
  Statement statement = conn.createStatement();
• 通过statement对象执行sql语句,并通过resultset保存返回结果
  ResultSet resultSet = statement.executeQuery(“select * from tb_user”);
• 通过resultset对象操作结果集
  while (resultSet.next()){
  System.out.println(resultSet.getInt(“id”)+" "+resultSet.getString(“name”));
  }

源码

import java.sql.*;

public class JDBC {
    public static void main(String[] args) throws ClassNotFoundException {
        Class.forName("com.mysql.jdbc.Driver");
        try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc","root","123456");
            Statement statement = conn.createStatement();
            String sql = "select * from tb_user";
            ResultSet resultSet = statement.executeQuery(sql);
            while (resultSet.next()){
                System.out.println(resultSet.getInt("id")+" "+resultSet.getString("name"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}