package com
.yyq
.dao;
import com
.yyq
.entity
.Admin;
import com
.yyq
.util
.DBInstance;
import com
.yyq
.util
.DBUtil;
import com
.yyq
.util
.PageUtil;
import java
.sql
.SQLException;
import java
.util
.ArrayList;
import java
.util
.List;
import java
.util
.Map;
/**
* @Author 写你的名字
* @Date 2025/9/24 上午11
:53 （可以根据需要修改）
* @Version 1
.0 （版本号）
*/
public
class AdminDao {
private DBUtil dbUtil ;
public AdminDao
() {
this
.dbUtil = DBInstance
.getDbUtil
();
}
public int addAdmin
(Admin admin
){
String sql = "insert into admin
(account,password,tel,nickName,icon,createtime,delflag
) values
(?,?,?,?,?,?,?
)";
Object[] params = {
admin
.getAccount
(),
admin
.getPassword
(),
admin
.getTel
(),
admin
.getNickName
(),
admin
.getIcon
(),
admin
.getCreatetime
(),
admin
.getDelflag
()
};
int row = 0;
try {
row = dbUtil
.executeUpdate
(sql, params
);
} catch
(SQLException e
) {
throw new RuntimeException
(e
);
} catch
(ClassNotFoundException e
) {
throw new RuntimeException
(e
);
}
return row;
}
//登录验证
public Admin login
(String account,String password
) {
//delflag是啥
String sql = "select * from admin where account = ? and password = ? and delflag = '0'";
Object[] params = {account,password};
List<Admin> admins = null;
try {
admins = dbUtil
.executeQuery
(sql, params, Admin
.class);
admins
.forEach
(System
.out
::println
);
return admins
.size
()>0 ? admins
.get
(0
) : null;
} catch
(SQLException e
) {
throw new RuntimeException
("登录查询失败",e
);
}
}
public List<Admin> adminList
(Map<String,Object> map
){
String sql = "select admin
.* from admin where delflag = '0'";
List<Object> params = new ArrayList<>
();
if
(map
.get
("nickName"
)!=null&& !map
.get
("nickName"
).toString
().isEmpty
()){
sql += "where nickName like concat
('%',?,'%'
)";
params
.add
(map
.get
("nickName"
));
}
sql+="limit ?,?";
System
.out
.println
(sql
);
map = PageUtil
.formatPage
(map
);
params
.add
(map
.get
("pageIndex"
));
params
.add
(map
.get
("pageSize"
));
List<Admin> adminList = null;
try {
adminList = dbUtil
.executeQuery
(sql,params
.toArray
(),Admin
.class);
} catch
(SQLException e
) {
throw new RuntimeException
("查询执行错误",e
);
}
return adminList;
}
public int pageCount
(int pageSize
){
String sql = "select ceil
(count
(*
) /?
) pageCount from admin where delflag='0'";
Object[] params = {pageSize};
List<Admin> list = null;
try {
list = dbUtil
.executeQuery
(sql, params, Admin
.class);
} catch
(SQLException e
) {
throw new RuntimeException
("分页功能失败",e
);
}
return list
.get
(0
).getPageCount
();
}
//根据name查询管理员
public Admin getAdminByName
(String nickName
){
String sql = "select * from admin where nickName = ?";
Object[] params ={nickName};
try {
List<Admin> adminList = dbUtil
.executeQuery
(sql, params, Admin
.class);
return adminList
.size
()>0? adminList
.get
(0
):null;
} catch
(SQLException e
) {
throw new RuntimeException
("查询管理员失败",e
);
}
}
//更新管理员信息
public int updateAdmin
(Admin admin
) {
String sql = "update admin set account =? ,password = ?,tel = ?,nickName=?,icon=? where adminId=?";
Object[] params = {
admin
.getAccount
(),
admin
.getPassword
(),
admin
.getTel
(),
admin
.getNickName
(),
admin
.getIcon
(),
admin
.getAdminId
()
};
try {
return dbUtil
.executeUpdate
(sql, params
);
} catch
(SQLException e
) {
throw new RuntimeException
(e
);
} catch
(ClassNotFoundException e
) {
throw new RuntimeException
("更新管理员失败", e
);
}
}
public int deleteAdmin
(int adminId
){
String sql = "uodate admin set delflag ='1' where adminId=? ";
Object[] params = {adminId};
try {
return dbUtil
.executeUpdate
(sql,params
);
} catch
(SQLException e
) {
throw new RuntimeException
(e
);
} catch
(ClassNotFoundException e
) {
throw new RuntimeException
("删除管理员失败",e
);
}
}
}
HTTP状态 500 - 内部服务器错误
类型 异常报告
消息 执行查询失败
描述 服务器遇到一个意外的情况，阻止它完成请求。
例外情况
java
.lang
.RuntimeException
: 执行查询失败
com
.yyq
.util
.DBUtil
.executeQuery
(DBUtil
.java
:89
)
com
.yyq
.dao
.AdminDao
.login
(AdminDao
.java
:54
)
com
.yyq
.servlet
.AdminServlet
.doPost
(AdminServlet
.java
:44
)
jakarta
.servlet
.http
.HttpServlet
.service
(HttpServlet
.java
:590
)
jakarta
.servlet
.http
.HttpServlet
.service
(HttpServlet
.java
:658
)
org
.apache
.tomcat
.websocket
.server
.WsFilter
.doFilter
(WsFilter
.java
:51
)
根本原因。
java
.lang
.ClassNotFoundException
: com
.mysql.cj
.jdbc
.Driver
org
.apache
.catalina
.loader
.Webapp
ClassLoaderBase
.load
Class(Webapp
ClassLoaderBase
.java
:1380
)
org
.apache
.catalina
.loader
.Webapp
ClassLoaderBase
.load
Class(Webapp
ClassLoaderBase
.java
:1189
)
java
.base/java
.lang
.Class.forName0
(Native Method
)
java
.base/java
.lang
.Class.forName(Class.java
:375
)
com
.yyq
.util
.DBUtil
.getConnection
(DBUtil
.java
:44
)
com
.yyq
.util
.DBUtil
.executeQuery
(DBUtil
.java
:66
)
com
.yyq
.dao
.AdminDao
.login
(AdminDao
.java
:54
)
com
.yyq
.servlet
.AdminServlet
.doPost
(AdminServlet
.java
:44
)
jakarta
.servlet
.http
.HttpServlet
.service
(HttpServlet
.java
:590
)
jakarta
.servlet
.http
.HttpServlet
.service
(HttpServlet
.java
:658
)
org
.apache
.tomcat
.websocket
.server
.WsFilter
.doFilter
(WsFilter
.java
:51
)
):注意 主要
问题的全部 stack 信息可以在 server logs 里查看
Apache Tomcat/10
.1
.42
本文详细介绍了在JSP应用中遇到的mysql数据库连接问题，主要原因是Class.forName(DBDRIVER)调用失败，通常是因为数据库连接的jar包未正确放置在项目路径中或Tomcat的lib目录下。
扫一扫
2896
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
