MySQL Connect-J

ttl_web

1.Download mysql-connector-java-3.1.8-bin.jar
From
www.mysql.com
-> Download
2.System Var
CLASSPATH = X:mysql-connector-java-3.1.8-bin.jar
3.Test
3.1 Create Database : TestDB ; Create Table : TestTable
D:Test.sql
# 创建数据库 TestDB
CREATE DATABASE TestDB;
# 选择数据库
USE TestDB;
# 创建表
CREATE TABLE TestTABLE (
    column1 INT(6) NOT NULL,
    column2 CHAR(20),
    column3 CHAR(20),
    column4 CHAR(20)
);
# 添加数据
INSERT INTO TestTABLE VALUES(100001,"A","B","C");
INSERT INTO TestTABLE VALUES(100002,"A","B","C");
INSERT INTO TestTABLE VALUES(100003,"A","B","C");
INSERT INTO TestTABLE VALUES(100004,"A","B","C");
INSERT INTO TestTABLE VALUES(100005,"A","B","C");
向MySQL提交脚本文件 Test.sql
C:Documents and Settingsoger>mysql -u root -p < d:Test.sql
Enter password: ********
3.2 Java Test :
// MySQLViewer
import java.sql.*;
import java.util.*;
class MySQLViewer {
public MySQLViewer() {
  Statement stmt = null;
  ResultSet rs = null;
  String sqlStr = null;
  try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   //根据当前实际情况修改其中用户名和密码
   Connection conn = DriverManager.getConnection(
    "jdbc:mysql://localhost/TestDB?user=root&password=88888888");
   stmt = conn.createStatement();
   sqlStr = "SELECT * FROM TestTABLE";
      rs = stmt.executeQuery(sqlStr);
   if (rs != null) {
    Vector columnHeads = new Vector();
    Vector rows = new Vector();   
    //获取字段的名称
    ResultSetMetaData rsmd = rs.getMetaData();
    for ( int i = 1; i <= rsmd.getColumnCount(); ++i ) {     
     columnHeads.addElement( rsmd.getColumnName( i ) );
    }
    //打印字段名称
    for ( int i = 1; i <= rsmd.getColumnCount(); ++i ) {
     // Vector 采用数组方式索引
     System.out.print(columnHeads.get(i-1)+"        ");
    }
    //获取记录集
    // 移动纪录指针到首记录
    rs.beforeFirst();
    while(rs.next()) {
     rows.addElement( getNextRow( rs, rsmd ) );
    }
   }
  }
  catch (Exception e) {
   System.out.println(e.toString());
  }
  finally {
   if (rs != null) {
    try {
     rs.close();
    }
    catch (SQLException sqlEx) {
     rs = null;
    }
   }
   
   if (stmt != null) {
    try {
     stmt.close();
    }
    catch (SQLException sqlEx) {
           stmt = null;
       }
   }
  }   
}
private Vector getNextRow( ResultSet rs, ResultSetMetaData rsmd )
       throws SQLException {
  Vector currentRow = new Vector();
        for ( int i = 1; i <= rsmd.getColumnCount(); ++i ) {
            currentRow.addElement( rs.getString( i ) );
     }
     //打印每条记录中每个字段
  System.out.println();
  for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
   System.out.print(currentRow.get(i-1)+"        ");
  
  //返回一条记录   
  return currentRow;
}
public static void main(String[] args) {
  MySQLViewer app = new MySQLViewer();  
}
}
---------- java ----------
column1 column2 column3 column4
100001 A B C
100002 A B C
100003 A B C
100004 A B C
100005 A B C
Output completed (1 sec consumed) - Normal Termination


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/3534/showart_32326.html