mysql4.1.10的JDBC驅(qū)動(dòng)的配置及測(cè)試
一.下載
mysql4.1.10的下載:
http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.10-win32.zip/from/pickmysql4.1.10jdbc驅(qū)動(dòng)的下載:
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.7.zip/from/pickmysql-front的下載:
MySQL-Front is an easy to use, compact, and very fast graphical tool to manage your MySQL database - from anywhere in the world. http://www.mysqlfront.de/download.html二.配置
1. 把下載的jdbc驅(qū)動(dòng)mysql-connector-java-3.1.7.zip解壓縮,提取其中的mysql-connector-java-3.1.7-bin.jar文件到適當(dāng)位置,并設(shè)置classpath路徑指向該文件.
2.安裝mysql數(shù)據(jù)庫(kù).
3.安裝mysql-front,利用mysql-front建立數(shù)據(jù)庫(kù)jtest,并在jtest中建立表info.然后填入數(shù)據(jù).
三.測(cè)試
測(cè)試代碼如下:
文件名:testMysql.java
/**
* @author rockaka
* mysql的jdbc驅(qū)動(dòng)測(cè)試代碼
* mysql4.1.10+mysql-connector-java-3.1.7-bin.jar
* data:2005-02-23
*/
import java.sql.*;
public class testMysql {
public static void main(String[] args) {
//驅(qū)動(dòng)程序名
String driverName="com.mysql.jdbc.Driver";
//數(shù)據(jù)庫(kù)用戶名
String userName="root";
//密碼
String userPasswd="root";
//數(shù)據(jù)庫(kù)名
String dbName="jtest";
//表名
String tableName="info";
//聯(lián)結(jié)字符串
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
System.out.println(url);
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM "+tableName;
ResultSet rs = statement.executeQuery(sql);
// 獲得數(shù)據(jù)結(jié)果集合
ResultSetMetaData rmeta = rs.getMetaData();
// 確定數(shù)據(jù)集的列數(shù)，亦字段數(shù)
int numColumns=rmeta.getColumnCount();
// 輸出每一個(gè)數(shù)據(jù)值
for(int i=1;i<=numColumns;i++) {
if(i<numColumns)
System.out.print(rmeta.getColumnName(i)+" | ");
else
System.out.println(rmeta.getColumnName(i));
}
while(rs.next()){
for(int i=1;i<=numColumns;i++) {
if(i<numColumns)
System.out.print(rs.getString(i).trim()+" | ");
else
System.out.println(rs.getString(i).trim());
}
}
rs.close();
connection.close();
}catch(Exception ex){
System.out.println(ex);
System.exit(0);
}
}
}
四:編譯與運(yùn)行
1.編譯:javac testMysql.java
2.運(yùn)行:java testMysql
3.我的運(yùn)行結(jié)果:
jdbc:mysql://localhost/jtest?user=root&password=root
NO | NAME | AGE
1 | AAA | 20
2 | BBB | 30
3 | CCC | 40