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