´ó¼Ò°ï¼ì²éÒ»¶ÎJSP´úÂ룡ÐÂÊÖÇó¾È£¡Ð»Ð»
ÎÒдÁ˶δúÂë×ÜÊDZ¨´í£¬´ó¼Ò°ïæ¿´¿´ÊÇʲôÎÊÌ⣡´úÂ빦ÄÜÊǴӵǽҳ»ñÈ¡Á½¸ö²ÎÊý£¬unameºÍpassword£¬È»ºóÔÚÊý¾Ý¿âÀï²éѯÕâÁ½¸öÖµÊÇ·ñ´æÔÚ£¬Èç¹û´æÔÚ¾ÍÌø×ªµ½³É¹¦Ò³Ã棬²»´æÔÚ¾ÍÌø×ªµ½µÇ½ҳ£¡
<body>
<%!
boolean flag = false ;
%>
<%
try{
request.setCharacterEncoding("GBK");
String username = request.getParameter("uname");
String userpass = request.getParameter("password");
DataBase db = new DataBase();
String sql = "SELECT username,userpass from admin WHERE username ='"+username+"' and userpass='"+userpass+"' ";
ResultSet rs=db.executeQuery(sql);
if(rs.next()){
flag = true ;
}
db.close();
}catch(Exception e ){}
if(flag){
%>
<jsp:forward page="ad_index.jsp"/>
<%
}else{
%>
<jsp:forward page="login.htm"/>
<%
}
%>
</body>
±¨Ê²Ã´´í°¡£¿
Ôõô¿´Ä
Ïà¹ØÎÊ´ð£º
ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
Óм¸¸öÎÊÌâÂé·³Çë½ÌÒ»ÏÂ
¶÷£¬ÎÊÌâ±È½Ï¶à£¬Õæ²»ºÃÒâ˼À²
1.jsp¿ª·¢×öÒ³ÃæÏÔʾµÄʱºò£¬ÄÇЩ°´Å¥£¬ÁÐ±í£¬²éѯ¿ò£¬¶àtab±êÇ©µÈµÈÕâЩÏÔʾµÄÓ¦¸Ã½Ð×ö¿Ø¼þµÄ¶«Î÷£¬ÊÇ·ñÓпªÔ´µÄ×é¼þ¿ÉÒÔÄÃÀ´ÓÃÄØ£¿Õâ¸öÎÒ²»ÊǺÜÊìϤ£¬ ......
ÎÒ¸Õ×öºÃÒ»¸öjspµÄ¹ºÎïÉ̳ǣ¬¿ÉÎÒ²»»áÔõô·¢²¼µ½ÍøÉÏ£¡ÓÐËÄܰï°ïÎÒ
¿ÉÒÔ×Ô¼º×âÓÃһ̨·þÎñÆ÷ÅäÖ㬹ØÓÚÉÏ´«µÄ»°£¬¾ÍÊÇÓÃÉÏ´«Èí¼þ£¬°ÑÄãµÄ³ÌÐò´«µ½·þÎñÆ÷ÉÏ¡£
mark
´ò¸öwar°ü·ÅÉÏÈ¥¾ÍÐÐÁË
Õ¦ÌýÄãÃÇ˵µÄÕâ ......