更新时间2018-06-21 17:50:51
java写的用户登录实例,实际页面展示使用的jsp,那么下面是jsp的登录页面代码:1、login.jsp代码<% string name = request.getparameter("username"); string pwd = request.getparameter("password"); //out.println(name+pwd); string sql ="select * from info where username='"+name+"' and password='"+pwd+"'"; //out.println(sql); statement stm= null; resultset rs =null; try { stm = conn.createstatement(); rs = stm.executequery(sql); if(rs.next()) { session.setattribute("username",name); response.sendredirect("index.html"); } else { response.sendredirect("index1.html"); } } catch(sqlexception e) { e.printstacktrace(); }%><!--登录的表单--><form name="form1" method="post" action="login.jsp">
<label for="username"></label> 用户名 <input type="text" name="username" id="username">
<label for="passwrod"></label> 密码 <input type="text" name="passwrod" id="passwrod">
<input type="submit" name="button" id="button" value="提交">
</form>2、用户信息表,存放用户名和密码:user_info 表create table if not exists `test` ( `id` int(8) not null auto_increment, `username` char(150) default null, `password` varchar(32), `times` int(4) not null, primary key (`id`)) engine=myisam default charset=utf8 auto_increment=1 ;