JDBC连接MYSQL类

来源：互联网发布：中文域名不允许个人编辑：程序博客网时间：2024/06/07 01:52

该类负责数据库的连接和关闭操作。

/* * 负责数据库的连接和关闭操作 */package javaBean;import java.sql.*;public class DatabaseConnection {private static final String DEDRIVER = "com.mysql.jdbc.Driver";private static final String DBURL = "jdbc:mysql://localhost:3306/mldn";private static final String DBUSER = "root";private static final String DBPASSWORD = "password";private Connection conn = null;public DatabaseConnection() throws Exception {//在构造方法中进行数据库的连接try {Class.forName(DBDRIVER);//加载驱动this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//连接数据库}catch(Exception e) {e.printStackTrace();}}public Connection getConnection() {//取得数据库连接return this.conn;}public void close() throws Exception {//数据库关闭if(this.conn != null) {try {this.conn.close();}catch(Exception e) {e.printStackTrace();}}}}

0 0