chap4-4.jsp

来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 47 行

JSP
47
字号
<%@ page contentType="text/html;charset=GB2312"  import="java.sql.*"%> 
<jsp:useBean id="querybean" scope="request" class="ch4.QueryBean" /> 
<html>
<head>
	<title>使用Bean操作数据库</title>
</head>
<body bgcolor="#FFFFFF">
<div align="center">
  	<table width="60%" border="1">
		<tr> 
    		<td width="50%" bgcolor="#CCCCFF"> 
      			<div align="center"><font color="#FF0033"><b>学号</b></font></div>
      		</td>
      	    <td width="25%" bgcolor="#CCCCFF"> 
      			<div align="center"><font color="#FF0033"><b>姓名</b></font></div>
      		</td>
		    <td width="25%" bgcolor="#CCCCFF"> 
      			<div align="center"><font color="#FF0033"><b>学分</b></font></div>
      		</td>
    	</tr>
<% 
	querybean.setModify("delete from student where xuehao='200201';"); 
	querybean.setModify("insert into student values('200401','小林',10);"); 
	querybean.setModify("insert into student values('200402','小明',12);"); 
	querybean.setModify("update student set name='蓝猫大哥' where xuehao='200202';"); 
	ResultSet rs=querybean.getQuery("select * from student"); 
	while (rs.next()){ 
%> 
  		<tr> 
		    <td width="50%"> 
     			 <div align="center"><%=rs.getString(1)%></div>
    		</td>
      		<td width="25%"> 
        		<div align="center"><%=rs.getString(2)%></div>
      		</td>
      		<td width="25%"> 
        		<div align="center"><%=rs.getInt(3)%></div>
      		</td>
    	</tr>
<%
	}
	rs.close();
%>
  </table>
</body>
</html>

⌨️ 快捷键说明

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