詳解MySQL的簡單使用和JDBC示例代碼分享

MySql簡單操作

<code>//啟動mysql  net?start?mysql  ?  //登陸  mysql?-u?root?-p  ?  ?  //創建建數據庫  create?database?mydb;  create?database?test;  ?  //刪除數據庫  drop?database?test;  ?  //使用數據庫  use?mydb;  ?  //創建表  create?table?mytable(name?varchar(20),sex?char);  ?  //顯示數據庫中所有表  show?tables;  ?  //增加一列  alter?table?mytable?add?age?int;  ?  //插入  insert?mytable?value("liu",'f',22);  insert?mytable?value("wang",'m',22);  insert?mytable(name,sex)?value("li",'f');  insert?mytable?value("zhao",'m',22);  ?  //刪除表中項  delete?from?mytable?where?name=”liu“;  delete?from?mytable?where?name=”li“;  ?  //更新  update?mytable?set?age?=?23?where?name?=?"wang";  ?  //查詢  select?*?from?mytable;  ?  </code>

JDBC

jdbc驅動程序分為4類

JDBC-ODBC橋 部分本地API,部分Java驅動程序 JDBC網絡純Java驅動程序 本地協議Java驅動程序

JDBC的示例

<code>import?java.sql.*;  import?com.mysql.jdbc.Driver;  public?class?JDBCMySql?{  ?????  ????public?void?operateMySql()?throws?SQLException,?ClassNotFoundException{  ?????????  ????????String?driverName?="com.mysql.jdbc.Driver";  ????????String?URL?=?"jdbc:mysql://127.0.0.1:3306/mydb";  ????????String?sql?=?"SELECT?*?FROM?mydb.mytable";  ????????String?username?=?"root";  ????????String?password?=?"";  ????????Connection?conn?=?null;  ????????try{  ?????????  ????????//加載驅動  ????????Driver.class.forName(driverName);  ?????????  ????????//建立連接  ????????conn?=?DriverManager.getConnection(URL,username,password);  ?????????  ????????//創建statement來執行sql語句  ????????Statement?ps?=??conn.createStatement();  ?????????  ????????//結果集處理  ????????ResultSet?rs?=?ps.executeQuery(sql);  ????????while(rs.next())?{????????  ????????System.out.println(rs.getString("name")+","+rs.getString("sex")+","+rs.getInt("age"));????  ????????????}  ????????}  ????????catch?(ClassNotFoundException?e)?{  ????????????e.printStackTrace();  ????????}?  ????????catch(SQLException?e){  ????????????e.printStackTrace();  ????????}  ?????????  ????????//關閉連接  ????????finally{  ????????????if(conn!=null){  ????????????????try{  ????????????????????conn.close();  ????????????????}catch(SQLException?e){  ????????????????????e.printStackTrace();  ????????????????}  ????????????}  ????????}???  ????}???  }</code>

建立一個test case來驗證一下

<code>  import?static?org.junit.Assert.*;  ?  import?java.sql.SQLException;  ?  import?org.junit.Before;  import?org.junit.Test;  ?  public?class?JDBCTest?{  ?  ????@Test  ????public?void?test()?throws?ClassNotFoundException,?SQLException?{  ????????JDBCMySql?jm?=?new?JDBCMySql();  ????????jm.operateMySql();  ????}  ?  }</code>

執行結果

詳解MySQL的簡單使用和JDBC示例代碼分享

詳解MySQL的簡單使用和JDBC示例代碼分享

? 版權聲明
THE END
喜歡就支持一下吧
點贊5 分享