别忘了导入 mysql 两个jar包
经 JDBC 设计完毕后
在用户名 root 密码 123456 的用户
创建 database2数据库
建表 tbl_user_info
在DAO层添加函数:
public boolean selectByNameAPwd(UserVO user ){
//加载
try {
//连接
Connection conn = DBUtil.connectDB();
//预执行
String sql="select * from tbl_user_info where username=? and password=?";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
//执行
ResultSet rs = ps.executeQuery();
boolean r;
if(rs.next()){
r=true;//登录成功,查询到信息
}else{
r=false;
}
//释放
rs.close();
ps.close();
conn.close();
return r;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}
写servlet (使用注解)
LoginServlet.java
package com.imooc.jdbc;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;
import com.imooc.jdbc.UserDao;
@WebServlet(name="loginServlet",urlPatterns={"/loginServlet"}) //注解名和post的标签名相同
public class LoginServlet extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
response.setContentType("text/html);charset=UTF-8");
String user = request.getParameter("user");
String pwd = request.getParameter("pwd");
UserVO u=new UserVO();
u.setUsername(user);
u.setPassword(pwd);
boolean r=new UserDao().selectByNameAPwd(u);//调用dao层
//页面跳转
if(r){
//response.sendRedirect("main.html");
System.out.println("Welcome "+user+" password "+pwd);
}else{
//response.sendRedirect("login.html");
System.out.println("Wrong username or password");
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
写 login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登录</title>
<form action="loginServlet" method="post">
<table >
<tr>
<td>用户名:</td>
<td > <input type="text" name="user"></td>
</tr>
<td>密码:</td>
<td > <input type="password" name="pwd"></td>
</tr>
<tr>
<td><input type="submit" value="提交"/> </td>
<td><input type="reset" value="重置"/> </td>
</tr>
</table>
</form>
</head>
</html>