最简单的JDBC连接MySql数据库 ---5步法..

package wsc.com.it.jdbc;


import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class MysqlTest {
private static String user = "root";
private static String password = "admin";
private static String url = "jdbc:mysql://127.0.0.1:3306/gaoxingwei";
private static String driver = "org.gjt.mm.mysql.Driver";
private static String sql = "SELECT * FROM gaoxingwei.gxw_user g";


public static void main(String[] args) throws SQLException, ClassNotFoundException, UnsupportedEncodingException {
//加载驱动
Class.forName(driver);
//连接数据库
Connection con = DriverManager.getConnection(url, user, password);
//解析SQL
PreparedStatement pst = con.prepareStatement(sql);
//执行SQL
pst.execute(sql);
//取得返回数据并处理.
ResultSet rs = pst.getResultSet();
System.out.println("-----------------");  
System.out.println("执行结果如下所示:");  
System.out.println("-----------------");  
System.out.println(" 用户名" + "\t" + "密码");  
System.out.println("-----------------");  
String name = null; 
String password = null; 
while (rs.next()) {
name = rs.getString("userName");
// name = new String(name.getBytes("ISO-8859-1"),"GB2312");
name = new String(name.getBytes("UTF-8"),"UTF-8");
password = rs.getString("password");
password = new String(password.getBytes("UTF-8"),"UTF-8");
System.out.println(name + "     " + password); 
}


}
}