简单学生选课系统之多种方式查询
来源:互联网 发布:魔法王麒麟臂升阶数据 编辑:程序博客网 时间:2024/05/22 00:23
allquery.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></head><body><center><form action="cnameshow.jsp" method="post">课程名查询<input type="text" name="cnames" value=""><input type="submit" value="查询"></form><br><form action="cnoshow.jsp" method="post">课程号查询<input type="text" name="cnos" value=""><input type="submit" value="查询"></form><br><form action="scnoshow.jsp" method="post">班级查询<input type="text" name="scnos" value=""><input type="submit" value="查询"></form><br><form action="snoshow.jsp" method="post">学号查询<input type="text" name="snos" value=""><input type="submit" value="查询"></form><br><form action="snameshow.jsp" method="post">姓名查询<input type="text" name="snames" value=""><input type="submit" value="查询"></form></center></body></html>
ScDao.java
package nuc.select.Dao;import java.sql.*;import nuc.select.coon.Coon;public class ScDao { public ResultSet selectsno(String student){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select * from sc where sno=?"; try {PreparedStatement pst=coonn.prepareStatement(sql);pst.setString(1,student);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; } public ResultSet selectsname(String student){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select * from sc where sname=?"; try {PreparedStatement pst=coonn.prepareStatement(sql);pst.setString(1,student);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; } public ResultSet selectscno(String student){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select * from sc where scno=?"; try {PreparedStatement pst=coonn.prepareStatement(sql);pst.setString(1,student);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; } public ResultSet selectcname(String student){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select * from sc where cname=?"; try {PreparedStatement pst=coonn.prepareStatement(sql);pst.setString(1,student);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; } public ResultSet selectcno(String student){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select * from sc where cno=?"; try {PreparedStatement pst=coonn.prepareStatement(sql);pst.setString(1,student);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; } public ResultSet selectall(){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select * from sc"; try {PreparedStatement pst=coonn.prepareStatement(sql);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; } public ResultSet selectcredit(){ ResultSet rst=null; Coon coona=new Coon(); Connection coonn=coona.getCoon(); String sql="select scno,sno,sname from sc group by sno having sum(ccredit)<15"; try {PreparedStatement pst=coonn.prepareStatement(sql);rst=pst.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} return rst; }}
cnameshow.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.*" %><!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;}</style></head><body><% request.setCharacterEncoding("utf-8");ScDao sc=new ScDao(); String course=request.getParameter("cnames"); ResultSet rs=sc.selectcname(course); if(rs!=null){%><center><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><% } }else{ out.println("抱歉,没有你所要查询的信息!"); }%></table></center></body></html>
cnoshow.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.*" %><!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;}</style></head><body><% request.setCharacterEncoding("utf-8");ScDao sc=new ScDao(); String student=request.getParameter("cnos"); ResultSet rs=sc.selectcno(student); if(rs!=null){%><center><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><% } }else{ out.println("抱歉,没有你所要查询的信息!"); }%></table></center></body></html>
<%@ 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.*" %><!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></head><body><% request.setCharacterEncoding("utf-8");ScDao sc=new ScDao(); String student=request.getParameter("scnos"); ResultSet rs=sc.selectscno(student); if(rs!=null){%><center><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><% } }else{ out.println("抱歉,没有你所要查询的信息!"); }%></table></center></body></html>
snameshow.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.*" %><!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;}</style></head><body><% request.setCharacterEncoding("utf-8");ScDao sc=new ScDao(); String student=request.getParameter("snames"); ResultSet rs=sc.selectsname(student); if(rs!=null){%><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><% } }else{ out.println("抱歉,没有你所要查询的信息!"); }%></table></body></html>
snoshow.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.*" %><!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;}</style></head><body><%ScDao sc=new ScDao(); String student=request.getParameter("snos"); ResultSet rs=sc.selectsno(student); if(rs!=null){%><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><% } }else{ out.println("抱歉,没有你所要查询的信息!"); }%></table></body></html>
阅读全文
0 0
- 简单学生选课系统之多种方式查询
- 简单学生选课系统之登录界面
- 简单学生选课系统之课程基本信息
- 简单学生选课系统之学分汇总
- 简单学生选课系统之学生身份登录
- 简单学生选课系统之功能描述和分析
- 数据库设计之学生选课系统
- 数据库设计之学生选课系统
- 模拟学生选课系统
- 学生选课数据管理系统
- 学生选课系统
- 学生选课系统
- 学生选课系统设计
- MFC学生选课系统
- 学生选课系统
- 数据库 简单查询 Sql Server 学生表 课程表 选课表
- 常见经典关系模式及查询之学生选课模式
- 求学生选课系统代码~~~
- Java的package
- 《effective c++》笔记一
- HDU 1885 Key Task 状态压缩+BFS
- 【Nginx】在Centos 7 系统下安装Nginx
- Redis使用详细教程
- 简单学生选课系统之多种方式查询
- atomikos实现多数据源支持分布式事务管理
- C#——语言基础——数组——用冒泡法对10个整数进行从大到小排序
- HDU-2033 人见人爱A+B
- EL和JSTL
- ResNet —— 深度残差网
- SylixOS的NAT工具使用方法
- Kotlin学习过程 二 Kotlin基础语法
- 二分搜索(java)