数据库单表查询：

数据表：

表名：NameandPassword

           列1：id//账号

           列2：name//昵称

           列3：password//密码

创建数据表：

create table NameandPassword(

       id varchar(15) primary key,

       name varchar(20),

       password varchar(15)

);

插入数据：

insert into NameandPassword

(id ,name ,password)

values

("admin","管理员","admin"),

("16000001","学生1","111111"),

("16000002","学生2","111111"),

("16000003","学生3","111111"),

("16000004","学生4","111111"),

("16000005","学生5","111111"),

 

查询代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectSQL {
	static PreparedStatement sql; // 声明PreparedStatement对象
	Connection con;
	public static void main(String[] args) {
		new ConnectSQL();
	}
	
	public ConnectSQL(){	
		Test();
	}
	
	public void Test() {
		try {
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/data?useSSL=false&serverTimezone=GMT",
			"root", "123456");
			//jdbc:mysql://localhost:3306/data 数据库端口及数据库名称
			//root    用户名
			//123456      密码
			System.out.println("mysql加载成功！");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		Statement stmt;
		try {
			stmt = con.createStatement();
			//select语句
			ResultSet rs = stmt.executeQuery("select * from NameandPassword");
			while (rs.next()) {
				//用get方法读取数据库的信息，引号内为数据库内列名
				//获取ID
				String ID=rs.getString("Id");
				//获取昵称
				String Name=rs.getString("name");
				//获取密码
				String Password=rs.getString("password");
				System.out.println("账号："+ID+" 密码："+Password+" 昵称："+Name);
				
			}
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

查询结果：