JSP学生教学管理网站+报告

<!--<% //获取提交的数据： String number=request.getParameter("cname"); if(number==null) { number=""; } byte b[]=number.getBytes("ISO-8859-1"); number=new String(b); Connection con=null; Statement sql=null; ResultSet rs=null; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e){} try { con=DriverManager.getConnection("jdbc:odbc:st","sa",""); sql=con.createStatement(); String condition="SELECT * FROM studentinfo WHERE sno = "+"'"+number+"'"; rs=sql.executeQuery(condition); if (!rs.next()) { response.sendRedirect("index.jsp"); } else { response.sendRedirect("main.jsp"); } con.close(); } catch(SQLException e) { } %>-->