Java編程學(xué)習(xí)示例
一、運行前準(zhǔn)備
建議了一個MS SQLServer7數(shù)據(jù)庫 DNS，名稱為：Test_DB
數(shù)據(jù)庫中有一個表：guestbook字段為：name(varchar),email(varchar),body(text)
數(shù)據(jù)庫用戶為sa 密碼空，可以自己修改的。
二、代碼
<%@ page="" contenttype="text/html;charset=gb2312">
<%
/pic/p>
java.sql.Connection sqlCon; /pic/p>
java.sql.Statement sqlStmt; /pic/p>
java.sql.ResultSet sqlRst; /pic/p>
java.lang.String strCon; /pic/p>
java.lang.String strSQL; /pic/p>
int intPageSize; /pic/p>
int intRowCount; /pic/p>
int intPageCount; /pic/p>
int intPage; /pic/p>
java.lang.String strPage;
int i,j,k; /pic/p>
intPageSize = 5; /pic/p>
strPage = request.getParameter("page");
if(strPage==null){
/pic/p>
intPage = 1;
} else{
/pic/p>
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1; }
/pic/p>
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/pic/p>
strCon = "jdbc:odbc:Test_DB";
/pic/p>
sqlCon = java.sql.DriverManager.getConnection(strCon,"sa","");
/pic/p>
sqlStmt = sqlCon.createStatement();
/pic/p>
strSQL = "select count(*) from guestbook";
sqlRst = sqlStmt.executeQuery(strSQL);
/pic/p>
sqlRst.next(); /pic/p>
intRowCount = sqlRst.getInt(1);
sqlRst.close(); /pic/p>
/pic/p>
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
/pic/p>
/pic/p>
strSQL = "select name,email,body from guestbook";
/pic/p>
sqlRst = sqlStmt.executeQuery(strSQL);
/pic/p>
i = (intPage-1) * intPageSize;
for(j=0;j
jdbc-odbc留言版
<%
/pic/p>
i = 0;
while(i
| 姓名：<%=sqlrst.getstring(1)%> |
| 郵件：<%=sqlrst.getstring(2)%> |
| <%=sqlrst.getstring(3)%> |
<%>
<%if(intPage
下一頁<%
}
%>
<%if(intpage>1){%>
上一頁<%
}
%>
<%
/pic/p>
sqlRst.close();
/pic/p>
sqlStmt.close();
/pic/p>
sqlCon.close();
%>
三、怎么去運行？
將代碼存為文件test.jsp
Orion Application Server下：
Copy到orion的default-web-app目錄下，通過：
/pic/test.jsp
訪問測試
對于Resin,Tomcat,JWS等等，都可以運行通過。
【Java編程學(xué)習(xí)示例】相關(guān)文章：
Java編程語言02-10
java編程基礎(chǔ)09-22
java編程術(shù)語03-09