菜鸟练手,大神勿喷。
封装类
import java.sql.*
public class mysqlCon
{
private String URL = null; // 数据库地址
private String JDBCNAME = null; // 数据库类名
private String USER = null;// 数据库用户名
private String PASSWORD = null; // 数据库密码
public Connection getCon() throws Exception
{
JDBCNAME = "com.mysql.jdbc.Driver";
Class.forName(JDBCNAME);
URL = "jdbc:mysql://localhost:3306?charaterEncoding=utf8";
USER = "localhost";
// 数据库用户名
PASSWORD = "******";
// 数据库密码
Connection con = DriverManager.getConnection(URL,USER,PASSWORD);
System.out.println("Connection mysql successful!");
return con;
}
}
测试类
public class mysqlCon_test
{
public static void main(String[] args)
{
mysqlCon mysql = new mysqlCon();
mysql.getCon();
}
}