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>
執行結果
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END