小型Java Web项目之DatabaseConnection

来源：互联网发布：网络彩票什么时候开售编辑：程序博客网时间：2024/05/29 17:15

做JavaWeb项目必然离不开数据库，这里使用的是MySQL数据库进行开发。具体链接类如下：

package dbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import javax.naming.Context;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.*;public class DatabaseConnection {    private static final String driver = "com.mysql.jdbc.Driver";    private static final String url = "jdbc:mysql://localhost:3306/myproject?characterEncoding=utf8&useSSL=true";    private static final String user = "**";    //这里写上用户名    private static final String password = "**";    //这里写上密码    private Connection conn = null;    public DatabaseConnection() throws SQLException{        try {            Class.forName(driver);            this.conn = DriverManager.getConnection(url, user, password);           } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }    public Connection getConn() {        return this.conn;    }    public void close(){        if(this.conn != null){            try {                this.conn.close();            } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }        }    }}

数据库的连接还是比较容易的，但也应该很熟练。

0 0