JSP+SQLµÇ¼ע²áÒ³ÃæÒ»Ð©ÎÊÌâ
ÎÒµÄlogin.jsp¾ÍÊǼòµ¥µÄÏÖʵµÇÂ¼Ò³Ãæ£¬ÎÒµÄLoginGo.jspµÄ²¿·Ö´úÂëÈçÏ£º
<%@ page contentType="text/html; Charset=GB2312" language="java" import="java.sql.*,java.util.*,myPk.*" %>
<% Connection con;
Statement sql;
ResultSet rs;
String ID,Pwd,Figure;//µÇ¼Õ˺ţ¬ÃÜÂ룬µÇ¼Éí·Ý¼¶±ð
ID=request.getParameter("loginid");//loginidÊÇlogin.jspÖÐÕ˺ŵÄÎı¾¿òÃû×Ö
Pwd=request.getParameter("password");//passwordÊÇlogin.jspÖÐÃÜÂëµÄÃÜÂë¿òÃû×Ö
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
out.print(e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:TestScore","","");
sql=con.createStatement();
rs=sql.executeQuery("select * from users where ID='"+ID+"' and Pwd='"+Pwd+"'");
if(rs.next()){
Figure=rs.getString("Figure");
session.setAttribute("Figure",Figure);
if(Figure.equals("ѧÉú")){
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......