把jsp文件,改为javabean再在jsp中调用bean,可是这个jsp怎么改正好呢?这个jsp已经测试通过的。谢谢
<%@ page contentType="text/html; charset=iso8859_1" language="java" import="java.sql.*,java.util.*,org.gjt.mm.mysql.Driver,llx.*" %>
<HTML><HEAD><TITLE>NEUQ Network Center JSP程序设计</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso8859_1">
<head>
<title>补考学生名单</title>
</head>
<body>
<hr>
<%
String id1=request.getParameter("xuenian");
String id2=request.getParameter("xueqi");
if(id1==null){
id1="";
}
if(id2==null){
id2="";
}
Connection con=null;
Statement st=null;
ResultSet rs=null;
String query="select XSCJB.XH,XSJBXXB.XM,KCLB.KCMC from XSJBXXB,XSCJB,KCLB where XSCJB.XH=XSJBXXB.XH and XSCJB.KCH=KCLB.KCH and (XSCJB.FSLKSCJ<60 OR XSCJB.DJLKSCJ='1') and XN='"+id1+"' and XQM='"+id2+"'";
try{
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/NEUQXSGLK","root","");
st=con.createStatement();
rs=st.executeQuery(query);
if(rs.next()){
%>
<P align="center">学号:
<%=rs.getString("XH")%> 姓名:
<%=rs.getString("XM")%> 课程名称:
<%=rs.getString("KCMC")%>
</P>
<%
}else{
%>
<P align="center">此记录不存在!
</P>
<%
}
}catch(Exception e){
System.out.println("error in catch!!");
e.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
}
if(st!=null){
st.close();
}
if(con!=null){
con.close();
}
}catch(Exception e){
System.out.println("error in finally!!");
e.printStackTrace();
}
}
%></hr>
<P>
<input type="button" id="reset" name="reset" value="返回" onClick="javascript:history.go(-1)">
</P>
</body>
</html>