大家好,谁下载,并调试成功过"学生课绩管理系统" 我在调试时,老登陆不进去, 我怀疑是数据库连接的问题,请高手们指导 有关登入的几个程序如下,请大家看看有没有错误: login.jsp <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %> <html> <head> <STYLE>A.menuitem { COLOR: menutext; TEXT-DECORATION: none } A.menuitem:hover { COLOR: highlighttext; BACKGROUND-COLOR: highlight } DIV.contextmenu { BORDER-RIGHT: 2px outset; BORDER-TOP: 2px outset; Z-INDEX: 999; VISIBILITY: hidden; BORDER-LEFT: 2px outset; BORDER-BOTTOM: 2px outset; POSITION: absolute; BACKGROUND-COLOR: buttonface }
</STYLE> <SCRIPT language=JavaScript> function Year_Month(){ var now = new Date(); var yy = now.getYear(); var mm = now.getMonth()+1; var cl = '<font color="#0000df">'; if (now.getDay() == 0) cl = '<font color="#c00000">'; if (now.getDay() == 6) cl = '<font color="#00c000">'; return(cl + yy + '年' + mm + '月</font>'); } function Date_of_Today(){ var now = new Date(); var cl = '<font color="#ff0000">'; if (now.getDay() == 0) cl = '<font color="#c00000">'; if (now.getDay() == 6) cl = '<font color="#00c000">'; return(cl + now.getDate() + '</font>'); } function Day_of_Today(){ var day = new Array(); day[0] = "星期日"; day[1] = "星期一"; day[2] = "星期二"; day[3] = "星期三"; day[4] = "星期四"; day[5] = "星期五"; day[6] = "星期六"; var now = new Date(); var cl = '<font color="#0000df">'; if (now.getDay() == 0) cl = '<font color="#c00000">'; if (now.getDay() == 6) cl = '<font color="#00c000">'; return(cl + day[now.getDay()] + '</font>'); } function CurentTime(){ var now = new Date(); var hh = now.getHours(); var mm = now.getMinutes(); var ss = now.getTime() % 60000; ss = (ss - (ss % 1000)) / 1000; var clock = hh+':'; if (mm < 10) clock += '0'; clock += mm+':'; if (ss < 10) clock += '0'; clock += ss; return(clock); } function refreshCalendarClock(){ document.all.calendarClock1.innerHTML = Year_Month(); document.all.calendarClock2.innerHTML = Date_of_Today(); document.all.calendarClock3.innerHTML = Day_of_Today(); document.all.calendarClock4.innerHTML = CurentTime(); } var webUrl = webUrl; document.write('<table border="0" cellpadding="0" cellspacing="0"><tr><td>'); document.write('<table id="CalendarClockFreeCode" border="0" cellpadding="0" cellspacing="0" width="60" height="70" '); document.write('style="position:absolute;visibility:hidden" bgcolor="#eeeeee">'); document.write('<tr><td align="center"><font '); document.write('style="cursor:hand;color:#ff0000;font-family:宋体;font-size:14pt;line-height:120%" '); if (webUrl != 'netflower'){ document.write('</td></tr><tr><td align="center"><font '); document.write('style="cursor:hand;color:#2000ff;font-family:宋体;font-size:9pt;line-height:110%" '); } document.write('</td></tr></table>'); document.write('<table border="0" cellpadding="0" cellspacing="0" width="61" bgcolor="#C0C0C0" height="70">'); document.write('<tr><td valign="top" width="100%" height="100%">'); document.write('<table border="1" cellpadding="0" cellspacing="0" width="58" bgcolor="#FEFEEF" height="67">'); document.write('<tr><td align="center" width="100%" height="100%" >'); document.write('<font id="calendarClock1" style="font-family:宋体;font-size:7pt;line-height:120%"> </font><br>'); document.write('<font id="calendarClock2" style="color:#ff0000;font-family:Arial;font-size:14pt;line-height:120%"> </font><br>'); document.write('<font id="calendarClock3" style="font-family:宋体;font-size:9pt;line-height:120%"> </font><br>'); document.write('<font id="calendarClock4" style="color:#100080;font-family:宋体;font-size:8pt;line-height:120%"><b> </b></font>'); document.write('</td></tr></table>'); document.write('</td></tr></table>'); document.write('</td></tr></table>'); setInterval('refreshCalendarClock()',1000); </SCRIPT> <script language="javascript"> <!-- function makearray(size) { this.length=size; for(i=1;i<=size;i++) { this[i]=0 } return this; } msg=new makearray(3) msg[1]="你好，欢迎使用学生课绩管理系统！！！" msg[2]="请您选择用户类新，输入正确的用户名，密码！！"; msg[3]="谢谢您的使用！！！" interval = 100; seq = 0; i=1; function Scroll() { document.tmForm.tmText.value = msg[i].substring(0, seq+1); seq++; if ( seq >= msg[i].length ) { seq = 0 ;i++;interval=900}; if(i>3){i=1}; window.setTimeout("Scroll();", interval );interval=100 } ; file://--> </script> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"; charset=gb2312"> <title>登陆</title> <SCRIPT Language = javascript> <!-- file://下面的副程序将执行资料检查 function isValid() { file://下面的if判断语句将检查是否输入帐号资料 if(frmLogin.id.value == "") { window.alert("您必须完成帐号的输入!"); file://显示错误信息 document.frmLogin.elements(0).focus(); file://将光标移至帐号输入栏 return false; } file://下面的if判断语句将检查是否输入帐号密码 if(frmLogin.password.value == "") { window.alert("您必须完成密码的输入!"); file://显示错误信息 document.frmLogin.elements(1).focus(); file://将光标移至密码输入栏 return false; file://离开函数 } frmLogin.submit(); file://送出表单中的资料 } --> </SCRIPT> <body bgcolor="#0099FF" OnLoad="Scroll()"> <form name="tmForm"> <input type="Text" name="tmText" size="40"> </form> <p> <% String getmessage = (String) session.getAttribute("error"); if (getmessage==null) {getmessage="";} %> <p1><font color="red"><%=getmessage%></font></p1></p> <p align="center"><font color="#33FF00" size="+4" face="华文行楷">学生课绩管理系统</font></p> <form name="frmLogin" method="post" action="http://localhost:8080/test/login_confirm" onSubmit="return isValid(this);"> <p> <div align="center"> <table width="47%" height="232" border=1 align="center" > <tr > <td height="44" colspan="2"> <div align="center"><font color="#FFFFFF" size="+2" face="华文行楷">请你输入</font></div></td> </tr> <tr > <td><div align="center"><font color="#FFFFFF"><strong>用户</strong></font><font color="#FFFFFF"><strong>：</strong></font></div></td> <td><input name="kind" type="radio" value="student" checked > <font color="#FFFFFF" size="+2" face="华文行楷">学生 </font> <input type="radio" name="kind" value="teacher"> <font color="#FFFFFF" size="+2" face="华文行楷"> 教师 </font> <input type="radio" name="kind" value="admin"> <font color="#FFFFFF" size="+2" face="华文行楷">管理员</font></td> </tr> <tr > <td width="27%"><div align="center"><strong><font color="#FFFFFF">登陆名</font><font color="#FFFFFF">：</font></strong></div></td> <td width="73%"><input name="id" type="text" id="id" size="20" maxlength="20"></td> </tr> <tr> <td><div align="center"><strong> <font color="#FFFFFF">密码：</font></strong></div></td> <td><input name="password" type="password" id="password" size="8" maxlength="8"></td> </tr> <tr > <td colspan="2"><div align="center"> <input type="submit" name="Submit" value="登陆"> </div></td> </tr> </table> <table> </table> </div> </form> </body> </html> ////////////////////// 此代码，部分改过///////////////////////////////////////////// package mypack; import java.io.*; import java.sql.*;
public class sqlBean{///
public Connection con=null;
public Connection sqlBean(){/////构造函数
String CLASSFORNAME="com.microsort.jdbc.sqlserver.SQLServerDriver"; String SERVANDDB="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zibian"; String USER="sa"; String PWD="123";
try{
Class.forName(CLASSFORNAME); con=DriverManager.getConnection(SERVANDDB,USER,PWD); } catch(Exception e) { e.printStackTrace(); } return con; }
public ResultSet execQuery(String sql)throws Exception { ResultSet rst=null; Statement stmt=con.createStatement(); rst=stmt.executeQuery(sql); con.close(); return rst; }
} /////////////////login_confirm.java //////////// package mypack; import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*;
public class login_confirm extends HttpServlet{
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String message=null; String id=null; id=req.getParameter("id"); HttpSession session=req.getSession(true); session.setAttribute("id",String.valueOf(id)); String password=null; password= req.getParameter("password"); String kind =null; kind=req.getParameter("kind"); String temp =getPassword(req,res,id,kind); if( password.equals(temp)) goo(req,res,kind); else { message="用户名或密码有误！"; doError(req,res,message) ; } } public void goo(HttpServletRequest req, HttpServletResponse res,String kind) throws ServletException,IOException {
if(kind.equals("student")) { RequestDispatcher rd = getServletContext().getRequestDispatcher("/student.jsp"); rd.forward(req, res);} if(kind.equals("teacher")){ RequestDispatcher rd = getServletContext().getRequestDispatcher("/teacher.jsp"); rd.forward(req, res);} if(kind.equals("admin")){ RequestDispatcher rd = getServletContext().getRequestDispatcher("/admin.jsp"); rd.forward(req, res);} }
public String getPassword(HttpServletRequest req, HttpServletResponse res, String id,String kind) throws ServletException, IOException { sqlBean db= new sqlBean(); String pw=""; String sql="select password from '"+kind+"' where id='"+id+"'"; try{ ResultSet rst=db.execQuery(sql); if(rst.next() ){ pw= rst.getString("password"); } } catch(Exception e) { System.out.print(e.toString());} return pw; } public void doError(HttpServletRequest req, HttpServletResponse res, String str) throws ServletException, IOException {
req.setAttribute("problem", str); RequestDispatcher rd = getServletContext().getRequestDispatcher("/errorpage.jsp"); rd.forward(req, res); } public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String action = action = req.getParameter("action"); if ("logout".equalsIgnoreCase(action)) { HttpSession session=req.getSession(true); session.invalidate(); RequestDispatcher rd = getServletContext().getRequestDispatcher("/login.jsp"); rd.forward(req, res); } } }
----------------解决方案--------------------------------------------------------
发生错误了吗，如果有错误的话，就不仔细看看这些错误了，回有发现的
没有错误的话，那就要看你的代码了
在一些关键的地方可以加上一些调试语句或打印语句，看看是不是这些地方的问题
----------------解决方案--------------------------------------------------------