📄 ex7_9.txt

📁 企业培训过程中的记录,希望对找工作的朋友帮助.

💻 TXT

字号:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY bgcolor=pink >
<FONT size=3> 
  
   <ForM action="delete.jsp" method=post>
      输入将被删除的记录的学号:
      <Input type="text" name="number">
      <BR>
      <BR><Input type="submit" name="b" value="删除记录">
   </FORM>

   <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:grade","","");
           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(3);
                out.print("<TD>"+math+"</TD>");

                english=rs.getInt(4);
                out.print("<TD>"+english+"</TD>");

                physics=rs.getInt(5);
                out.print("<TD>"+physics+"</TD>");

                out.print("</TR>");
              }
           out.print("</Table>");
           con.close();
        }
     catch(SQLException el)
        {}

  %>
  
</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -