JSPÒ³Ãæ²ãµÄ¾Ñ鱸Íü×ܽá
1£º²éÕÒÒ³ÃæµÄ´úÂë´íÎóÓÌÈçÒ½Éú¸ø²¡ÈË¿´²¡£¬²»ÄÜͷʹҽͷ£¬½ÅÍ´Ò½½Å£¬¾ÍÊÇ˵һ¸öµØ·½µÄ“´íÎó”ÍùÍùÊÇÓɱðµÄµØ·½ÓÐÎÊÌâ¶øÒý·¢µÄ¡£
2£ºÈç¹ûÊý¾Ý·ÅÔÚrequestÖÐ(¿ÉÄܰüÀ¨url²ÎÊý)£¬ÄÇôҪÔÚºóÐøµÄÒ³Ãæ(»òÊÇˢкó)Öп´µ½ÒÔǰµÄÊý¾Ý¿ÉÒÔʹÓÃ${param.yourdate},²»¹ý·ÅÔÚActionFormÖпÉÄܸüºÃһЩ¡£
3£ºÔÚJSPÒ³ÃæÖÐʹÓÃÈÕÆÚBean£¬¿ÉÒÔʹÓÃÒÔϱêÇ©¸ñʽ»¯ÈÕÆÚÊý¾Ý(Êý×Ö£¬ÈÕÆÚ¸ñʽ»¯)
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<fmt:formatNumber value="${now.rates}" pattern="#,##0.00#" />//Êý×Ö¸ñʽ»¯
<jsp:useBean id="now" class="java.util.Date" />
Æðʼʱ¼ä
<input type="text" name="startTime" value="<fmt:formatDate value="${now }" pattern="yyyy-MM"/>-01" //ÈÕÆÚ¸ñʽ»¯
onFocus="calendar()" />
½áÊøÊ±¼ä
<input type="text" name="endTime" value="<fmt:formatDate value="${now }" pattern="yyyy-MM-dd"/>"
readonly onFocus="calendar()" />
4:DAOÖеķ½·¨Ð´·¨£º·½·¨Ó¦¼Ì³Ðextends JdbcDaoSupport(ÐèÒª£ºimport org.springframework.jdbc.core.support.JdbcDaoSupport ¸ÃÀàÖзâ×°Á˺ܶàÓÐÓõķ½·¨,
Ö´ÐÐsqlÓï¾äÊÇʹÓãºthis.getJdbcTemplate() ÔÚµ÷ÓÃÏà¹ØµÄ·½·¨)
public Map findByProperty(String id, String startTime, String endTime) {
//logger.debug("finding WRONG_SMS_INFO instance with property: " + id);
String noUseSql = " select count(*) "
+ " from WRONG_SMS_INFO a,customer_info_getcnt b"
+ " where a.WORKER_ID=b.WORKER_ID"
+ " and a.receive_time>=to_date(?,'yyyy-MM-dd') and a.receive_time<to_date(?,'yyyy-MM-dd')+1"
+ " and b.DEPARTMENT_TREE like ? and a.OPERATION_CODE='05'";
Object[] totalParams = { startTime, endTime, depart };
Map map = null;
int total = 0;
try {
Ïà¹ØÎĵµ£º
MVCÊÇÓÉÄ£ÐͲ㣬ÊÓͼ²ã£¬¿ØÖƲã×é³É£¬MVCÌá¸ßÁË¿ª·¢Ð§ÂÊ£¬±ãÓÚά»¤
·ÖÒ³ÊÇWeb¿ª·¢ÖеÄÒ»¸öÖØÒªµÄ¹¦ÄÜ£¬ÄÇÔõÑùʵÏÖ·ÖÒ³ÄØ£¿£¿£¿
¼Ù·ÖÒ³ÊÇÖ¸²éѯ³öËùÓеÄÊý¾Ý£¬Ö»ÏÔʾÐèÒªµÄÊý¾Ý£¬ËüÍêÈ«ÓɳÌÐòʵÏÖ£¬¿ª·¢Ð§Âʲ»¸ß£¬µ«ÈÝÒ×ʵÏÖ
´úÂëÈçÏÂ:
Ò».Ä£ÐͲã
UserInfo(JavaBeanµÄʵÏÖ£¬´«µÝÊý¾Ý£©
package com.feng.test;
......
²Ù×÷·½·¨£º windows------preferences----------ËÑË÷ html----------ÕÒµ½ html SourceÕâÏî---------
ÕÒµ½ content assist (¼ûÏÂͼ)------Prompt when these¡£¡£¡£¡£ºóÃæÓиöÊäÈë¿ò£¨ÀïÃæÓиöСÓںţ©½ô¸ú СÓںźóÃæÊäÈëÒ»¸ö ¿Õ¸ñ¼ü £¬-----------apply----------ok¡£
ÔÚhtmlÖбà¼Ê ......
ÍøÕ¾×öÍêºó£¬²¢²»ÊÇÖ±½Ó·Åµ½·þÎñÆ÷£¨Tomcat£©ÖÐÈ¥ÔËÐУ¬¶øÊÇÏȽ«Æä´ò°ü³ÉWarÎļþ£¬ÔÙ°ÑWarÎļþ·Åµ½·þÎñÆ÷ÖÐÈ¥ÔËÐУ¬ÄÇÑù¸ü·½±ã
ÄÇôÔõÑù½«Ò»¸öJspÍøÕ¾´ò°üÄØ£¿£¿£¿
Ò».·½·¨Ò»
½øÈëcmdµ½dosÃüÁîÐÐÏ£¬½øÈëJspWeb(×¢ÒâÒª½øÈëJspWebĿ¼£¬¼´½øÈëÄãÒª´ò°üµÄÍøÕ¾µÄ¸ùĿ¼)
ÔÙÏÂÒ»²½
......
ºÜ¾ÃûÓÐÓÃMysqlÁË£¬·¢ÏÖССµÄʱ¼äÎÊÌâÒ²Óöµ½²»ÉÙÂé·³£¬ºÇºÇ
ËùÒÔ×ܽáһϣº
µÚÒ»ÖÖ:
Date time= new java.sql.Date(new java.util.Date().getTime());
µÚ¶þÖÖ:
java ÓÃPreparedStatementÀ´setDate,ÓÃÎʺŵÄÐÎʽ¸øÈÕÆÚÎʺŸ³Öµ
pstmt.setTimestamp(8, new Timestamp(System.currentTimeMillis()));
pst ......
ÔÚJspÖе÷ÓÃSerlvetÖÐÒѾ´æ´¢ÁËÐÅÏ¢µÄ JavaBean.
ServletÖÐÒѾ°ÑÊý¾Ý¿âµÄÐÅÏ¢±£´æµ½JavaBeanÖÐ,ÔÙ°ÑJavaBean±£´æµ½SessionÖÐ.
Jsp¿ªÊ¼µ÷ÓÃ:
<jsp:useBean id="key" type="ClassName" scope="Session" />
<jsp:getProperty name="key" property="PropertyName" />
ÎÞ·¨¶Á³öÐÅÏ¢:
ÔÒò: JavaBean ÖÐÊôÐÔµ ......