title: servlet登录页面提交数据，从数据库核对练习 date: 2015-12-25 16:24:07 categories: servlet tags: servlet
xl_echo编辑整理，欢迎转载，转载请声明文章来源。更多案例、资料请联系QQ：1280023003
servlet练习，登录
通过servlet获取登录页面的用户名，用户密码实现登录，如果数据库中有该用户名和用户密码，则返回登录成功，如果没有则返回登录失败
目录结构： - java Resources - src - DBUtils
BeanUtils.java C3P0_Utils.java 链接数据库 - Service Control_Service.java 调用Dao层，对数据库进行查询 - Servlet Servlet_Login.java 接收表单提交的参数 封装到BeanUtils中 调用业务层Service业务层处理数据 根据处理的结果显示信息（页面跳转） - Servlet_Dao Servlet_Login_Dao.java 从数据库中进行查询 - WebContent - Login_Html index.html：表单页面（登录页面）
- WEB-INF
> web.xml：配置文件
BeanUtils
package DBUtils;
import java.io.Serializable;
public class BeanUtils implements Serializable{
private static final long serialVersionUID = -
4057850299304233093L;
private String id;
private String uname;
private String gender;
private String score;
private String address;
private String password;
public String
getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String
getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String
getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String
getScore() {
return score;
}
public void setScore(String score) {
this.score = score;
}
public String
getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String
getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String
toString() {
return "BeanUtils [id=" + id +
", uname=" + uname +
", gender=" + gender +
", score=" + score +
", address="
+ address +
", password=" + password +
"]";
}
}
C3P0_Utils
package DBUtils;
import java.sql.Connection;
import java.sql.SQLException;
import org.junit.Test;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class C3P0_Utils {
@Test
public Connection
getConnection(){
Connection conn =
null;
ComboPooledDataSource DATA_SORUCE =
new ComboPooledDataSource();
try {
conn = DATA_SORUCE.getConnection();
}
catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
Control_Service
package Service;
import java.sql.SQLException;
import DBUtils.BeanUtils;
import Servlet_Dao.Servlet_Login_Dao;
public class Control_Service {
public BeanUtils
Login(BeanUtils bu)
throws SQLException {
Servlet_Login_Dao s =
new Servlet_Login_Dao();
BeanUtils b = s.Login_Dao(bu);
return b;
}
}
Servlet_Login
package Servlet;
import java.io.IOException;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import DBUtils.BeanUtils;
import Service.Control_Service;
/**
* Servlet implementation class Servlet_Login
*/
public class Servlet_Login extends HttpServlet {
private static final long serialVersionUID =
1L;
public Servlet_Login() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String name = request.getParameter(
"name");
String password = request.getParameter(
"password");
BeanUtils bu =
new BeanUtils();
bu.setUname(name);
bu.setPassword(password);
Control_Service cs =
new Control_Service();
BeanUtils b =
null;
try {
b = cs.Login(bu);
}
catch (SQLException e) {
e.printStackTrace();
}
response.getCharacterEncoding();
if(b ==
null){
response.getWriter().println(
"Login-load-fail");
}
else{
response.getWriter().println(
"Login-success");
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
Servlet_Login_Dao
package Servlet_Dao;
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import DBUtils.BeanUtils;
import DBUtils.C3P0_Utils;
public class Servlet_Login_Dao {
public BeanUtils
Login_Dao(BeanUtils bu)
throws SQLException {
Connection conn =
null;
C3P0_Utils c =
new C3P0_Utils();
conn = c.getConnection();
System.out.println(conn);
QueryRunner qr =
new QueryRunner();
String sql =
"select * from newtable where uname = ? and password = ?";
System.out.println(bu);
String password = bu.getPassword();
int a = Integer.parseInt(password);
System.out.println(a);
BeanUtils b = qr.query(conn, sql,
new BeanHandler<BeanUtils>(BeanUtils.class),bu.getUname(),a);
conn.close();
System.out.println(b);
return b;
}
}
c3p0-config
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver
</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/myxlsorry
</property>
<property name="user">root
</property>
<property name="password">password
</property>
</default-config>
</c3p0-config>
index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>注册页面
</title>
<script>
function tips(id,content){
var temp = document.getElementById(id).value;
if(temp == ""){
document.getElementById(id + "Span").innerHTML = "<font color='purple'>"+content+"</font>";
}else{
document.getElementById(id + "Span").innerHTML = "<font color='purple'></font>";
}
}
function buttonSubmit(){
var username = document.getElementById("username").value;
if(username == ""){
document.getElementById("usernameSpan").innerHTML = "<font color='purple'>用户名不能为空</font>";
return false;
}
var password = document.getElementById("password").value;
if(password == ""){
document.getElementById("passwordSpan").innerHTML = "<font color='purple'>密码不能为空</font>";
return false;
}
var password = document.getElementById("password").value;
var rePassword = document.getElementById("rePassword").value;
if(password != rePassword){
document.getElementById("rePasswordSpan").innerHTML = "<font color='purple'>两个密码不一致</font>";
return false;
}
}
var arrs = new Array(4);
arrs[0] = new Array("北京","广州","深圳","上海","湛江");
arrs[1] = new Array("华盛顿","纽约","洛杉矶","西雅图","费城");
arrs[2] = new Array("莫斯科","海参崴","列宁格勒","北京","北京");
arrs[3] = new Array("伦敦","伯明翰","英国","不列颠","斯里兰卡");
function getCity(){
var opEl = document.getElementById("selectValue").value;
var REopEl = document.getElementById("REselectValue");
for(var i=REopEl.options.length;i>0;i--){
REopEl.options[i] = null;
}
opEl = opEl - 1;
for(var i=0; i<arrs[opEl].length; i++){
var CreateOption = document.createElement("option");
var CreadteNode = document.createTextNode(arrs[opEl][i]);
CreateOption.appendChild(CreadteNode);
var REselectValue = document.getElementById("REselectValue");
REselectValue.appendChild(CreateOption);
}
}
</script>
</head>
<body>
<div style="width: 90%; border: 5px solid purple; height: 800px;">
<br />
<br />
<br />
<h1>欢迎新用户注册
</h1>
<br />
<div style="width: 500px; height: 400px; border: 5px solid purple;">
<br />
<br />
<form action="/Day67/Servlet_Login" method="post" onsubmit="return buttonSubmit()">
用户名 ：
<input id="username" type="text" name="name" onfocus="tips('username','用户名需要以字母或_开头')" onblur=""/><span id="usernameSpan"></span>
<br />
<br />
密 码：
<input id="password" type="text" name="password" onfocus="tips('password','密码至少为六位')"/><span id="passwordSpan"></span>
<br />
<br />
确认密码：
<input id="rePassword" type="text" name="确认密码"/><span id="rePasswordSpan"></span>
<br />
<br />
性 别：
<input type="radio" name="sex" value="man"/>man
<input type="radio" name="sex" value="woman"/>woman
<br />
<br />
籍 贯：
<select id="selectValue" name="selectName" onchange="getCity()">
<option value="0">
--请选择--
</option>
<option value="1">
中国
</option>
<option value="2">
美国
</option>
<option value="3">
俄罗斯
</option>
<option value="4">
英国
</option>
</select>
<select id="REselectValue" name="selectName">
<option>
--请选择--
</option>
</select>
<br />
<br />
爱 好：
<input type="checkbox" name="hobby" value="跆拳道"/>跆拳道
<input type="checkbox" name="hobby" value="柔道"/>柔道
<input type="checkbox" name="hobby" value="散打"/>散打
<br />
<br />
Email：
<input type="text" />
<br />
<br />
<input type="submit" name="提交" value="提交"/>
</form>
</div>
</div>
</body>
</html>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>Day67
</display-name>
<welcome-file-list>
<welcome-file>index.html
</welcome-file>
<welcome-file>index.htm
</welcome-file>
<welcome-file>index.jsp
</welcome-file>
<welcome-file>default.html
</welcome-file>
<welcome-file>default.htm
</welcome-file>
<welcome-file>default.jsp
</welcome-file>
</welcome-file-list>
<servlet>
<description></description>
<display-name>Servlet_Login
</display-name>
<servlet-name>Servlet_Login
</servlet-name>
<servlet-class>Servlet.Servlet_Login
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Servlet_Login
</servlet-name>
<url-pattern>/Servlet_Login
</url-pattern>
</servlet-mapping>
</web-app>
