📄

📁 清华版的jsp基础程序对新手很有用
💻
📖 第 1 页 / 共 3 页
字号:
          if(englishmin==null)
            {englishmin="0";
            }
    String mathmax=request.getParameter("mathmax");
          if(mathmax==null)
            {mathmax="100";
            }
    String mathmin=request.getParameter("mathmin");
          if(mathmin==null)
            {mathmin="0";
            }
    Connection con=null;
    Statement sql=null;
    ResultSet rs=null;
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
       try
      {    con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
           sql=con.createStatement();
           String eCondition="英语成绩 <= "+englishmax+" AND "+"英语成绩 >= "+englishmin;
           String mCondition="数学成绩 <= "+mathmax+" AND "+"数学成绩 >= "+mathmin;
           String condition="SELECT * FROM students WHERE "+mCondition+" and "+eCondition;
           rs=sql.executeQuery(condition);
       out.print("<Table Border>");
            out.print("<TR>");
            out.print("<TH width=100>"+"学号");
            out.print("<TH width=100>"+"姓名");
            out.print("<TH width=50>"+"数学成绩");
            out.print("<TH width=50>"+"英语成绩");
            out.print("<TH width=50>"+"物理成绩");
            out.print("</TR>");
       while(rs.next())
           { out.print("<TR>");
             out.print("<TD >"+rs.getString(1)+"</TD>"); 
             out.print("<TD >"+rs.getString(2)+"</TD>");
             out.print("<TD >"+rs.getInt("数学成绩")+"</TD>"); 
             out.print("<TD >"+rs.getInt("英语成绩")+"</TD>");
             out.print("<TD >"+rs.getInt("物理成绩")+"</TD>");   
             out.print("</TR>") ;          
            }
       out.print("</Table>");
      con.close();
     }
   catch(SQLException e)
          {}
%>
</BODY>
</HTML>

例子6（效果如图5.19、5.20所示）
Example5_6:
<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<BODY>
<P>查询成绩：
<Font size=1>
<FORM action="byname1.jsp" method=post name=form>
       <INPUT type="radio" name="R" value="姓名">按姓氏排序 
       <INPUT type="radio" name="R" value="数学成绩+英语成绩+物理成绩">按总分排序 
       <INPUT type="radio" name="R" value="英语成绩">按英语排序 
<BR>  <Input type=submit name="g" value="提交">
</Form>
</BODY>
</HTML>

byname1.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
  <% //获取提交的排序方式：
    String name=request.getParameter("R");
          if(name==null)
            {name="";}
     byte b[]=name.getBytes("ISO-8859-1");
     name=new String(b);
    String number,xingming;
    Connection con=null;
    Statement sql=null;
    ResultSet rs=null;
    int math,english,physics;
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
     try { con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
         sql=con.createStatement();
         String condition="SELECT * FROM students ORDER BY "+name;
         rs=sql.executeQuery(condition);
         out.print("<Table Border>");
            out.print("<TR>");
            out.print("<TH width=100>"+"学号");
            out.print("<TH width=100>"+"姓名");
            out.print("<TH width=50>"+"数学成绩");
            out.print("<TH width=50>"+"英语成绩");
            out.print("<TH width=50>"+"物理成绩");
            out.print("<TH width=50>"+"总成绩");
            out.print("</TR>");
           while(rs.next())
             { out.print("<TR>");
               number=rs.getString(1); 
               out.print("<TD >"+number+"</TD>"); 
               xingming=rs.getString(2); 
               out.print("<TD >"+xingming+"</TD>");
               math=rs.getInt("数学成绩"); 
               out.print("<TD >"+math+"</TD>"); 
               english=rs.getInt("英语成绩"); 
               out.print("<TD >"+english+"</TD>");
               physics=rs.getInt("物理成绩"); 
               out.print("<TD >"+physics+"</TD>"); 
               int total=math+english+physics;
               out.print("<TH >"+total+"</TH>"); 
               out.print("</TR>") ; 
              }
         out.print("</Table>");
        con.close();
       }
    catch(SQLException e)
       {  }
 %>
</BODY>
</HTML>

例子7（效果如图5.21所示）
Example5_7.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<BODY>
<P>查询成绩：
<Font size=1>
<P>输入学生的姓氏:
<BR> <FORM action="byname2.jsp" method=post name=form>
       <INPUT type="text" name="name" value="王">
<BR>  <Input type=submit name="g" value="提交">
</Form>
</BODY>
</HTML>

byname2.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
  <% //获取提交的姓氏：
    String name=request.getParameter("name");
          if(name==null)
            {name="";
            }
     byte b[]=name.getBytes("ISO-8859-1");
     name=new String(b);
    String number,xingming;
    Connection con=null;
    Statement sql=null;
    ResultSet rs=null;
    int math,english,physics;
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
       try{ con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
           sql=con.createStatement();
           String condition="SELECT * FROM students" ;
           rs=sql.executeQuery(condition);
       out.print("<Table Border>");
            out.print("<TR>");
            out.print("<TH width=100>"+"学号");
            out.print("<TH width=100>"+"姓名");
            out.print("<TH width=50>"+"数学成绩");
            out.print("<TH width=50>"+"英语成绩");
            out.print("<TH width=50>"+"物理成绩");
            out.print("</TR>");
       while(rs.next())
           { number=rs.getString(1);
             xingming=rs.getString(2);
             if(xingming.startsWith("王"))
               { out.print("<TR>");
                 out.print("<TD >"+number+"</TD>"); 
                 out.print("<TD >"+xingming+"</TD>");
                 math=rs.getInt("数学成绩"); 
                 out.print("<TD >"+math+"</TD>"); 
                 english=rs.getInt("英语成绩"); 
                 out.print("<TD >"+english+"</TD>");
                 physics=rs.getInt("物理成绩"); 
                 out.print("<TD >"+physics+"</TD>"); 
                 out.print("</TR>") ;  
               } 
            }
       out.print("</Table>");
      con.close();
     }
    catch(SQLException e)
     {  }
%>
</BODY>
</HTML>

例子8（效果如图5.22、5.23所示）
Example5_8.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=pink >
<Font size=1>
<FORM action="newResult.jsp" method=post>
输入要修改成绩的同学的姓名：<BR>
<Input type="text" name="name">
<BR>输入新的数学成绩：
<Input type="text" name="math">
<BR>输入新的英语成绩：
<Input type="text" name="english">
<BR>输入新的物理成绩：
<Input type="text" name="physics">
<BR><Input type="submit" name="b" value="提交更新">
<P>数据库更新前的数据记录是：
 <% String name,number;
    int math,physics,english;
    Connection con;
    Statement sql; 
    ResultSet rs;
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       }
    catch(ClassNotFoundException e){}
    try{ con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
         sql=con.createStatement();
         rs=sql.executeQuery("SELECT * FROM students");
         out.print("<Table Border>");
         out.print("<TR>");
            out.print("<TH width=100>"+"学号");
            out.print("<TH width=100>"+"姓名");
            out.print("<TH width=50>"+"数学成绩");
            out.print("<TH width=50>"+"英语成绩");
            out.print("<TH width=50>"+"物理成绩");
         out.print("</TR>");
       while(rs.next())
       { out.print("<TR>");
             number=rs.getString(1); 
             out.print("<TD >"+number+"</TD>"); 
             name=rs.getString(2); 
             out.print("<TD >"+name+"</TD>");
             math=rs.getInt("数学成绩"); 
             out.print("<TD >"+math+"</TD>"); 
             english=rs.getInt("英语成绩"); 
             out.print("<TD >"+english+"</TD>");
             physics=rs.getInt("物理成绩"); 
             out.print("<TD >"+physics+"</TD>");   
        out.print("</TR>") ; 
        }
        out.print("</Table>");
        con.close();
     }
   catch(SQLException e1) {}
 %>
</Font>
</BODY>
</HTML>

newResult.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=pink ><Font size=1>
  <% //获取提交的姓名：
    String name=request.getParameter("name");
          if(name==null)
            {name="";
            }
     byte b[]=name.getBytes("ISO-8859-1");
     name=new String(b);
     //获取提交的新的数学成绩：
    String newMath=request.getParameter("math");
          if(newMath==null)
            {newMath="-100";
            }
    //获取提交的新的英语成绩：
    String newEnglish=request.getParameter("english");
          if(newEnglish==null)
            {newEnglish="-100";
            }
     //获取提交的新的物理成绩：
     String newPhysics=request.getParameter("physics");
          if(newPhysics==null)
            {newPhysics="-100";
            } 
    Connection con=null;
    Statement sql=null;
    ResultSet rs=null;
    String number,xingming;
    int math,english,physics;
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
       try {con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
       sql=con.createStatement();
       String condition1=
              "UPDATE students SET 数学成绩 = "+newMath+" WHERE 姓名="+"'"+name+"'" ,
              condition2=
              "UPDATE students SET 英语成绩 = "+newEnglish+" WHERE 姓名="+"'"+name+"'" ,
              condition3=
              "UPDATE students SET 物理成绩 = "+newPhysics+" WHERE 姓名="+"'"+name+"'" ;
       //执行更新操作：
💿 文件大小 70 K
👤 上传用户 ys0796
📂 所属分类 Internet/网络编程
🏷️ 相关标签

#jsp #清华 #程序
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -