基于javaweb+mysql的jsp+servlet酒店管理系统(java+jsp+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的JSP+Servlet酒店管理系统(java+jsp+mysql)
登录:
admin 123456
public class kefangyuding_servlet extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
if (type.endsWith("kefangyudingMana")) {
kefangyudingMana(req, res);
}
if (type.endsWith("kefangyudingAdd")) {
kefangyudingAdd(req, res);
}
if (type.endsWith("kefangyudingDel")) {
kefangyudingDel(req, res);
}
}
public void kefangyudingAdd(HttpServletRequest req, HttpServletResponse res) {
int kefang_id = Integer.parseInt(req.getParameter("kefang_id"));
String shijian = req.getParameter("shijian");
String kehuname = req.getParameter("kehuname");
String kehutel = req.getParameter("kehutel");
String tianshu = req.getParameter("tianshu");
String del = "no";
String sql = "insert into t_kefangyuding(kefang_id,shijian,kehuname,kehutel,tianshu,del) values(?,?,?,?,?,?)";
Object[] params = { Integer.valueOf(kefang_id), shijian, kehuname, kehutel, tianshu, del };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kefangyuding?type=kefangyudingMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kefangyudingDel(HttpServletRequest req, HttpServletResponse res) {
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void goodsMana(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
List goodsList = new ArrayList();
String sql = "select * from t_goods where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
Goods goods = new Goods();
goods.setId(rs.getInt("id"));
goods.setName1(rs.getString("name1"));
goods.setMiaoshu(rs.getString("miaoshu"));
goods.setPic(rs.getString("pic"));
goods.setJiage(rs.getInt("jiage"));
goodsList.add(goods);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("goodsList", goodsList);
req.getRequestDispatcher("admin/goods/goodsMana.jsp").forward(req, res);
}
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException {
String sql = "update t_kefangleixing set del='yes' where id=" + Integer.parseInt(req.getParameter("id"));
Object[] params = new Object[0];
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kefangleixing?type=kefangleixingMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kefangleixingEdit(HttpServletRequest req, HttpServletResponse res) {
String name = req.getParameter("name");
String beizhu = "";
String del = "no";
String sql = "update t_kefangleixing set name=? where id=" + Integer.parseInt(req.getParameter("id"));
Object[] params = { name };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kefangleixing?type=kefangleixingMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException {
super.init(config);
try
{
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next())
{
TAdmin admin = new TAdmin();
admin.setUserId(rs.getInt("userId"));
admin.setUserName(rs.getString("userName"));
admin.setUserPw(rs.getString("userPw"));
adminList.add(admin);
}
rs.close();
}
catch (Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("adminList", adminList);
req.getRequestDispatcher("admin/admin/adminMana.jsp").forward(req, res);
}
public void adminAdd(HttpServletRequest req, HttpServletResponse res)
{
String userName = req.getParameter("userName");
String userPw = req.getParameter("userPw");
String sql = "insert into t_admin(userName,userPw) values(?,?)";
Object[] params = { userName, userPw };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin?type=adminMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
kehu.setYouxiang(rs.getString("youxiang"));
kehuList.add(kehu);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("kehuList", kehuList);
req.getRequestDispatcher("admin/kehu/kehuMana.jsp").forward(req, res);
}
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
}
public class kefang_servlet extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "canzhuoyuding?type=canzhuoyudingMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void canzhuoyudingMana(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
List canzhuoyudingList = new ArrayList();
String sql = "select * from t_canzhuoyuding where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
Canzhuoyuding canzhuoyuding = new Canzhuoyuding();
canzhuoyuding.setId(rs.getInt("id"));
canzhuoyuding.setShijian(rs.getString("shijian"));
canzhuoyuding.setKehuname(rs.getString("kehuname"));
canzhuoyuding.setZhuohao(rs.getString("zhuohao"));
canzhuoyudingList.add(canzhuoyuding);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("canzhuoyudingList", canzhuoyudingList);
req.getRequestDispatcher("admin/canzhuoyuding/canzhuoyudingMana.jsp").forward(req, res);
}
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
public void goodsAdd(HttpServletRequest req, HttpServletResponse res) {
String name1 = req.getParameter("name1");
String miaoshu = req.getParameter("miaoshu");
String fujian = req.getParameter("fujian");
int jiage = Integer.parseInt(req.getParameter("jiage"));
System.out.println(jiage);
String del = "no";
String sql = "insert into t_goods(name1,miaoshu,pic,jiage,del) values(?,?,?,?,?)";
Object[] params = { name1, miaoshu, fujian, Integer.valueOf(jiage), del };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "goods?type=goodsMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void goodsDel(HttpServletRequest req, HttpServletResponse res) {
int id = Integer.parseInt(req.getParameter("id"));
String sql = "update t_goods set del='yes' where id=?";
Object[] params = { Integer.valueOf(id) };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "goods?type=goodsMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void goodsMana(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
List goodsList = new ArrayList();
String sql = "select * from t_goods where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
}
public class kefang_servlet extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
if (type.endsWith("kefangMana")) {
{
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next())
{
TAdmin admin = new TAdmin();
admin.setUserId(rs.getInt("userId"));
admin.setUserName(rs.getString("userName"));
admin.setUserPw(rs.getString("userPw"));
adminList.add(admin);
}
rs.close();
}
catch (Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("adminList", adminList);
req.getRequestDispatcher("admin/admin/adminMana.jsp").forward(req, res);
}
public void adminAdd(HttpServletRequest req, HttpServletResponse res)
{
String userName = req.getParameter("userName");
String userPw = req.getParameter("userPw");
String sql = "insert into t_admin(userName,userPw) values(?,?)";
Object[] params = { userName, userPw };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin?type=adminMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void adminDel(HttpServletRequest req, HttpServletResponse res)
{
System.out.println(req.getParameter("userId") + "**");
String sql = "delete from t_admin where userId=" + Integer.parseInt(req.getParameter("userId"));
Object[] params = new Object[0];
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
String type = req.getParameter("type");
if (type.endsWith("kefangleixingMana")) {
kefangleixingMana(req, res);
}
if (type.endsWith("kefangleixingAdd")) {
kefangleixingAdd(req, res);
}
if (type.endsWith("kefangleixingDel")) {
kefangleixingDel(req, res);
}
if (type.endsWith("kefangleixingEdit")) {
kefangleixingEdit(req, res);
}
}
public void kefangleixingMana(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
List kefangleixingList = new ArrayList();
String sql = "select * from t_kefangleixing where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
List kefangleixing = new ArrayList();
kefangleixing.add(rs.getString("id"));
kefangleixing.add(rs.getString("name"));
kefangleixing.add(rs.getString("beizhu"));
kefangleixing.add(rs.getString("del"));
kefangleixingList.add(kefangleixing);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("kefangleixingList", kefangleixingList);
req.getRequestDispatcher("admin/kefangleixing/kefangleixingMana.jsp").forward(req, res);
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
if (type.endsWith("kefangleixingMana")) {
kefangleixingMana(req, res);
}
if (type.endsWith("kefangleixingAdd")) {
kefangleixingAdd(req, res);
}
if (type.endsWith("kefangleixingDel")) {
kefangleixingDel(req, res);
}
if (type.endsWith("kefangleixingEdit")) {
kefangleixingEdit(req, res);
}
}
public void kefangleixingMana(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
List kefangleixingList = new ArrayList();
String sql = "select * from t_kefangleixing where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
List kefangleixing = new ArrayList();
kefangleixing.add(rs.getString("id"));
kefangleixing.add(rs.getString("name"));
kefangleixing.add(rs.getString("beizhu"));
kefangleixing.add(rs.getString("del"));
kefangleixingList.add(kefangleixing);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("kefangleixingList", kefangleixingList);
req.getRequestDispatcher("admin/kefangleixing/kefangleixingMana.jsp").forward(req, res);
}
public void kefangleixingAdd(HttpServletRequest req, HttpServletResponse res) {
String name = req.getParameter("name");
String beizhu = "";
String del = "no";
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kehu?type=kehuMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kehuSearch(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
List kehuList = new ArrayList();
String sql = "select * from t_kehu where type='kehu' and del='no' and mingcheng like '%"
+ req.getParameter("mingcheng").trim() + "%'";
System.out.println(sql);
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
kehu kehu = new kehu();
kehu.setId(rs.getInt("id"));
kehu.setMingcheng(rs.getString("mingcheng"));
kehu.setDizhi(rs.getString("dizhi"));
kehu.setLianxiren(rs.getString("lianxiren"));
kehu.setDianhua(rs.getString("dianhua"));
kehu.setYoubian(rs.getString("youbian"));
kehu.setChuanzhen(rs.getString("chuanzhen"));
kehu.setYouxiang(rs.getString("youxiang"));
kehuList.add(kehu);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("kehuList", kehuList);
req.getRequestDispatcher("admin/kehu/kehuMana.jsp").forward(req, res);
}
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
public class goods_servlet extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
if (type.endsWith("goodsAdd")) {
goodsAdd(req, res);
}
if (type.endsWith("goodsMana")) {
goodsMana(req, res);
}
if (type.endsWith("goodsDel")) {
goodsDel(req, res);
}
}
public void goodsAdd(HttpServletRequest req, HttpServletResponse res) {
String name1 = req.getParameter("name1");
String miaoshu = req.getParameter("miaoshu");
String fujian = req.getParameter("fujian");
int jiage = Integer.parseInt(req.getParameter("jiage"));
System.out.println(jiage);
String del = "no";
String sql = "insert into t_goods(name1,miaoshu,pic,jiage,del) values(?,?,?,?,?)";
Object[] params = { name1, miaoshu, fujian, Integer.valueOf(jiage), del };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "goods?type=goodsMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void goodsDel(HttpServletRequest req, HttpServletResponse res) {
int id = Integer.parseInt(req.getParameter("id"));
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("canzhuoyudingList", canzhuoyudingList);
req.getRequestDispatcher("admin/canzhuoyuding/canzhuoyudingMana.jsp").forward(req, res);
}
public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try {
dispatch.forward(request, response);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
}
}
if (type.endsWith("kefangleixingAdd")) {
kefangleixingAdd(req, res);
}
if (type.endsWith("kefangleixingDel")) {
kefangleixingDel(req, res);
}
if (type.endsWith("kefangleixingEdit")) {
kefangleixingEdit(req, res);
}
}
public void kefangleixingMana(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
List kefangleixingList = new ArrayList();
String sql = "select * from t_kefangleixing where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
List kefangleixing = new ArrayList();
kefangleixing.add(rs.getString("id"));
kefangleixing.add(rs.getString("name"));
kefangleixing.add(rs.getString("beizhu"));
kefangleixing.add(rs.getString("del"));
kefangleixingList.add(kefangleixing);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
mydb.closed();
req.setAttribute("kefangleixingList", kefangleixingList);
req.getRequestDispatcher("admin/kefangleixing/kefangleixingMana.jsp").forward(req, res);
}
public void kefangleixingAdd(HttpServletRequest req, HttpServletResponse res) {
int kefang_id = Integer.parseInt(req.getParameter("kefang_id"));
String shijian = req.getParameter("shijian");
String kehuname = req.getParameter("kehuname");
String kehutel = req.getParameter("kehutel");
String tianshu = req.getParameter("tianshu");
String del = "no";
String sql = "insert into t_kefangyuding(kefang_id,shijian,kehuname,kehutel,tianshu,del) values(?,?,?,?,?,?)";
Object[] params = { Integer.valueOf(kefang_id), shijian, kehuname, kehutel, tianshu, del };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kefangyuding?type=kefangyudingMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kefangyudingDel(HttpServletRequest req, HttpServletResponse res) {
String sql = "update t_kefangyuding set del='yes' where id=" + Integer.parseInt(req.getParameter("id"));
Object[] params = new Object[0];
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kefangyuding?type=kefangyudingMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kefangyudingMana(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
List kefangyudingList = new ArrayList();
String sql = "select * from t_kefangyuding where del='no'";
Object[] params = new Object[0];
DB mydb = new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs = mydb.getRs();
while (rs.next()) {
Kefangyuding kefangyuding = new Kefangyuding();
kefangyuding.setId(rs.getInt("id"));
kefangyuding.setKefang_id(rs.getInt("kefang_id"));
kefangyuding.setShijian(rs.getString("shijian"));
kefangyuding.setKehuname(rs.getString("kehuname"));
kefangyuding.setKehutel(rs.getString("kehutel"));
kefangyuding.setTianshu(rs.getString("tianshu"));
public void destroy() {
}
}
public class kefangruzhu_servlet extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
if (type.endsWith("kefangruzhuMana")) {
kefangruzhuMana(req, res);
}
if (type.endsWith("kefangruzhuAdd")) {
kefangruzhuAdd(req, res);
}
if (type.endsWith("kefangruzhuDel")) {
kefangruzhuDel(req, res);
}
}
public void kefangruzhuAdd(HttpServletRequest req, HttpServletResponse res) {
int kefang_id = Integer.parseInt(req.getParameter("kefang_id"));
String shijian = req.getParameter("shijian");
String kehuname = req.getParameter("kehuname");
String kehutel = req.getParameter("kehutel");
String tianshu = req.getParameter("tianshu");
String xiaofeijine = req.getParameter("xiaofeijine");
String del = "no";
String sql = "insert into t_kefangruzhu(kefang_id,shijian,kehuname,kehutel,tianshu,xiaofeijine,del) values(?,?,?,?,?,?,?)";
Object[] params = { Integer.valueOf(kefang_id), shijian, kehuname, kehutel, tianshu, xiaofeijine, del };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kefangruzhu?type=kefangruzhuMana");
public class kehu_servlet extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
String type = req.getParameter("type");
if (type.endsWith("kehuAdd")) {
kehuAdd(req, res);
}
if (type.endsWith("kehuMana")) {
kehuMana(req, res);
}
if (type.endsWith("kehuDel")) {
kehuDel(req, res);
}
if (type.endsWith("kehuEdit")) {
kehuEdit(req, res);
}
if (type.endsWith("kehuSearch")) {
kehuSearch(req, res);
}
if (type.endsWith("kehuXinxi")) {
kehuXinxi(req, res);
}
}
public void kehuAdd(HttpServletRequest req, HttpServletResponse res) {
String mingcheng = req.getParameter("mingcheng");
String dizhi = req.getParameter("dizhi");
String lianxiren = req.getParameter("lianxiren");
String dianhua = req.getParameter("dianhua");
String youbian = req.getParameter("youbian");
String chuanzhen = req.getParameter("chuanzhen");
String youxiang = req.getParameter("youxiang");
String sql = "insert into t_kehu(mingcheng,dizhi,lianxiren,dianhua,youbian,chuanzhen,youxiang,kahuhang,zhanghao,type,del) values(?,?,?,?,?,?,?,?,?,?,?)";
Object[] params = { mingcheng, dizhi, lianxiren, dianhua, youbian, chuanzhen, youxiang, "", "", "kehu", "no" };
DB mydb = new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kehu?type=kehuMana");