环境
JDK 1.8 Eclipse Mysql
数据库连接类
package com.star.db;
import java.sql.Connection;
import java.sql.DriverManager;
public class MyConn {
public static Connection getConn() {
Connection c = null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
c = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","abc123");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return c;
}
}
链接串
jdbc:mysql://localhost:3306/test","root","abc123"
jdbc:mysql://localhost:数据库所占用端口/数据库名","用户名","密码"
测试链接
public static void main(String[] args) {
MyConn mc = new MyConn();
System.out.println(mc.getConn());
}
运行结果