JSP Java 连接MySQL数据库 (JDBC)

 

public class DataBase_Test {
	public static final String URL = "jdbc:mysql://localhost/user_db?serverTimezone=UTC&useSSL=false&user=root&password=123456";
        /*连接数据库的代码,相比以前有更新
		user_db:数据库名称
		user:用户名
		password:密码
	*/
	public static void main(String[] args) {
		Connection con;
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");	//加载驱动
			System.out.println("驱动加载成功");
			con = DriverManager.getConnection(URL);		//数据库连接
			System.out.println("成功连接MySQL数据库");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from user_tb");	//SQL语句
			while (rs.next()) {
	                System.out.println(rs.getString("user_name") + "\n" + rs.getString("pass_word"));
	         }
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}