java怎么连接navicat

import

java.sql.*;public class MysqlTest { public static void main(String[] 

args) { //加载JDBC-MySQL驱动 try { Class.forName("com.mysql.jdbc.Driver"); }

catch (Exception e) {} 

//同数据库建立连接，其中ip地址后的3306是端口号，study是数据库名称，加上用户名和密码等信息 //设置useSSL为true 

//如果表中记录有汉字，请加上characterEncoding参数，取值为gb2312或utf-8 Connection con = 

null; String uri = 

"jdbc:mysql://192.168.199.240:3306/study?user=root&password=****&useSSL=true&characterEncoding=utf-8";

try { con = DriverManager.getConnection(uri); //连接代码 } catch 

(SQLException e) { System.out.println(e); } //向数据库发送SQL查询语句 try { 

Statement sql = con.createStatement(); //声明并创建SQL语句对象 ResultSet rs = 

sql.executeQuery("SELECT * FROM test"); //查询test表 

System.out.println("查询结果："); while (rs.next()) { //循环读取表test每行的数据并输出 

String number = rs.getString(1); String name = rs.getString(2); Date 

date = rs.getDate(3); float height = rs.getFloat(4); 

System.out.printf("%s   ",number); System.out.printf("%s    ",name); 

System.out.printf("%s   ",date); System.out.printf("%s  ",height); 

System.out.println(); } con.close(); //关闭数据库连接 } catch (SQLException e) {

 System.out.println(e); } }}