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