java连接MySQL数据库

来源：互联网发布：vb6 连接mysql数据库编辑：程序博客网时间：2024/05/21 06:50

在新建的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 blocke.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 !");}}}

0 0