CREATE DATABASE shayiheng;
USE shayiheng;
CREATE TABLE t_user(
id INT PRIMARY key AUTO_INCREMENT COMMENT '用户主键',
account VARCHAR(20) NOT NULL UNIQUE COMMENT '账号',
PASSWORD VARCHAR(64) NOT NULL COMMENT '密码',
nickname VARCHAR(20) NOT NULL COMMENT '昵称'
)
INSERT INTO t_user(account, PASSWORD,nickname)VALUES
('root','123456','经理'),('admin','666666','管理员');
SELECT *FROM t_user;
package com.shayiheng.api.statement;
import com.mysql.cj.jdbc.Driver;
import javax.swing.*;
import javax.swing.plaf.nimbus.State;
import java.sql.*;
public class StatementQueryPart {
public static void main(String[] args) throws SQLException {
DriverManager.registerDriver(new Driver());
Connection connection=DriverManager.
getConnection("jdbc:mysql://127.0.0.1:3306/shayiheng","root","12345678");
Statement statement = connection.createStatement();
String sql="SELECT * FROM t_user;";
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
int id = resultSet.getInt("id");
String account = resultSet.getString("account");
String password = resultSet.getString("password");
String nickname = resultSet.getString("nickname");
System.out.println(id+"--"+account+"--"+password+"--"+nickname);
}
resultSet.close();
statement.close();
connection.close();
}
}