再<servlet>标签里写
package b_login;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class UserServlet
*/
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try{
//1.接收表单提交的参数
String username=request.getParameter("username");
String password=request.getParameter("password");
//2.封装到实体对象中
User user =new User();
user.setUsername(username);
user.setPassword(password);
//3.调用业务层处理数据
UserService userService= new UserService();
User existUser=userService.login(user);
//4.根据处理结果显示信息
if(existUser==null){
response.getWriter().println("fail");
}else{
response.getWriter().println("sucess");
}
}catch(Exception e){
e.printStackTrace();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
package b_login;
import org.apache.commons.dbutils.ResultSetHandler;
public class User {
String username;
String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
package b_login;
import java.sql.SQLException;
public class UserService {
//业务层用户登陆的方法
public User login(User user) throws SQLException {
// 调用DAO完成对数据库的查询操作:
UserDao userDao=new UserDao();
return userDao.login(user);
}
}
package b_login;
import java.sql.SQLException;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import utils.JDBCUtils;
public class UserDao {
//用户登录的DAO的方法:
public User login(User user) throws SQLException {
// TODO Auto-generated method stub
QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where username=? and password=?";
User existUser=qr.query(sql, new BeanHandler<User>(User.class),user.getUsername(),user.getPassword());
return existUser;
}
//用户登录的DAO的方法:
public User login(User user) throws SQLException {
// TODO Auto-generated method stub
QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from user where username=? and password=?";
User existUser=qr.query(sql, new BeanHandler<User>(User.class),user.getUsername(),user.getPassword());
return existUser;
}
}
package utils;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.mysql.jdbc.Statement;
public class JDBCUtils {
private static final ComboPooledDataSource datasource=new ComboPooledDataSource();
public static Connection getConnection(){
Connection conn=null;
try {
conn=datasource.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static DataSource getDataSource() {
return datasource;
}
}
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/day09/UserServlet" method="post">
用户名<input type="text" id="username" name="username" >
密码<input type="password" id="password" name="password">
<input type="submit" value="提交"></form>
</body>
</html>