mysqlconnection.java

留言本系统

package tree;

import java.sql.Connection;
import java.sql.DriverManager;

public class MySQLConnection {
	
    private static MySQLConnection instance;

    private MySQLConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    public static MySQLConnection getInstance() {
        if(instance==null){
            instance=new MySQLConnection();
		}
        return instance;
    }

    public Connection getConnection() throws java.sql.SQLException {
		String dbServer = "localhost";
		String dbName = "notebook";
		String dbUser = "root";
		String dbPass = "walktree";
		
		String connStr = "jdbc:mysql://"+dbServer+"/"+dbName+"?user="+dbUser+"&password="+dbPass+"&useUnicode=true&characterEncoding=utf8";
        return DriverManager.getConnection(connStr);
    }
}