渚漪Day19——JDBC【待续】

JDBC学习

第一个JDBC

• 创建测试数据库

1. 创建一个普通项目
2. 导入数据库驱动

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>JDBC</artifactId>
    <version>1.0-SNAPSHOT</version>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

    </dependencies>

</project>

import java.awt.*;
import java.sql.*;
public class fristJDBC {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {


        //1、加载驱动
        Class.forName("com.mysql.jdbc.Driver");

        String url = "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf8&&useSSL=true";
        String username = "root";
        String password = "123456";
        Connection connection = DriverManager.getConnection(url,username,password);

        Statement statement = connection.createStatement();

        String sql = "select * from category";

        ResultSet resultSet = statement.executeQuery(sql);

        while (resultSet.next()){
            System.out.println("categoryid"+resultSet.getObject("categoryid"));
            System.out.println("pid"+resultSet.getObject("pid"));
            System.out.println("categoryname"+resultSet.getObject("categoryname"));
        }

        resultSet.close();
        statement.close();
        connection.close();

    }
}