Servlet實(shí)現(xiàn)簡(jiǎn)單的用戶登錄功能實(shí)例代碼
1、創(chuàng)建html界面
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form action="" method="post"> 用戶名:<input type="text" name="username"> <br> 密碼:<input type="password" name="password"><br> <input type="submit" value="登錄"> </form> </body> </html>
2 、創(chuàng)建數(shù)據(jù)庫(kù)
CREATE TABLE USER( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(32) UNIQUE NOT NULL, PASSWORD VARCHAR(32) NOT NULL );
3、創(chuàng)建用戶實(shí)體類
public class User {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
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;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
4、創(chuàng)建jdbc工具類
這里使用的是c3p0 / druid 兩種數(shù)據(jù)庫(kù)連接池技術(shù) 分別需要在項(xiàng)目導(dǎo)入相應(yīng)的jar包
public class JDBCUtils {
private static DataSource ds ;
static {
try {
//1.加載配置文件
Properties pro = new Properties();
//使用ClassLoader加載配置文件,獲取字節(jié)輸入流
InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
pro.load(is);
//2.初始化連接池對(duì)象
ds = DruidDataSourceFactory.createDataSource(pro);
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 獲取連接池對(duì)象
*/
public static DataSource getDataSource(){
return ds;
}
/**
* 獲取連接Connection對(duì)象
*/
public static Connection getConnection() throws SQLException {
return ds.getConnection();
}
system.out.println("=============================================================")
public class JDBCButil {
final static ComboPooledDataSource comboPooledDataSource = new ComboPooledDataSource();
// 獲取連接方法
// 返回一個(gè)連接對(duì)象
public static Connection getCon() {
// 連接使用c3p0進(jìn)行獲取
// 使用c3p0數(shù)據(jù)庫(kù)連接池獲取連接
Connection connection = null;
try {
connection = comboPooledDataSource.getConnection();
} catch (SQLException e) {
System.err.println("獲取連接失敗");
return null;
}
return connection;
}
// DML方法
// 不支持事務(wù) 單條sql語(yǔ)句執(zhí)行
public static boolean DML(String sql, Object... o) {
// 獲取連接
Connection con = getCon();
// 創(chuàng)建預(yù)編譯對(duì)象
try {
PreparedStatement ps = con.prepareStatement(sql);
for (int i = 0; i < o.length; i++) {
ps.setObject((i + 1), o[i]);
}
ps.executeUpdate();
} catch (SQLException e) {
System.out.println("查詢執(zhí)行失敗:" + sql);
return false;
}
return true;
}
// DML方法
// 支持事務(wù) 多條sql語(yǔ)句執(zhí)行
public static boolean DML(Connection con, String sql, Object... o) {
// 創(chuàng)建預(yù)編譯對(duì)象
try {
PreparedStatement ps = con.prepareStatement(sql);
for (int i = 0; i < o.length; i++) {
ps.setObject((i + 1), o[i]);
}
ps.executeUpdate();
} catch (SQLException e) {
System.out.println("查詢執(zhí)行失敗:" + sql);
return false;
}
return true;
}
// 查詢dql語(yǔ)句方法
public static <E> ArrayList<E> DQL(String sql, Class<E> c, Object... o) {
ArrayList<E> list = new ArrayList<>();
try {
// 獲取連接
Connection con = getCon();
// 準(zhǔn)備預(yù)編譯對(duì)象
PreparedStatement ps = con.prepareStatement(sql);
// 獲取元數(shù)據(jù) 準(zhǔn)備存儲(chǔ)所有列名的數(shù)組
ResultSetMetaData metaData = ps.getMetaData();
// 創(chuàng)建指定長(zhǎng)度用于存儲(chǔ)列名的數(shù)組
String[] names = new String[metaData.getColumnCount()];
// 循環(huán)為names數(shù)組進(jìn)行賦值
for (int i = 0; i < names.length; i++) {
names[i] = metaData.getColumnLabel(i + 1);// 獲取指定列名
}
for (int i = 0; i < o.length; i++) {
ps.setObject(i+1, o[i]);
}
// 執(zhí)行sql返回結(jié)果集
ResultSet rs = ps.executeQuery();
while (rs.next()) {
// 每一行數(shù)據(jù)就是一個(gè)對(duì)象
// 使用反射創(chuàng)建對(duì)象
E obj = c.newInstance();
// 當(dāng)前行所有列名 在names數(shù)組中存儲(chǔ)
// 循環(huán)names數(shù)組取出當(dāng)前行對(duì)應(yīng)數(shù)據(jù)
for (String colname : names) {
Object value = rs.getObject(colname);// 獲取列名對(duì)應(yīng)值
// 將值存入相應(yīng)對(duì)象
// 使用反射獲取類中同名的屬性對(duì)象
Field field = c.getDeclaredField(colname);
// 私有屬性使用前必須賦權(quán)
field.setAccessible(true);
// 調(diào)用屬性對(duì)象的set方法為指定對(duì)象進(jìn)行賦值
field.set(obj, value);
}
// 列名循環(huán)結(jié)束后對(duì)應(yīng)對(duì)象屬性已經(jīng)全部進(jìn)行賦值
// 將對(duì)象存儲(chǔ)至集合中
list.add(obj);
}
} catch (Exception e) {
e.printStackTrace();
return null;
}
return list;
}
}ublic class JDBCUtils {
private static DataSource ds ;
static {
try {
//1.加載配置文件
Properties pro = new Properties();
//使用ClassLoader加載配置文件,獲取字節(jié)輸入流
InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
pro.load(is);
//2.初始化連接池對(duì)象
ds = DruidDataSourceFactory.createDataSource(pro);
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 獲取連接池對(duì)象
*/
public static DataSource getDataSource(){
return ds;
}
5、創(chuàng)建提供登錄方法的userdao
public class UserDao {
//聲明JDBCTemplate對(duì)象共用
private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
/**
* 登錄方法
* @param loginUser 只有用戶名和密碼
* @return user包含用戶全部數(shù)據(jù),沒(méi)有查詢到,返回null
*/
public User login(User loginUser){
try {
//1.編寫sql
String sql = "select * from user where username = ? and password = ?";
//2.調(diào)用query方法
User user = template.queryForObject(sql,
new BeanPropertyRowMapper<User>(User.class),
loginUser.getUsername(), loginUser.getPassword());
return user;
} catch (DataAccessException e) {
e.printStackTrace();
return null;
}
}
}
6、編寫登錄的servlet
@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//1.設(shè)置編碼
req.setCharacterEncoding("utf-8");
//2.獲取請(qǐng)求參數(shù)
String username = req.getParameter("username");
String password = req.getParameter("password");
//3.封裝user對(duì)象
User loginUser = new User();
loginUser.setUsername(username);
loginUser.setPassword(password);
//4.調(diào)用UserDao的login方法
UserDao dao = new UserDao();
User user = dao.login(loginUser);
//5.判斷user
if(user == null){
//登錄失敗
req.getRequestDispatcher("/failServlet").forward(req,resp);
}else{
//登錄成功
//存儲(chǔ)數(shù)據(jù)
req.setAttribute("user",user);
//轉(zhuǎn)發(fā)
req.getRequestDispatcher("/successServlet").forward(req,resp);
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doGet(req,resp);
}
}
7、 編寫FailServlet和SuccessServlet類
public class SuccessServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//獲取request域中共享的user對(duì)象
User user = (User) request.getAttribute("user");
if(user != null){
//給頁(yè)面寫一句話
//設(shè)置編碼
response.setContentType("text/html;charset=utf-8");
//輸出
response.getWriter().write("登錄成功!"+user.getUsername()+",歡迎您");
}
}
@WebServlet("/failServlet")
public class FailServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//給頁(yè)面寫一句話
//設(shè)置編碼
response.setContentType("text/html;charset=utf-8");
//輸出
response.getWriter().write("登錄失敗,用戶名或密碼錯(cuò)誤");
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request,response);
}
}
到此這篇關(guān)于Servlet實(shí)現(xiàn)簡(jiǎn)單的用戶登錄功能的文章就介紹到這了,更多相關(guān)Servlet實(shí)現(xiàn)用戶登錄功能內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
SpringBoot使用Kaptcha實(shí)現(xiàn)驗(yàn)證碼的生成與驗(yàn)證功能
這篇文章主要介紹了SpringBoot使用Kaptcha實(shí)現(xiàn)驗(yàn)證碼的生成與驗(yàn)證功能,本文通過(guò)實(shí)例代碼給大家介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值,需要的朋友可以參考下2023-03-03
servlet異步請(qǐng)求的實(shí)現(xiàn)
本文主要介紹了servlet異步請(qǐng)求的實(shí)現(xiàn),文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2022-07-07
ElasticSearch如何設(shè)置某個(gè)字段不分詞淺析
最近在學(xué)習(xí)ElasticSearch官方文檔過(guò)程中發(fā)現(xiàn)的某個(gè)問(wèn)題,記錄一下 希望能幫助到后面的朋友,下面這篇文章主要給大家介紹了關(guān)于ElasticSearch如何設(shè)置某個(gè)字段不分詞的相關(guān)資料,需要的朋友可以參考下2022-04-04

