📄 huiyuan.jsp

📁 网上花店销售系统

💻 JSP

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -