java-jdbc

package com.anlysqx.testJDBC;

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



public class JdbcDemo1 {
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Class.forName("com.mysql.cj.jdbc.Driver");
		Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/testjdbc?useSSL=true&serverTimezone=GMT%2B8", "root", "xxxxxx");
		System.out.println(conn);
		String sql = "select * from user";
		Statement st = conn.createStatement();
		ResultSet re = st.executeQuery(sql);
		int count = re.getMetaData().getColumnCount();
		while(re.next()){
			int id = re.getInt(1);
			String uname = re.getString(2);
			Time time = re.getTime(3);
			System.out.println(id+" "+uname+" "+time.toString());
		}
	}
}