huiyuan.jsp

来自「网上花店销售系统」· JSP 代码 · 共 66 行

JSP
66
字号
<BODY bgcolor="ffdcdc" >
<div align="center">
  <%@ page contentType="text/html; charset=gb2312" %>
  <%@page import="java.sql.*"%>
  <%!
	String admin_name;
	String admin_pass;
	String admin_name1;
	String admin_pass1;
	
%>
  <%
	admin_name=request.getParameter("admin_name");
	admin_pass=request.getParameter("admin_pass");
	
	String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String ConnStr="jdbc:odbc:zhuce";
	String sql="select * from admin where admin_name like ";
	try	
		{
			Class.forName(DBDriver);
		}
	catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("database:"+e.getMessage());
			out.println("加载驱动失败!");
		}
	try
		{
			Connection conn=DriverManager.getConnection(ConnStr," "," ");
			ResultSet rs;
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sql+"'"+admin_name+"'");

	while(rs.next())
			{
				admin_name1=rs.getString(1);
				admin_pass1=rs.getString(2);
				
				//out.print("<tr>"+"<td>"+username2+"<td>"+password2+"<td>"+sex+"+"</tr>");
		}
			rs.close();
			stmt.close();
			conn.close();
		}
	catch(SQLException e)
		{
			System.err.println("executeQuery:"+e.getMessage());
			out.println("读出数据失败!");
		}
%>
  <%
	if(admin_name.equals(admin_name1) && admin_pass.equals(admin_pass1))
	  { response.sendRedirect("guanliyuan.htm");}
		
	else
	   out.println("<p>"+"密码输入错误,登录失败!"+"<p>"+"请重新登录");
	   response.setHeader("Refresh","6;URL=index.htm");
%>
</div>
<p><a href="huiyuan.htm">返回登录页</a></p>



</BODY>
</HTML>

⌨️ 快捷键说明

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