MySQL缈婚〉渚嬪瓙
|
涓�銆佽繍琛屽墠鍑嗗 銆�銆� 涓嬭浇浜唌ysql鐨刯dbc椹卞姩锛堜竴涓猨ar鏂囦欢锛夊苟鍔犺浇鍦–LASSPATH(鏂规硶瑙併�奐AVA/JSP瀛︿範绯诲垪涔嬩竴(JDK瀹夎) 銆�) 銆�銆� (濡傛灉鎵句笉鍒帮紝璇蜂粠鏈珯涓嬭浇) 銆�銆� 寤轰竴涓狹ySQL鏁版嵁搴搕est
銆�銆� 鏁版嵁搴撲腑鏈変竴涓〃锛歯ote锛屽瓧娈典负锛歯ame(varchar) 浜屻�佷笅杞斤紝瀹夎 <%@ page contentType="text/html;charset=gb2312" %> <% java.sql.Connection sqlCon; //鏁版嵁搴撹繛鎺ュ璞� java.sql.Statement sqlStmt; //SQL璇彞瀵硅薄 java.sql.ResultSet sqlRst; //缁撴灉闆嗗璞� java.lang.String strCon; //鏁版嵁搴撹繛鎺ュ瓧绗︿覆 java.lang.String strSQL; //SQL璇彞 int intPageSize; //涓�椤垫樉绀虹殑璁板綍鏁� int intRowCount; //璁板綍鎬绘暟 int intPageCount; //鎬婚〉鏁� int intPage; //寰呮樉绀洪〉鐮� java.lang.String strPage; int i; //璁剧疆涓�椤垫樉绀虹殑璁板綍鏁� intPageSize = 2; //鍙栧緱寰呮樉绀洪〉鐮� strPage = request.getParameter("page"); if(strPage==null){ //琛ㄦ槑鍦≦ueryString涓病鏈塸age杩欎竴涓弬鏁帮紝姝ゆ椂鏄剧ず绗竴椤垫暟鎹� intPage = 1; } else{ //灏嗗瓧绗︿覆杞崲鎴愭暣鍨� intPage = java.lang.Integer.parseInt(strPage); if(intPage<1) intPage = 1; } //瑁呰浇JDBC椹卞姩绋嬪簭 Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //杩炴帴鏁版嵁搴� sqlCon= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test"); //鍒涘缓璇彞瀵硅薄 sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENS99vIVE,java.sql.ResultSet.CONCUR_READ_ONLY); //鎵цSQL璇彞 strSQL = "select name from note"; //鎵цSQL璇彞骞惰幏鍙栫粨鏋滈泦 sqlRst = sqlStmt.executeQuery(strSQL); //鑾峰彇璁板綍鎬绘暟 sqlRst.last(); intRowCount = sqlRst.getRow(); //璁扮畻鎬婚〉鏁� intPageCount = (intRowCount+intPageSize-1) / intPageSize; //璋冩暣寰呮樉绀虹殑椤电爜 if(intPage>intPageCount) intPage = intPageCount; %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>JSP鏁版嵁搴撴搷浣滀緥绋� - 鏁版嵁鍒嗛〉鏄剧ず - JDBC 2.0 - mysql</title> </head> <body> <table border="1" cellspacing="0" cellpadding="0"> <tr> <th>濮撳悕</th> </tr> <% if(intPageCount>0) { //灏嗚褰曟寚閽堝畾浣嶅埌寰呮樉绀洪〉鐨勭涓�鏉¤褰曚笂 sqlRst.absolute((intPage-1) * intPageSize + 1); //鏄剧ず鏁版嵁 i = 0; while(i<intPageSize && !sqlRst.isAfterLast()){ %> <tr> <td> <%=sqlRst.getString(1)%> </td> </tr> <% sqlRst.next(); i++; } } %> </table> 绗�<%=intPage%>椤� 鍏�<%=intPageCount%>椤� <%if(intPage<intPageCount){%><a href="mysqlpage.jsp?page=<%=intPage+1%>">涓嬩竴椤�</a><%}%> <%if(intPage>1){%><a href="mysqlpage.jsp?page=<%=intPage-1%>">涓婁竴椤�</a><%}%> </body> </html> <% //鍏抽棴缁撴灉闆� sqlRst.close(); //鍏抽棴SQL璇彞瀵硅薄 sqlStmt.close(); //鍏抽棴鏁版嵁搴� sqlCon.close(); %> 涓夈�佹�庝箞鍘昏繍琛岋紵 銆�銆� 瑙佸墠鏂囥�奐AVA/JSP瀛︿範绯诲垪涔嬩簲(JDBC-ODBC缈婚〉渚嬪瓙)銆嬨�� 源代码网供稿. |
