Linux Java连接MySQL数据库.pdf

文档介绍：IT-Homer 专栏
成功是优点的发挥,失败是缺点的积累! 不为失败找理由,只为成功找
方法……
Linux Java连接MySQL数据库
分类: Java/JSP SQL Index 2011-10-10 16:39 624人阅读评论(0) 收藏举报
Linux(Ubuntu平台)Java通过JDBC连接MySQL数据库,与Windows平台类似,步骤如下:
下载 jdbc: mysql-connector-java-
解压 jdbc: tar -zxvf mysql-connector-java-
配置 jdbc:cp mysql-connector-java-- /usr/local//
Java示例:
private static String sql="select top, id, name, country, dtime from gametop800 where
id=\"\"";
public mysqlConnect(){
String dbDriver = "";
String url = "jdbc:mysql://localhost/top800";
String username = "root";
String password = "";
Statement mStatement = null;
ResultSet mResultSet = null;
Connection mConnection = null;
String sql = "select top, id, name, country, dtime from gametop800 where top<=20";
try{
(dbDriver).newInstance();
mConnection = (url, username, password);
mStatement = ();
mResultSet = (sql);
try{
while(()){
(