在新建的java工程中新建一个class,命名为:DBOperator
package cn.edu.web.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBOperator {
//定义MySQL的数据库驱动程序
public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
//定义mysql的数据库连接地址:
public static final String DBURL = "jdbc:mysql://localhost:3306/tennis_game";
//mysql数据库的连接用户名
public static final String DBUSER = "root";
//mysql数据库的连接密码
public static final String DBPASSWORD = "fang950609";
//static{}(即static块),会在类被加载的时候执行且仅会被执行一次,一般用来初始化静态变量和调用静态方法
static {
try {
Class.forName(DBDRIVER);//加载驱动程序
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection con = null;
try {
con = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);//连接数据库
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public static void close(ResultSet rs, Statement st, Connection con) {
try {
if(st != null)
st.close();
if(rs != null)
rs.close();
if(con != null)
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(Statement st, Connection con) {
close(null,st,con);
}
}
测试连接是否成功
package cn.edu.web.test;
import java.sql.Connection;
import cn.edu.web.utils.DBOperator;
public class TestDBOperator {
public static void main(String[] args) {
Connection con = DBOperator.getConnection();
if(con != null) {
System.out.println("Connetion success !");
}
}
}