login.jsp

来自「本源码」· JSP 代码 · 共 75 行

JSP
75
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	background-image: url(picture/background.JPG);
}
-->
</style>
</head>

<body>

<table width="215" border="1" align="center">
  <tr>
    <td width="215" height="100">&nbsp;</td>
  </tr>
  <tr>
    <td width="215" height="200" background="picture/register_return_215_230_2.gif"><p>
      <%

	String username1;
	String password1;%>
        <%
	username1=request.getParameter("username");
	password1=request.getParameter("password");
	try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	String url="jdbc:odbc:lazy";
	String user="sa";
	String password="111";
	ResultSet rs=null;
	boolean key=true;
	Connection con=DriverManager.getConnection(url,user,password);
	Statement stmt=con.createStatement();
	String condition="SELECT * FROM yl_register WHERE username='"+username1+"'and password='"+password1+"'";
	rs=stmt.executeQuery(condition);
	
	
	if(rs.next()){
		out.println(" 登陆成功,页面正在跳转");%>
      
   </p>
      <p>   
        <%out.println("     请稍等~~~");%>
        <%	session.setAttribute("loginname",username1);%>
      </p>
      <meta http-equiv="Refresh" content="3;URL=main.jsp" />
	<%
	}else{
		out.println("  用户名或密码错误!!");
		stmt.close();
		con.close();%>
		<meta http-equiv="refresh" content="3;URL=index.htm" />
	<%}

	}
	catch(Exception e){
		System.err.println("LMYL ERROR!!"+e.getMessage());
	}



%></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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