很简单的一个demo,记录一下自己第一次做Javaweb遇到的小问题们
一、案例简介
1.需求分析
1.编写login.html登录页面,username & password 两个输入框
2.使用Druid数据库连接池技术,操作mysql数据库中user表
3.使用JdbcTemplate技术封装JDBC
4.登录成功跳转到SuccessServlet展示:登录成功!用户名,欢迎您
5.登录失败跳转到FailServlet展示:登录失败,用户名或密码错误
2.准备工作
- druid.properties配置文件如下:
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///login
username=root
password=root
initialSize=5
maxActive=10
maxWait=3000
-
创建一个table user,存储相应的数据
二、代码
1.login.html
只有两个输入框和一个提交键,很简陋,仅供测试
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<body>
<form action="/loginServlet" method="get">
用户名<input type="text" name="username"><br>
密码<input type="text" name="password"><br>
<input type="submit" value="登录">
</form>
</body>
</html>
2.JDBCUtils.java
JDBC工具类,用于获取数据源,连接数据库
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
public class JDBCUtils {
private static DataSource ds;
//初始化数据库连接池
static{
Properties pro=new Properties();
InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
try {
pro.load(is);
ds = DruidDataSourceFactory.createDataSource(pro);
} catch (IOException e) {
throw new RuntimeException(e);
} catch (Exception e) {
throw new RuntimeException(e);
}
}
//获取数据库连接池
public static DataSource getDs() {
return ds;
}
public static Connection getConnection() throws SQLException {
return ds.getConnection();
}
}
3.UserDao.java
用于进行数据库的增删改查操作
public class UserDao {
private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDs());
public User login(User loginUser){
String sql="select * from user where username = ? and password = ?";
try{
User user = template.queryForObject(sql,
new BeanPropertyRowMapper<User>(User.class),
loginUser.getUsername(),loginUser.getPassword());
return user;
}catch(DataAccessException e){
e.printStackTrace();
return null;
}
}
}
4.loginServlet.java
login.html中表单提交的地址,获取浏览器中输入的username和password后,封装为一个User对象loginUser
调用UserDao类中的函数login,传入loginUser,查询数据库中是否有对应的username和password,如果有则封装为一个User对象返回,没有则返回null
根据返回值进行请求转发,null则转进failServlet进行提示,否则successServlet
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/loginServlet")
public class loginServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doGet(req,resp);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
String username=req.getParameter("username");
String password=req.getParameter("password");
User loginUser=new User();
loginUser.setUsername(username);
loginUser.setPassword(password);
UserDao dao=new UserDao();
User user=dao.login(loginUser);
if(user==null){
req.getRequestDispatcher("/failServlet").forward(req,resp);
}
else{
req.getRequestDispatcher("/successServlet").forward(req,resp);
}
}
}
5.successServlet.java
在网页上提示登陆成功+用户名
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/successServlet")
public class successServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
System.out.println("登陆成功....");
String username=req.getParameter("username");
resp.setContentType("text/html;charset=utf-8");
resp.getWriter().write("登陆成功,欢迎您"+username);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doGet(req,resp);
}
}
6.failServlet.java
在网页上提示登录失败
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/failServlet")
public class failServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/html;charset=utf-8");
resp.getWriter().write("登陆失败,用户名或密码错误");
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doGet(req,resp);
}
}
三、问题和解决
1.读取不到流
配置文件druid.properties一定要放在resources文件夹下,否则读取不到,绝对路径也不行
2.404NotFound
html表单中的action忘记修改,正确写法是虚拟目录+Servlet的资源路径
HTTP Status 404 – Not Found
Type Status Report
Message /demo/loginServlet
Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.
3.HTTP Status 500 – Internal Server Error
java.lang.ClassNotFoundException: org.springframework.dao.DataAccessException
解决方法:在WEB-INF下新建一个lib目录,把jar包放进lib并add as library
HTTP Status 500 – Internal Server Error
Type Exception Report
Message Servlet execution threw an exception
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
javax.servlet.ServletException: Servlet execution threw an exception
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause
java.lang.NoClassDefFoundError: org/springframework/dao/DataAccessException
com.example.demo.loginServlet.doGet(loginServlet.java:26)
javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause
java.lang.ClassNotFoundException: org.springframework.dao.DataAccessException
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1308)
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1136)
com.example.demo.loginServlet.doGet(loginServlet.java:26)
javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Note The full stack trace of the root cause is available in the server logs.