dbutils.java

来自「Ajax 简单应用」· Java 代码 · 共 35 行

package DB;

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

public class DBUtils {
	private static final String driverClassName = "org.gjt.mm.mysql.Driver";
	private static final String url = "jdbc:mysql://localhost/test";
	private static final String user = "root";
	private static final String password = "root";

	public static Connection getConnection() {
		Connection conn = null;
		try {
			Class.forName(driverClassName);
			conn = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}

	public static void closeAll(Connection con) {
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}
}