我們在用java開發(fā)時會經(jīng)常用到數(shù)據(jù)庫,數(shù)據(jù)庫可以保存數(shù)據(jù)以及對數(shù)據(jù)的管理.當(dāng)然連接數(shù)據(jù)庫是我們開發(fā)的第一步,如果你不連接數(shù)據(jù)庫,你何談對數(shù)據(jù)庫進行操作,在連接數(shù)據(jù)庫過程中,我們會遇到許多的問題,下面由我來講解,怎么連接數(shù)據(jù)庫,以及在連接過程中出現(xiàn)的錯誤.
下載JDBC
1.第一步? 百度搜索 ”mysql-connector-java-5.1.24-bin.jar”并下載.把這mysql-connector-java-5.1.24-bin.jar??????????????????????????????
文件放到C:jdk1.7.0_67jrelibext(這里是我的jdk的目錄中).
2.第二步 (1)打開eclipse 并且創(chuàng)建java project(file-new-other-java project),我創(chuàng)建了”linkMysql1”(2)在src中創(chuàng)建包—linkMysql1.在創(chuàng)建的包中創(chuàng)建類–LinkMysql.
添加代碼
1.第三步 寫加載JDBC的函數(shù),注意:我們測試是時全是在main函數(shù)里面的.
try?{ ??????????Class.forName("com.mysql.jdbc.Driver");?????//加載MYSQL?JDBC驅(qū)動程序?? ??????????//Class.forName("org.gjt.mm.mysql.Driver"); ?????????System.out.println("Success?loading?Mysql?Driver!"); ????????} ????????catch?(Exception?e)?{ ??????????System.out.print("Error?loading?Mysql?Driver!"); ??????????e.printStackTrace(); ????????}
2.第四步 連接數(shù)據(jù)庫,
Connection?connect?=?DriverManager.getConnection( ??????????????"jdbc:mysql://localhost:3306/ter","root","123456"); ???????????????//連接URL為???jdbc:mysql//服務(wù)器地址/數(shù)據(jù)庫名??，后面的2個參數(shù)分別是登陸用戶名和密碼
3.第五步 對數(shù)據(jù)庫進行操作,在這里我的數(shù)據(jù)庫名字是ter.其中紅色標(biāo)注的是我們熟悉的數(shù)據(jù)庫操作
4.第六步 啟動數(shù)據(jù)庫服務(wù) 按CTRL+SHIFT+ESC,點擊服務(wù).–找到Mysql右擊啟動
完整代碼
package?linkMysql1; import?java.sql.*; public?class?LinkMysql?{ ??? ????public?static?void?main(String?args[])?{ ????????try?{ ??????????Class.forName("com.mysql.jdbc.Driver");?????//加載MYSQL?JDBC驅(qū)動程序?? ??????????//Class.forName("org.gjt.mm.mysql.Driver"); ?????????System.out.println("Success?loading?Mysql?Driver!"); ????????} ????????catch?(Exception?e)?{ ??????????System.out.print("Error?loading?Mysql?Driver!"); ??????????e.printStackTrace(); ????????} ????????try?{ ??????????Connection?connect?=?DriverManager.getConnection( ??????????????"jdbc:mysql://localhost:3306/ter","root","123456"); ???????????????//連接URL為???jdbc:mysql//服務(wù)器地址/數(shù)據(jù)庫名??，后面的2個參數(shù)分別是登陸用戶名和密碼 ? ??????????System.out.println("Success?connect?Mysql?server!"); ??????????Statement?stmt?=?connect.createStatement(); ??????????ResultSet?rs?=?stmt.executeQuery("select?*?from?user"); ??????????????????????????????????????????????????????????????????//user?為你表的名稱 ????while?(rs.next())?{ ????????????System.out.println(rs.getString("name")); ??????????} ????????} ????????catch?(Exception?e)?{ ??????????System.out.print("get?data?error!"); ??????????e.printStackTrace(); ????????} ??????} ? }
說明
記得打開Mysql
