JSPʵÏֵǽ½çÃæµ½×¢²áÒ³ÃæÌø×ª - Java / Web ¿ª·¢
СµÜѧOracle¿Î³ÌÉè¼ÆÐèÒª×ÔѧJSP
Ïë×öÒ»¸öµÇ½½çÃæ£¬´ÓÊý¾Ý¿âÖжÁÈ¡Óû§ÃûºÍÃÜÂ룬Èç¹ûÓû§ÃûºÍÃÜÂë¶¼ÕýÈ·£¬ÔòÌø×ªµÄadminÒ³Ãæ»òÕßreaderÒ³Ãæ
Èç¹ûûÓÐÓû§Ãû
Ö±½Óµã¡°×¢²á¡±°´Å¥£¬¾Í¿ÉÒÔÌø×ªµÄ×¢²áÒ³Ãæ£¬ÇëÎÊÕâ¸öÔõôʵÏÖÄØ£¿
Ì«ÄÛµÄÎÊÌ⣬´ó¼Ò²»ÒªÐ¦¹þ
ÓøöservletÌø×ª°É£¡ÔÚservletÖÐÅжϣ¡
Õâ¸ö±È½Ï¼òµ¥
ÈôÓû§ÃûΨһ
String admin = request.getParameter("user");
String pass = null;
int num = 0;
rs=stmt.executeQuery("select pass from admin where user="+user);
while(rs.next()){
pass = rs.getString(1);
num=1;
}
if(num == 1){
response.sendRedirect("admin.jsp");
}else{
response.sendRedirect("login.jsp");//Ìø×ªµ½×¢²áÒ³Ãæ
}
Õâ¸öºÜ¼ò½à.! LZÈç¹ûûÓÐʲô̫¶àµÄÒªÇó,¾ÍÓÃÕâ¸ö¾Í¹»ÁË
Ö§³Ö¶þÂ¥
LZ ˵µÄ¶¼ÊʺϳõѧÕß ÎҾͲ
Ïà¹ØÎÊ´ð£º
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......
ÔõôÑù½«id´«¹ýÈ¥°¡£¿£¿£¿ÊǼòµ¥µÄ´«¡£¡£¡£ÔÚµØÖ·À¸ÖÐдidºÅ
LZ ºÃÓÄĬ£¡²»ÖªµÀÄãµÄÒâ˼£¿
ÊÇÏë°ÑID ´«µ½ACTION ? ͨ¹ýURl id=?
²»¹»Ïêϸ ±ðÈ˲»ÖªµÀÔõÑù°ïÄã
../XXXXX.do?id=XXXX&id2=XXXXX
......