Jsp/Servlet

开发平台：

VBScript

searchscore.jsp~28~：源码内容

							<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<HTML>
  <head><SCRIPT language="JavaScript">
function a() {
	if(form1.keywords.value==""){
		alert("用户名不能为空，请确定后重新输入");
		form1.keywords.focus();
		return false;
	}
	return true;
}</script>
</head>
  <BODY  background="img/main_5.jpg"><br>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
	out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");
String str = request.getParameter("keywords");
if( str == null)
	str = "";
      else
try{
	conn=DriverManager.getConnection("jdbc:odbc:dsn112");
	stmt=conn.createStatement();
       	rs=stmt.executeQuery("SELECT * FROM stu001 WHERE stu_id LIKE '%" + str + "%'");
        out.print("<table  width='100%' cellspacing='0' cellpadding='4' rules='all' bordercolor='#CC9966' border='1' id='dg_rxkb' style='background-color:White;border-color:#CC9966;border-width:1px;border-style:None;width:99%;border-collapse:collapse;'>");
         out.print("<tr bgcolor='EcEcff' align='center'><TD>学期号</TD>");
      		out.print("<TD>课程号</TD>");
		out.print("<TD>课程名</TD>");
                out.print("<TD>学分</TD>");
                out.print("<TD>成绩</TD>");
                out.print("<TD>重修成绩</TD>");
      		out.print("<TD>主讲老师</TD></TR>");
	while(rs.next()){
		out.print("<tr align='center'><TD>"+rs.getString("xq_id")+"</TD>");
		out.print("<TD>"+rs.getString("co_id")+"</TD>");
		out.print("<TD>"+rs.getString("co_name")+"</TD>");
		out.print("<TD>"+rs.getString("credit_hour")+"</TD>");
                out.print("<TD>"+rs.getString("cj")+"</TD>");
                 out.print("<TD>"+rs.getString("cxcj")+"</TD>");
		out.print("<TD>"+rs.getString("teacher")+"</TD></TR>");
	}
	out.print("</TABLE>");
}
catch(SQLException e){
	System.out.println(e.getMessage());
}
finally{
	stmt.close();
	conn.close();
}
%>
 <FORM name="form1" Action="" Method="POST">
<table  width="100%" cellspacing="0" cellpadding="4" rules="all" bordercolor="#CC9966" border="1" id="dg_rxkb" style="background-color:White;border-color:#CC9966;border-width:1px;border-style:None;width:99%;border-collapse:collapse;">
<tr >
      <td bgcolor="#EcEcff" height="40" colspan="2"><div align="center" ><strong>查找成绩</strong></font></div></td>
    </tr>
<tr ><td>请输入你的学号：</td>
<td><INPUT Type="Text" Name="keywords" Value="<%=str%>"></td></tr>
<tr ><td  height="35" colspan="2"><div align="center"><INPUT Type=Submit Value=" 查找" onClick="return a()" ></td></tr></table>
</FORM>
</BODY></HTML>

						