<%@page contentType="text/html;charset=gb2312" pageEncoding="gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<center><h3>会员登录窗口</h3><br /></center>
<form action="logchecking.jsp" method="POST">
<center> <P>姓名：<input type="text" size="20" name="username"></P></center>
<center><P>密码：<input type="password" SIZE="20" name="PWD"></P></center>
<center><P><input type="submit" value="登录">
<input type="button" value="注册" onclick="window.location='demo4.jsp';" /> </center>
</p>
</form>
</body>
</html>
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="GBK"%>
<%
request.setCharacterEncoding("gbk");
String name=request.getParameter("username");//获取登录页面输入的数据
String pwd=request.getParameter("PWD");
//System.out.println("
用户名="+name);
//System.out.println("密码="+pwd);
//连接数据库
String driverClass="com.mysql.jdbc.Driver";//mysql驱动和url
String url="jdbc:mysql://localhost:3306/living"; //living为数据库名
//Connection conn = null ;
//PreparedStatement pstmt= null ;
//mysql用户连接的密码和用户名
String user="root";
String password="313154131";
Class.forName(driverClass);
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from 新表 where name='"+name+"' and pswd='"+pwd+"'"; //
sql语句 System.out.println(sql);
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{%>
<h1><%=request.getParameter("username")%>恭喜您，登录成功!<br/>
<%}
else{
%>
<h1>用户名或密码错误！！！</h1>
<%
}
%>