¼òµ¥µÄjsp·ÖÒ³
<%@ page import="java.sql.*,java.io.*" %>
<%
int intPage;//´ýÏÔʾµÄÒ³Âë
int pageSize;//ÿҳÏÔʾµÄÌõÄ¿
int pageCount;//×ÜÒ³Êý
int rowCount;//¼Ç¼×ÜÊý
String strPage;//»ñÈ¡´ýÏÔʾҳÂë
pageSize=12;//ÉèÖÃÿҳÏÔʾÌõÊý
Connection con;//Á¬½Ó¶ÔÏó
Statement stmt;//Êý¾Ý¿â¶ÔÏó
ResultSet rs£»//½á¹û¼¯
String strCon;//Á¬½Ó×Ö·û´®
strPage=request.getParameter("page");
if(strPage==null)
{
int page=1;
}
else
{
intPage=Integer.parseInt(strPage);
if(intPage<1)
intPage=1;
}
//×°ÔØSQLÇý¶¯
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
out.print("¼ÓÔØÇý¶¯´íÎó");
}
//ÉèÖÃÁ¬½Ó×Ö·û´®
strCon="jdbc:mysql://localhost:3306/database";
//Á¬½ÓÊý¾Ý¿â
con=DriverManager.getConnection(strCon,"root","");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//ÉèÖÃsqlÓï¾ä
strSql="select * from bwf_appraise order by appraiseDate desc";
//Ö´ÐÐSQLÓï¾ä²¢»ñÈ¡½á¹û¼¯
rs=stmt.executeQuery(strSql);
//»ñÈ¡¼Ç¼×ÜÊý
rs.last();
rowCount=rs.getRow()
%>
Ïà¹ØÎĵµ£º
ij¸öjspÒ³ÃæµÚÒ»´ÎÔËÐÐʱ£¬tomcat»á°ÑËü±àÒë³ÉjavaÎļþ£¬ÒÔºóÔËÐиÃÒ³ÃæÊ±£¬tomcat»á¶Ô±ÈjspºÍjavaÎļþµÄÈÕÆÚ£¬Èç¹ûСÓÚ»òµÈÓÚjavaÎļþÔòÈÏΪÊÇjavaÎļþÊÇ×îеÄ,¾ÍÖ±½ÓÔËÐÐÁË
tomcat ÏÂÓиöworkĿ¼,ÀïÃæÓÐÄãËùÓÐÓ¦ÓÃ./tomcat6/work/Catalina/localhost¡£ËùÓеÄjspÒ³ÃæÊ×ÏÈÒª±»±àÒë³É.class
ÔÚÔËÐÐʱ,tomcat»áÖ±½Ó¼ÓÔØcl ......
Ò»¡¢Expression Language
EL±í´ïʽÓÃÓÚ»ñÈ¡²¢ÏÔÊ¾Ò³ÃæÊý¾Ý£¬²¢Ìæ»»JSPÒ³ÃæÖеĽű¾±í´ïʽ¡£ËüÊÇJSP 2.0¹æ·¶ÖеÄÒ»Ãż¼Êõ ¡£Òò´Ë£¬ÈôÏëÕýÈ·½âÎöEL±í´ïʽ£¬ÐèʹÓÃÖ§³ÖServlet2.4/JSP2.0¼¼ÊõµÄWEB·þÎñÆ÷¡£
1¡¢ EL±í´ïʽÒþʽ¶ÔÏó
Òþº¬¶ÔÏóÃû³Æ
Ãè Êö
pageContext
¶ÔÓ¦ÓÚJSPÒ ......
function editFormSubmit() {
var dataForm = Ext.getDom("dataForm");
var conn = new Ext.data.Connection({url:"edit.action"});
conn.request({
params:{
selectId: ......
<%@ page contentType="application/msexcel" %>
<%
//¶ÀÁ¢´ò¿ªexcelÈí¼þ
response.setHeader("Content-disposition","attachment; filename=MyExcel.xls");
//ǶÌ×ÔÚieÀï´ò¿ªexcel & ......