第一个JDBC程序

创建一个普通项目
1.先在sqlyog创建一个表：jdbcstudy

CREATE DATABASE jdbcStudy CHARACTER SET utf8 COLLATE utf8_general_ci;
USE jdbcStudy;
CREATE TABLE users(
   id INT PRIMARY KEY,
   NAME VARCHAR(40),
   PASSWORD VARCHAR(40),
   email VARCHAR(60),
   birthday DATE
);
INSERT INTO users(id,NAME,PASSWORD,email,birthday)
VALUES(1,'zhangsan','991123','zs@sina.com','1980-12-04'),
(2,'lisi','991123','lisi@sina.com','1981-03-04'),
(3,'wangwu','991123','wangwu@sina.com','1983-11-23');

创建完了之后：打开idea，新建一个lib目录用来存放我们在官网下载的jdbc.jar包，jar包下载地址，将jar包复制到lib目录下，然后导入，这样既可，然后就可以用idea操作了，

package lesson01;
import java.sql.*;
public class jdbcFirstDemo {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //1.驱动加载
        Class.forName("com.mysql.jdbc.Driver"); //固定写法，加载驱动
        //2.用户信息和url
        //useUnicode=true&characterEncoding=utf8&useSSL=true"
        String url = "jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&useSSL=true";
        String username = "root";
        String password = "991123";
        //3.连接成功，数据库对象  Connection代表数据库
        Connection connection = DriverManager.getConnection(url, username, password);
        //4.执行sql的对象Statement
        Statement statement = connection.createStatement();
        //5.执行sql的对象去执行sql，可能存在结果，查看返回结果
        String sql = "SELECT * FROM users";
        ResultSet resultSet = statement.executeQuery(sql);  //返回的结果集
        while (resultSet.next()){
            System.out.println("id="+resultSet.getObject("id"));
            System.out.println("name="+resultSet.getObject("NAME"));
            System.out.println("pwd="+resultSet.getObject("PASSWORD"));
            System.out.println("email="+resultSet.getObject("email"));
            System.out.println("birth="+resultSet.getObject("birthday"));
            System.out.println("=================================================");
        }
        //6.释放连接
        resultSet.close();
        statement.close();
        connection.close();
    }
}

运行：
步骤总结：

• 加载驱动
• 连接数据库DriverManager
• 获得执行sql的对象 Statement
• 获得返回的结果集
• 释放连接