数据库操作:查询数据

package SQl;

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

public class T2_select {

	public static void main(String[] args) {
		Connection conn =null;
		String address="jdbc:mysql://localhost:3306/data1?useSSL=false&serverTimezone=UTC"; 
		String dataBaseName="root"; 
		String dataBasePwd="123456";
		try {
			//加载jdbc驱动
			Class.forName("com.mysql.cj.jdbc.Driver");
			//链接数据库
			conn = DriverManager.getConnection(address,dataBaseName,dataBasePwd);
			System.out.println("链接成功");
			//编写sql
			String sql="select * from stu";
			//Statement对象用来执行sql
			Statement stmt=conn.createStatement();
			//执行sql并获取查询结果
			ResultSet rs=stmt.executeQuery(sql);
			
			while(rs.next()) {
				System.out.print("id:"+rs.getInt("id")+"---");
				System.out.print("name:"+rs.getString("name")+"---");
				System.out.print("age:"+rs.getInt("age")+"\n");
			}
		} catch (Exception e) {
			System.out.println("链接失败");
			e.printStackTrace();
		}finally {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}