guanliyuanerror.jsp

WEB图书馆系统,jsp编写,适用用于JSP的初始者

<%@page contentType="text/html; charset=gbk"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%
//数据库连接
String url="jdbc:odbc:xuesheng";
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
  Connection con=DriverManager.getConnection(url);
  Statement stmt=con.createStatement();
  ResultSet result=stmt.executeQuery("select * from xinxi_study");
  ResultSetMetaData resultmd=result.getMetaData();
%>

<%
	String text1=(String)session.getAttribute("uid1");
	String text2=(String)session.getAttribute("uid2");
	

	String sql="select guanliyuan_id,guanliyuan_mima from xinxi_guanliyuan where guanliyuan_id = '"+text1+"' and guanliyuan_mima = '"+text2+"'";
 
	ResultSet result1=stmt.executeQuery(sql);
	out.println(sql);
	if (result1.next())
       {
       out.println( result1.getString ("guanliyuan_mima") );
       out.println(text2);

 

	response.sendRedirect("frameguanli.jsp");

      }	else {
	response.sendRedirect("errorwindow.jsp");
      }

stmt.close();
con.close();
 
%>