JDBC入门

1、需要导入mysql-connector-java-5.1.7-bin

import org.junit.jupiter.api.Test;

import java.sql.*;

public class JdbcDemo1 {
    @Test
    public void demo1() throws SQLException {
        //加载驱动,静态代码块，使用Class.forName
        //DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        Class.forName("com.mysql.jdbc.Driver");
        //获得连接
        //url----"jdbc:mysql://localhost:3306/Database_name"即
        // jdbc协议+mysql子协议+主机名+端口号+Database_name
        //本机可直接简写为jdbc协议+mysql子协议+ :///  +Database_name
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc","root","zfy2635518");
        //创建执行sql对象
        String sql = "select * from user where id=1";
        Statement statement = connection.createStatement();
        //执行sql
        ResultSet resultSet= statement.executeQuery(sql);
        while(resultSet.next()){
            int uid = resultSet.getInt("id");
            String username = resultSet.getString("username");
            String password = resultSet.getString("password");
            String name = resultSet.getString("name");
            System.out.println(uid+ " "+username+ " " + password + " "+name);
        }
        //释放资源
        resultSet.close();
        statement.close();
        connection.close();
    }
}