大家好,谁下载,并调试成功过"学生课绩管理系统"
我在调试时,老登陆不进去,
我怀疑是数据库连接的问题,请高手们指导
有关登入的几个程序如下,请大家看看有没有错误:
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);
} }
}
