JSP奖学金评定系统

1

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>奖学金</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
 background-color: #3399FF;
}
-->
</style></head>
<body>
<div align="center">
<%
String id=(String)session.getValue("id");
if(id==null||id==""){
out.print("您还没有登录!");
}else{
%>
<%!
Connection con=null;
Statement sql=null;
ResultSet rs=null;
%>
<%
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM chengji");
ResultSetMetaData mdrs=rs.getMetaData();
String ss;
out.print("<table width='100%'>");
out.print("<tr>");
for(int i=1;i<=mdrs.getColumnCount();i++){
if(rs.findColumn("学号")==i||rs.findColumn("姓名")==i||rs.findColumn("年级")==i||rs.findColumn("专业")==i||rs.findColumn("平时成绩")==i){
out.print("<td>"+mdrs.getColumnName(i)+"</td>");
}
}
out.print("<td>"+"修改"+"</td>");
out.print("</tr>");
while (rs.next()){
ss=rs.getString("学号");
out.print("<tr>");
out.print("<td>"+ss+"</td>");
for(int i=1;i<=mdrs.getColumnCount();i++){
if(rs.findColumn("姓名")==i||rs.findColumn("专业")==i||rs.findColumn("年级")==i||rs.findColumn("平时成绩")==i){

if(mdrs.getColumnType(i)==7){
out.print("<td>"+rs.getFloat(i)+"</td>");
}
else if(mdrs.getColumnType(i)==1||mdrs.getColumnType(i)==12){
out.print("<td>"+rs.getString(i)+"</td>");
}
}
}
%>

<td><a href="131.jsp?dd=<%=ss%>">修改</a></td>
<%
out.print("</tr>");

}//while 结束
out.print("</table>");
}catch(SQLException e2){}
}
%>
</div>
</body>
</html>

2

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>奖学金</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
 background-color: #3399FF;
}
-->
</style></head>
<body>
<div align="center">
<%
String id=(String)session.getValue("id");
if(id==null||id==""){
out.print("您还没有登录!");
}else{
%>
<%!
int d=0;
int c=0;
int f=0,k=0,g=0,j=0;
double e=0;
String a;
String s1[]=new String[500];
String s2[]=new String[500];
Connection con=null;
Statement sql=null;
ResultSet rs=null;
%>

  <%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e1){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM zhuanye");
while(rs.next()){
f++;
s1[f]=rs.getString("专业");
}
}catch(SQLException e2){}
%>
  <%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e1){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM nianji");
while(rs.next()){
g++;
s2[g]=rs.getString("年级");
}
}catch(SQLException e9){}
%>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e1){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM chengji");
ResultSetMetaData mdrs1=rs.getMetaData();
out.print("<table width=80% border=0>");
out.print("<tr>");
for(int i=1;i<=mdrs1.getColumnCount();i++){
if(rs.findColumn("备注")!=i){
if(rs.findColumn("专业")!=i){
if(rs.findColumn("年级")!=i){
out.print("<td>"+mdrs1.getColumnName(i)+"</td>");
}}}}

out.print("<td>"+"几等奖金"+"</td>");
out.print("</tr>");
}catch(SQLException e2){}

%>
 
  <%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e1){}
for(j=1;j<=g;j++){
for(k=1;k<=f;k++){
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs=sql.executeQuery("SELECT * FROM chengji WHERE 专业="+"'"+s1[k]+"'"+"AND 年级="+"'"+s2[j]+"'"+"ORDER BY 总分 Desc ");
ResultSetMetaData mdrs=rs.getMetaData();
while (rs.next()){
c++;
}//while 结束
d=c;//得到数据库中某一个系的人数
c=0;
}catch(SQLException e2){}


try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM chengji WHERE 专业="+"'"+s1[k]+"'"+"AND 年级="+"'"+s2[j]+"'"+"ORDER BY 总分 Desc ");
ResultSetMetaData mdrs=rs.getMetaData();
float ss[]=new float[mdrs.getColumnCount()];

e=d*0.15;
c=0;
out.print("<td>");
out.print("<table width='100%'>");
out.print("<td width='100%'>"+s2[j]+s1[k]+"</td>");
out.print("</table>");
out.print("</td>");
qq:while (rs.next()&&c<=e){

for(int i=1;i<=mdrs.getColumnCount();i++){

if(mdrs.getColumnType(i)==7 && rs.findColumn("平时成绩")!=i){
ss[i]=rs.getFloat(i);
if(ss[i]<60){
c++;
continue qq;
}
}
}
out.print("<tr>");
for(int i=1;i<=mdrs.getColumnCount();i++){
if(rs.findColumn("备注")!=i){
if(rs.findColumn("专业")!=i){
if(rs.findColumn("年级")!=i){
if(mdrs.getColumnType(i)==7 && rs.findColumn("平时成绩")!=i){
out.print("<td>"+ss[i]+"</td>");
}else if(mdrs.getColumnType(i)==7 && rs.findColumn("平时成绩")==i){
out.print("<td>"+rs.getFloat(i)+"</td>");
}
else if(mdrs.getColumnType(i)==1||mdrs.getColumnType(i)==12){
out.print("<td>"+rs.getString(i)+"</td>");
}else if(mdrs.getColumnType(i)==8){
out.print("<td>"+rs.getFloat(i)+"</td>");
}else if(mdrs.getColumnType(i)==-1){
out.print("<td>"+rs.getString(i)+"</td>");
}}
}}}
if(c<=d*0.04){
out.print("<td>"+"一等奖学金"+"</td>");
}else if(c<=d*0.1){
out.print("<td>"+"二等奖学金"+"</td>");
}else {
out.print("<td>"+"三等奖学金"+"</td>");
}
out.print("</tr>");
c++;
}//while 结束
}catch(SQLException e2){}
d=0;
c=0;
}}
g=0;
j=0;
f=0;
k=0;
%> <%}
%>
</div>
</body>
</html>

3

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>修改平时成绩</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
 background-color: #3399FF;
}
-->
</style></head>
<body>
<%
String id=(String)session.getValue("id");
if(id==null||id==""){
out.print("您还没有登录!");
}else{
String ss=request.getParameter("dd");
%>
<form name="form1" method="post" action="141.jsp?dd=<%=ss%>">
  <table width="100%" border="0">
    <tr>
      <td width="44%"><div align="center">修改平时成绩</div>
          <label> </label>
        <div align="center"></div></td>  
    <tr>
      <td><label> </label>
        <div align="center"></div></td>
      <td>请输入平时成绩: </td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <div align="center">请输入数字或小数点例如:22.22,否则将会出错</div>
      </div></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <input type="text" name="textfield2">
      </div></td>
    </tr>
    <tr>
      <td colspan="2"><label> </label>
          <div align="center">
            <label></label>
          平时成绩备注</div></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <input type="text" name="textfield3">
      </div></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <input type="submit" name="Submit" value="提交">
      </div></td>
    </tr>
  </table>
</form>
<%}
%>

 

</body>
</html>

4

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
 background-color: #3399FF;
}
-->
</style></head>
<body>
<%
String id=(String)session.getValue("id");
if(id==null||id==""){
out.print("您还没有登录!");
}else{
String ss=request.getParameter("dd");
if (ss==null)
ss="";
byte b[]=ss.getBytes("ISO-8859-1");
%>
<%!
Connection con=null;
Statement sql=null;
ResultSet rs=null;
String s1,s2,s3;
%>
<%
s2=request.getParameter("textfield2");
if(s2==null)
s2="";
byte b2[]=s2.getBytes("ISO-8859-1");
s2=new String(b2);
s3=request.getParameter("textfield3");
if(s3==null)
s3="";
byte b3[]=s3.getBytes("ISO-8859-1");
s3=new String(b3);

float f=new Float(s2).floatValue();
out.print("修改成功!");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载桥接器驱动程序
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");//连接数据库
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);//定义查询数据库的方式,可滚动查询并且是可更新数据库
rs=sql.executeQuery("SELECT * FROM chengji WHERE 学号="+"'"+ss+"'");//选择要查询的表
ResultSetMetaData rsmd=rs.getMetaData();//利用ResultSet对象的getMetaData得到ResultSetMetaData的对象,用来描述及其解释数据含义。
while(rs.next()){
rs.updateFloat("平时成绩",f);
rs.updateString("备注",s3);
rs.updateRow();
}
}catch(Exception e){}
}
%>

</body>
</html>

5

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>学生成绩</title>
</head>
<body>
<table width="800" height="600" border="0" align="center">
<tr>
<td align="left">
<div align="center">
<%
String id=(String)session.getValue("id");
if(id==null||id==""){
out.print("您还没有登录!");
}else{
%>
<%!
int c=0;//辅助a[]数组变量获得值
double a[]=new double[100];//存放除"总分"、“平时成绩”外的所有数值字段的和,然后更新“总分”字段
Connection con=null;
Statement sql=null;
ResultSet rs=null;
%>

<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e1){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=sql.executeQuery("SELECT * FROM chengji");
ResultSetMetaData mdrs=rs.getMetaData();


//查询开始
while (rs.next()){
out.println(mdrs.getColumnType(6));
//得到除"总分","平时成绩"字段外的所有数值型字段
for (int i=1;i<=mdrs.getColumnCount();i++){
if(rs.findColumn("平时成绩")!=i){
if(mdrs.getColumnType(i)==7){
if(rs.findColumn("总分")!=i){
a[c]=a[c]+rs.getFloat(i);
}
}
}
}

//更新总分字段
a[c]=a[c]*0.7+rs.getFloat("平时成绩")*0.3;
rs.updateDouble("总分",a[c]);
rs.updateRow();

//输出字段值

c++;
}//while结束
}catch(SQLException e2){}
%>
<jsp:forward page="17.jsp"/>
<%}%>
</td> 
</tr>
</table>
</body>
</html>

 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值