1. ?下載 ?如：mysql-connector-java-5.1.22.zip ?解壓獲取 jar 連接包。

2. ? 引入項目：? ? ?右鍵項目名--->Build Path—>Configure Build Path... ?選擇 ?Libraries 然后再選擇 右邊

? ? ? ? ? ? ? ? ? ? ? ? 第二個選項Add External Jars 導入 mysql -.jar

3. ? 新建數據表：

? ?

CREATE TABLE `user` (`ID` int(11) NOT NULL AUTO_INCREMENT,`Name` varchar(32) NOT NULL,`Age` int(11) NOT NULL,`AddTime` datetime NOT NULL,PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

?

4. 測試程序：

? ? ?

package App1.Rhythmk.com;import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;import com.mysql.jdbc.Statement;/** * 建表腳本CREATE TABLE `user` (`ID` int(11) NOT NULL AUTO_INCREMENT,`Name` varchar(32) NOT NULL,`Age` int(11) NOT NULL,`AddTime` datetime NOT NULL,PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;*/public class ThirdMysql {// final 類似 .NET 中 constprivate static final String DatabaseConURL = "jdbc:mysql://127.0.0.1:3306/rhythmkdb";/*** rhythmK* 1.右鍵項目名--->Build Path—>Configure Build Path... 會彈出來一個框 在那四個選項選擇* Libraries 然后再選擇 右邊 第二個選項Add External Jars*/public static void main(String[] args) {// TODO Auto-generated method stub Test();ExcuteByParam();Add();Update();Select();Del();}public static void Test() {try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(DatabaseConURL, "root", "wangkun");Msg("Mysql 連接成功。");} catch (Exception ex) {Msg(ex.toString());}}public static void Add() {String sql = "Insert into `user` (Name ,Age, Addtime ) ";sql += " values ('rhythmk',21,'2012-1-1') ";try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(DatabaseConURL, "root", "wangkun");java.sql.Statement statement = con.createStatement();statement.executeUpdate(sql);ResultSet result = statement.executeQuery("select LAST_INSERT_ID() ");int resultID = 0;if (result.next()) {// 此出索引不是從0開始 ..resultID = result.getInt(1);}Msg("Add 數據庫得到返回ID" + resultID);} catch (Exception ex) {Msg(ex.toString());}}public static void Update() {String sql = " Update `user` set Name= 'rhythmk.com' where ID<3 ";try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(DatabaseConURL, "root", "wangkun");java.sql.Statement statement = con.createStatement();int resultID = statement.executeUpdate(sql);Msg("Update 數據庫得到返回ID" + resultID);} catch (Exception ex) {Msg(ex.toString());}}public static void Del() {String sql = " Delete from `user` where ID=3 ";try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(DatabaseConURL, "root", "wangkun");java.sql.Statement statement = con.createStatement();int resultID = statement.executeUpdate(sql);Msg("Del 數據庫得到返回ID" + resultID);} catch (Exception ex) {Msg(ex.toString());}}public static void Select() {String sql = " Select ID,Name from `user` ";try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(DatabaseConURL, "root", "wangkun");java.sql.Statement statement = con.createStatement();ResultSet result = statement.executeQuery(sql);String resultStr = "";while (result.next()) {resultStr += "\r\n ID=" + result.getString(1);resultStr += ", Name=" + result.getString("Name");}Msg(resultStr);// statement.executeUpdate(sql); } catch (Exception ex) {Msg(ex.toString());}}public static void ExcuteByParam() {String sql = "select * from `user` where Name =?";try {Connection con = null;Class.forName("com.mysql.jdbc.Driver").newInstance();con = DriverManager.getConnection(DatabaseConURL, "root", "wangkun");java.sql.PreparedStatement preparedsm = con.prepareStatement(sql);preparedsm.setString(1, "rhythmk");ResultSet result = preparedsm.executeQuery();String resultStr = "";while (result.next()) {resultStr += "\r\n ID=" + result.getString(1);resultStr += ", Name=" + result.getString("Name");}Msg("ExcuteByParam:\r\n" + resultStr);// statement.executeUpdate(sql); } catch (Exception ex) {Msg(ex.toString());}}public static void Msg(String msg) {System.out.println(msg);}}

?

?

?

轉載于:https://www.cnblogs.com/rhythmK/archive/2013/01/26/2877989.html

總結

以上是生活随笔為你收集整理的Rhythmk 一步一步学 JAVA（2） ： 操作 MYSQL 数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。