连接数据库模版

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();
}
}
}