相关软件和驱动：
Mysql下载版本：4.1.11
http://dev.mysql.com/downloads/mysql/4.1.html

JDBC驱动下载版本：3.1.8
http://dev.mysql.com/downloads/connector/j/3.1.html

复制代码 代码如下:
代码

Code highlighting produced by Actipro CodeHighlighter (freeware)http://.mysql.jdbc.Driver");
System.out.println("加载驱动成功!");
} catch (ClassNotFoundException e) {
System.out.println("加载驱动失败!");
e.printStackTrace();
}
// 建立连接
try {
con = DriverManager.getConnection(url, username, password);
stmt = con.createStatement();
System.out.println("数据库连接成功!");
} catch(SQLException e) {
System.out.println("数据库连接失败!");
}
}
public static void select(String sql) {
try {
rs = stmt.executeQuery(sql);
ResultSetMetaData meta_data = rs.getMetaData();//列名
for (int i_col = 1; i_col <= meta_data.getColumnCount(); i_col++) {
System.out.print(meta_data.getColumnLabel(i_col) + " ");
}
System.out.println();
while (rs.next()) {
for (int i_col = 1; i_col <= meta_data.getColumnCount(); i_col++) {
System.out.print(rs.getString(i_col) + " ");
}
System.out.println();
}
rs.close();
}catch (Exception e) {
System.out.println("数据查询失败!");
}
}
public static void insert(String sql) {
try {
stmt.clearBatch();
stmt.addBatch(sql);
stmt.executeBatch();
System.out.println("数据插入成功!");
}catch (Exception e) {
System.out.println("数据插入失败!");
}

}
public static void update(String sql) {
try {
stmt.executeUpdate(sql);
System.out.println("数据更新成功!");
}catch (Exception e) {
System.out.println("数据更新失败!");
}
}
}