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 block
e.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 block
e.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 block
e.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 block
e.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 block
e.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 block
e.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 block
e.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>