棣栧厛錛岃В寮MySQL 鐨凧DBC driver鐨勫帇緙╁寘錛屽叾瀹炲湪榪欎釜鍖呬腑鐪熸鏈夌敤鐨勫氨鏄痬ysql-connector-java-3.0.9-stable-bin.jar錛屾墍浠ユ垜鐩存帴鎶婂畠鏀懼埌c:systemmysql-jdbc錛堣繖涓洰褰曞彲浠ヨ嚜宸卞畾涔夛級涓?/FONT>
鍦↗Builder涓紝鍋氬涓嬬殑鎿嶄綔錛?/FONT>
涓銆侀夋嫨Tool -> Configure Libraries錛屽湪Configure Libraries紿楀彛涓夋嫨宸﹁竟鍒楄〃妗嗕笅鐨凬ew錛屽脊鍑篘ew Library Wizard 紿楀彛錛屽湪Name涓緭鍏ysql錛堝彲浠ヨ嚜宸卞畾涔夛級錛孡ocation涓夋嫨User Home錛岀偣鍑籄dd錛岄夋嫨mysql jdbc鐨勮礬寰勶細(xì)c:systemmysql-jdbc mysql-connector-java-3.0.9-stable-bin.jar錛岀偣鍑籵k錛堜袱嬈★級錛?/FONT>
浜屻侀夋嫨Project -> Project Properties -> Paths -> Required Libraries -> 鐐瑰嚮Add錛岄夋嫨絎竴姝ラ涓坊鍔犵殑User Home涓嬬殑mysql錛岀偣鍑籵k錛堜袱嬈★級錛?/FONT>
涓夈侀夋嫨Tool -> Enterprise Setup -> Database Drivers -> 鐐瑰嚮Add錛岄夋嫨鍒氭坊鍔犵殑User Home涓嬬殑mysql錛岀偣鍑籵k錛屽湪鍒楄〃妗嗕腑鍑虹幇mysql.config錛岀偣鍑籵k錛?/FONT>
鍥涖佹彁紺洪噸鏂板惎鍔↗Builder錛岃緗墠鑳界敓鏁堬紝紜畾鍚庯紝閲嶅惎JBuilder錛?/FONT>
浜斻侀夋嫨Tool -> Database Pilot 錛屽湪Database Pilot紿楀彛涓夋嫨View -> Options -> Drivers -> 鐐瑰嚮Add
Driver class涓緭鍏ワ細(xì)com.mysql.jdbc.Driver
Sample URL涓緭鍏ワ細(xì)mysql://localhost/DataBaseName 鐐瑰嚮ok錛?/FONT>
鍏佸湪Database Pilot紿楀彛涓夋嫨File -> New錛屽湪New URL 紿楀彛涓紝
Driver錛氫粠鍒楄〃涓夋嫨絎簲姝ラ寤虹珛鐨刢om.mysql.jdbc.Driver
URL錛氬皢DataBaseName鏀逛負(fù)瀛樺湪鐨勬暟鎹簱錛屾湰渚嬩腑鐨刄RL濡備笅錛歫dbc:mysql://localhost/admin錛岀偣鍑籵k錛?/FONT>
涓冦佸湪Database Pilot紿楀彛涓璂atabase URLs鍒楄〃涓弻鍑誨垰寤虹珛鐨剈rl錛岃緭鍏ヨ繛鎺ユ暟鎹簱鐨勭敤鎴峰悕銆佸瘑鐮侊紝榪炴帴鎴愬姛銆?BR>
闄勬祴璇曠▼搴忥細(xì)
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorinfo.jsp"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%
//Initialize
java.sql.Connection conn;
java.sql.Statement stmt;
java.sql.ResultSet rst;
Class.forName("com.mysql.jdbc.Driver").newInstance();
String strUrl = "jdbc:mysql://localhost/admin";
String strQuery = "select * from test3";
conn= DriverManager.getConnection(strUrl, "root", "");
stmt = conn.createStatement();
rst = stmt.executeQuery(strQuery);
rst.next();
%>
<%=rst.getString("a")%>
<%
rst.absolute();
conn.close();
%>
娉細(xì)test3涓烘暟鎹簱admin閲岄潰鐨勪竴涓〃銆?/FONT>