📄 showstudent.jsp

📁 机械工业出版社的《jsp2.0动态网站开发实例指南》的源代码

💻 JSP

字号:

<!--showstudent.jsp-->
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>Show Student Score</title>
</head>
<body bgcolor=#C0C0C0>
<center>
	<h1>成绩表</hr>
	<%
	try{
	  	int id;
	  	String name;
	  	int math;
	  	int chinese;
	  	int english;
	  	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	  	
	  	Connection con=DriverManager.getConnection("jdbc:odbc:student","","");
	  	
	     	Statement sql=con.createStatement();
	     	
	      	ResultSet rs=sql.executeQuery("SELECT * FROM student ");
	      	
	      	int rowcount=0;
	      	%>
	      	<table width="500" >
		<tr>
		<td ><table border="1" width="500">
		<td width="100" valign="middle" align="center">学号</td>
		<td width="100" valign="middle" align="center">姓名</td>
		<td width="100" valign="middle" align="center">数学成绩</td>
		<td width="100" valign="middle" align="center">语文成绩</td>
		<td width="100" valign="middle" align="center">外语成绩</td>
		</table></td>
		</tr>
		<%
		while(rs.next()){
			rowcount++;
			id=rs.getInt(1);
			name=rs.getString(2);
			math=rs.getInt(3);
			chinese=rs.getInt(4);
			english=rs.getInt(5);
			%>
			<tr>
			<td><table  border="1" width="500">
			<td width="100" valign="middle" align="center"><%=id%></td>
			<td width="100" valign="middle" align="center"><%=name%></td>
			<td width="100" valign="middle" align="center"><%=math%></td>
			<td width="100" valign="middle" align="center"><%=chinese%></td>
			<td width="100" valign="middle" align="center"><%=english%></td>
			</table></td>
			</tr>
			<%
		}
		con.close();
      	}
      	catch(SQLException e){
      		out.println("SQL error!"+e);
      	}
      	catch(ClassNotFoundException e){
		out.println("CNF error!"+e);
  	}
	%>
</center>
<body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -