连接数据库模版

package com.mingxin.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import com.mysql.jdbc.ResultSet;import com.mysql.jdbc.Statement;public class ConnectionUtils {private static String driver = com

package com.mingxin.util;

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

import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;

public class ConnectionUtils {

	private static String driver = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://127.0.0.1:3306/db_mx";
	private static String user = "root";
	private static String password = "123456";
	private static Connection conn = null;
	
	static{
	try {
	Class.forName(driver);
	} catch (ClassNotFoundException e) {
	System.out.println("驱动加载失败..");
	e.printStackTrace();
	}
	}
	
	public static Connection getConnection(){
	try {
	conn = DriverManager.getConnection(url, user, password);
	if(!conn.isClosed()){
	System.out.println("Successed connecting to the Database...");
	}
	} catch (SQLException e) {
	System.out.println("数据库连接失败...");
	e.printStackTrace();
	}
	return conn;
	}
	
	public static void main(String[] args) {
//	getConnection();
	try {
	Statement statement = (Statement) conn.createStatement();
	String sql = "select * from user";
	ResultSet rs = (ResultSet) statement.executeQuery(sql);
	String email = null;
	String name = null;
	String phone = null;
	while(rs.next()){
	email = rs.getString("u_email");
	name = rs.getString("u_name");
	phone = rs.getString("u_phone");
	System.out.println("u_email=" + email + " ___u_name=" + name + " ____phone=" + phone);
	}
	} catch (SQLException e) {
	e.printStackTrace();
	}
	}
}