📄 如何用jsp读取mysql数据库.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0057)http://eps.www85.cn4e.com/java/article/devshow.asp?id=121 -->
<HTML><HEAD><title>csdn_如何用Jsp读取Mysql数据库</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<STYLE type=text/css>TD {
FONT-FAMILY: "Verdana", "Arial", "宋体"; FONT-SIZE: 9pt
}
A {
COLOR: #660000; TEXT-DECORATION: underline
}
A:hover {
COLOR: #660000; TEXT-DECORATION: none
}
.line {
LINE-HEIGHT: 14pt
}
</STYLE>
<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff text=#000000>
<table><tbody>
<TR>
<TD height=21>
<DIV align=center><B><FONT size=3>如何用Jsp读取Mysql数据库 <BR><FONT
size=2>
</FONT></FONT></FONT>
<HR align=center color=#cccccc noShade SIZE=1>
</DIV></TD></TR>
<TR>
<TD class=line><FONT
color=#333300><%//说明count是总的记录的条数 <BR>//page是用户提交的参数,用于控制分页的,允许的值是正整数,负整数 <BR>int i=count/15; //总页,每页显示15条记录 <BR>int j=i/10; //总的大页 ,没10个页面分一大页 <BR>//Page 显示的页面 <BR>int StartPage; <BR>//int HrefPage; <BR>if (Page<0) Page=0-Page*10; //10页分一次 <BR>StartPage=Page/10; //10页分一次 <BR>out.print ("[共有"+i+"页]"); <BR>//out.print ("共有"+j+"屏"); <BR>//out.print ("显示第"+Page+"页"); <BR>//out.print ("StartPage="+StartPage); <BR>if (StartPage>0) <BR>out.print ("|<a href=\"connectmysql.jsp?page=-"+Integer.toString(StartPage-1)+"\">前10页</a>"); <BR>for (int k=0;k<10;k++) <BR>{ int p=StartPage*10+k; <BR>if (p>i) break; <BR>if (p==Page) <BR>out.print ("|第"+Integer.toString(p+1)+"页"); <BR>else <BR>out.print ("|<a href=\"connectmysql.jsp?page="+p+"\">第"+Integer.toString(p+1)+"页</a>"); <BR>} <BR>if (StartPage<j) <BR>out.print ("|<a href=\"connectmysql.jsp?page=-"+Integer.toString(StartPage+1)+"\">后10页</a>"); <BR>out.print ("|"); <BR>%> <BR> <BR> <BR> <BR></FONT></TD></TR>
<TR>
<TD height=5>
<HR align=center color=#cccccc noShade SIZE=1>
</TD></TR></TBODY></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -