学生成绩管理Java

JDBC驱动测试

package com.lws.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JDBC {

	public static void main(String[] args) {
		// 加载MySql 驱动
		try {
	Class.forName("com.mysql.cj.jdbc.Driver");
	System.out.println("加载驱动成功");
	Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306"
			+ "/data?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT", "root","1111");
	System.out.println("链接数据库成功");
	//创建执行环境
	 Statement statement = conn.createStatement();
	 //执行sql 语句，得到结果集
	 ResultSet result = statement.executeQuery("select *from info");
	 while(result.next()) {
		 
		 System.out.print(result.getInt("id")+" ");
		 System.out.print(result.getString("uname")+" ");
		 System.out.println(result.getString("upass"));
		 
	 }
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("加载失败");
		}//加载数据库驱动
}		
}