1、 style=font-family: 楷体pfont size=10px color=red学生信息信息管理系统/p/marqueetable align=center width=237 table width=100% font size=2div id=b2bContent style=FILTER: revealTrans(Duration = 1, Transition = 23); WIDTH: 100%; HEIGHT: 162px/div/td/trtd align=center STYLE=cursor: handdiv class=b2bbutton id=bt0 onc
2、lick=javascript:showPage(0);clearTimeout(theTimer);theTimer=setTimeout(turnPage(),speed);checkBt();1bt1showPage(1);2bt2showPage(2);3bt3showPage(3);4bt4showPage(4);5bt5showPage(5);6script language=javascript b2bStr = new Array(); b2bStr0= div style=float:left; width:100%;overflow:hidden;a href=1.gif
3、target=_blankimg src=1.gif width=214px height=145px border=0/abra target=_blank title=太阳岛公园一角 href=1.gif太阳岛公园一角img src=2.gif width=214px height=145px border=0a target=_blank title=太阳岛公园湖光山色 href=2.gif太阳岛公园湖光山色img src=3.gif width=214px height=145px border=0a target=_blank title=哈尔滨雪雕 href=3.gif哈尔滨雪雕i
4、mg src=4.gif width=214px height=145px border=0a target=_blank title=镜泊湖 href=4.gif镜泊湖img src=5.gif width=214px height=145px border=0a target=_blank title=太阳岛公园瀑布 href=5.gif太阳岛公园瀑布img src=6.gif width=214px height=145px border=0a target=_blank title=镜泊湖夜色 href=6.gif镜泊湖夜色=6) page=0; function checkBt()
5、for(var i=0;i/TD/TRhr color=green width=540table align=center用户名:input type=text name=username size=8 maxlength=6密 &码:password10submit value=登录 reset取消/form/body/html2.java代码(1)User.Java 定义的属性和数据库中的字段相对应package com.softeem.dt;public class User private int id; private String username; private St
6、ring password; private String xh; private String college; 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 set
7、Password(String password) this.password = password; public String getXh() return xh; public void setXh(String xh) this.xh = xh; public String getCollege() return college; public void setCollege(String college) this.college = college;(2)UserDAO.java 操作数据库tb_user,验证用户登录package com.softeem.dao;import j
8、ava.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import com.softeem.db.DBManager;import com.softeem.dt.User;public class UserDAO /* * 验证用户登录 * return */ public boolean checkDenglu(User user) boolean flag = false; / 获得数据库连接 Connection conn =
9、DBManager.getConnection(); / 用select * from查询数据库中的所有字段 String sql = select count(*) from tb_user where username=? and password=? try PreparedStatement pst = conn.prepareStatement(sql); pst.setString(1, user.getUsername(); pst.setString(2, user.getPassword(); / 执行查询语句,拿到结果集 ResultSet rs = pst.execute
10、Query(); while (rs.next() int count = rs.getInt(1); /用count和0比较,若大于0表示该用户存在,否则不存在 if(count 0) flag = true; catch (SQLException e) e.printStackTrace(); return flag;3.LoginServlet,点击登录跳转到服务器端package com.softeem.servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servl
11、et.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.softeem.dao.UserDAO;import com.softeem.dto.User;/* * Servlet implementation class LoginServletpublic class LoginServlet extends HttpServlet private static final long serialVersio
12、nUID = 1L; * see HttpServlet#HttpServlet() public LoginServlet() super(); * see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException super.doGet(request, respons
13、e); * see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException /获取表单数据 /处理乱码 request.setCharacterEncoding(utf-8); String username = request.getParameter( Strin
14、g password = request.getParameter( /封装到user对象中 User user = new User(); user.setUsername(username); user.setPassword(password); /调用dao的checkLogin方法 UserDAO dao = new UserDAO(); boolean flag = dao.checkLogin(user); String message = null; String path = null; if(flag) message = 登录成功 path=success.jsp request.getSession().setAttribute(user, user); else message =对不起密码错误,请重新输入!fail.jsp /response返回message response.setCharacterEncoding( response.getWriter().write(message);*/ /属于服务器跳转,浏览器地址栏没有发生改变 request.getRequestDispatcher(path).forward(request,response);
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1