jsp+Mysql实现简单用户登陆
登陆界面：login.jsp
<%@page contentType="text/html" pageEncoding="gbk"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>登陆</title>
</head>
<body>
<center>
<form name="form1" method="post" action="conf.jsp">
<h1>用户登录</h1>
<p>用户名：
<input type="text" name="name">
</p>
<p>用户密码：
<input type="password" name="password">
</p>
<p>
<input type="submit" name="Submit" value="登陆">
<input type="reset" name="Submit2" value="重置">
</p>
</form>
</center>
</body>
</html>
登录验证界面：conf.jsp
<%@page import ="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import ="java.util.*"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/tf";
String user = "root";
String password = "123";
conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String name = request.getParameter("name");
byte b[] = name.getBytes("ISO-8859-1");
name = new String(b);
String password2 = request.getParameter("password");
String strSQL = "select * from member where name='" + name + "' and password='" + password2 + "'";
ResultSet rs = stmt.executeQuery(strSQL);
int count = 0;
while (rs.next()) {
count++;
}
if (count > 0) {
%>
<jsp:forward page="chenggong.jsp"></jsp:forward>
<%} else {
%>
<jsp:forward page="shibai.jsp"></jsp:forward>
<% }
%>
更多相关文章
- CentOS下MySQL的安装和修改用户密码
- App在自己界面奔溃回到首页，状态栏沉浸式消失bug
- Android原生Contacts——界面和数据库
- Android项目实战--手机卫士01--启动界面
- android 输入法界面显示的开关
- 问题记录-Activity跳转后显示空白界面
- DroidDraw---Android的界面设计工具
- Android界面的.9.png图片显示出错，怎么回事啊？
- Android 实现多页界面左右滑动切换效果之进阶