简单学生选课系统之学生身份登录

时间：2022-07-08 19:11:06

图片

简单学生选课系统之学生身份登录     简单学生选课系统之学生身份登录简单学生选课系统之学生身份登录简单学生选课系统之学生身份登录简单学生选课系统之学生身份登录简单学生选课系统之学生身份登录简单学生选课系统之学生身份登录简单学生选课系统之学生身份登录

代码：

dofirstpage.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
    request.setCharacterEncoding("utf-8");
    String snos=request.getParameter("studentno");
    session.setAttribute("stuno",snos);
    String pass=request.getParameter("password");
    String type=request.getParameter("types");
    UseDao use=new UseDao();
    ResultSet rst=use.loginUser(snos,pass,type);
    if(rst!=null){
          while(rst.next()){ 
                   if(rst.getString("type").equals("学生")){   
%>
                          <jsp:forward page="stpage.jsp"/>
<%    
                       }
                  else if(rst.getString("type").equals("管理员")){
 %>
                          <jsp:forward page="adpage.jsp"/>
<%   
                       }
         }
    }               
    else{
    out.println("学号或密码不正确，请重新输入！");
      }

%>
stpage.jsp(出现左右界面) 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>学生登录界面</title>
<frameset cols="20%,60%">
<frame src="stframemenu.jsp" name="menu">
<frame src="" name="main">
</frameset>
</head>
<body>
</body>
</html>

stframemenu.jsp 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>学生登录菜单条</title>
<style type="text/css">
a{
 text-decoration:none;
} 
span{
 line-height:40px;
 margin-left:20px;
}
</style>
</head>
<body>
<body style="background:#AAFFEE;color:black">
<span><a href="../stujavaBean/course.jsp" target="main">选修课程</a></span><br>
<span><a href="../stujavaBean/ashowCourse.jsp" target="main">选修结果</a></span><br>
</body>
</html>
course.jsp 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
     <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.course.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>课程信息</title>
<style type="text/css">
td{
  text-align:center;
}
a{
  text-decoration:none;
}
</style>
</head>
<body>
<center>
<%
CouDao cou=new CouDao();
Course coun=new Course();
ResultSet rs=cou.Query();
%>
<table border="1" width="500" height="500">
<caption>课程信息</caption>
<tr><td>课程号</td><td>课程名</td><td>老师</td><td>学分</td><td colspan="2">数据操作</td></tr>
<% 
while(rs.next()){
%>
<tr>
<td><%=rs.getString("cno") %></td>
<td><%=rs.getString("cname") %></td>
<td><%=rs.getString("cteacher") %></td>
<td><%=rs.getString("ccredit") %></td>
<td><a href="addCourse.jsp?cno=<%=rs.getString("cno")%>&ccredit=<%=rs.getString("ccredit")%>">添加</a></td>
</tr>
<%
} 
%>
</table>
</center>
</body>
</html>

addCourse.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
     <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.course.*" %>
    <%@ page import="nuc.select.Dao.*" %>
    <%@ page import="nuc.select.student.*" %>
    <%@ page import="nuc.select.coon.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
    request.setCharacterEncoding("utf-8");
    String s=request.getParameter("ccredit");
%>
<%!
    int allcredit=0;
%>
<%
    int credit=Integer.parseInt(s);
    allcredit+=credit;
    if(allcredit>15){
    out.println("你已经超过选修学分限制！");
    }else{
CouDao cou=new CouDao();
Course coun=new Course();
coun.setCno(request.getParameter("cno"));
ResultSet rs=cou.Select(coun);
if(rs.next()){
    String Cno=rs.getString("cno");
String Cname=rs.getString("cname");
String Cteacher=rs.getString("cteacher");
String Ccredit=rs.getString("Ccredit");
StuDao stu=new StuDao();
Student stun=new Student();
String st=(String)session.getAttribute("stuno");
stun.setSno(st);
ResultSet rst=stu.Select(stun);
if(rst.next()){
String Sno=rst.getString("sno");
String Sname=rst.getString("sname");
String Scno=rst.getString("scno");
Coon coona=new Coon();
Connection coonn=coona.getCoon();
String sql="insert into sc(scno,sno,cno,sname,cname,cteacher,ccredit) values ('"+Scno+"','"+Sno+"','"+Cno+"','"+Sname+"','"+Cname+"','"+Cteacher+"','"+Ccredit+"')";
try{

PreparedStatement pst=coonn.prepareStatement(sql);
int rt=pst.executeUpdate();
if(rt>0){
out.println("选修成功！");
}else{
out.println("选修失败！");
}

}catch(Exception e){
out.println(e);
}
 }
   }
         }
%>
</body>
</html>

ashowCourse.jsp 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
     <%@ page import="java.sql.*" %>
    <%@ page import="nuc.select.course.*" %>
    <%@ page import="nuc.select.Dao.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>选课结果</title>
<style type="text/css">
td{
  text-align:center;
}
a{
  text-decoration:none;
}
</style>
</head>
<body>
<center>
<%
ScDao sc=new ScDao();
    String st=(String)session.getAttribute("stuno");
    ResultSet rs=sc.selectsno(st);
%>
<table border="1" width="500" height="500">
<caption>选课结果</caption>
<tr><td>班级</td><td>学号</td><td>课程号</td><td>姓名</td><td>课程名</td><td>老师</td><td>学分</td></tr>
<%
    while(rs.next()){
%>
<tr>
<td><%=rs.getString("scno") %></td>
<td><%=rs.getString("sno") %></td>
<td><%=rs.getString("cno") %></td>
<td><%=rs.getString("sname") %></td>
<td><%=rs.getString("cname") %></td>
<td><%=rs.getString("cteacher") %></td>
<td><%=rs.getString("ccredit") %></td>
</tr>
<%
    }
%>
</table>
</center>
</body>
</html>

page里面的类（见下一篇文章）

简单学生选课系统之学生身份登录

标签：

相关文章