JavaTask学习手册.docxVIP

一、登录界面输入wanggang（账号），411912（密码）后，点击登录。（1）登录表单代码form id=form1 name=form1 method=post action=/JavaTask/servlet/LoginServletinput type=hidden name=method value=login / table id=tab border=0 cellpadding=3 cellspacing=4 tr td 用户名：/td td label input name=username type=text id=username size=30 / /label/td /tr tr td密码：/td tdlabel input name=password type=password id=password size=30 / /label/td /tr tr td align=right colspan=2 input type=reset name=button id=button value=重置 / span nbsp;nbsp;nbsp;nbsp;/span input type=submit name=button2 id=button2 value=登录 / /td /tr /table/form（2）登录后台验证代码public User login(final User u) {Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;User user = null;try {conn = DataAccess.getConnection();// 获取数据库连接pstmt = conn.prepareStatement(select * from tb_user where uname=? and upassword=?);// 创建 Statement对象pstmt.setString(1, u.getUname());pstmt.setString(2, u.getUpassword());rs = pstmt.executeQuery();// 执行查询条件返回记录集rsif(rs.next()){int uid = rs.getInt(uid);user = new User(u.getUname(), u.getUpassword());user.setUid(uid);}}catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{DataAccess.close(conn, pstmt, rs);}return user;}二、主界面（1）获取数据库连接第一步 加载数据库驱动，此处为加载mysql驱动Class.forName(com.mysql.jdbc.Driver);// 加载mysql数据驱动第二步 创建数据库连接，注意连接数据库的URL和账号和密码Con=DriverManager.getConnection(jdbc:mysql://localhost:3306/mldn, root, 123111);// 创建数据连接第三步 创建一个Statement，用于执行SQL语句Statement?stmt?=?conn.createStatement();第四步 执行SQL语句ResultSet?rs?=?stmt.executeQuery(SELECT?*?FROM?...);第五步 处理结果集while(rs.next()){ String?name?=?rs.getString(name); String?pass?=?rs.getString(1);……}第六步 关闭数据库连接rs.close();stmt.close();conn.close();（2）核心功能介绍a、论文列表查看论文列表查看表单代码：form action= method=post id=form1 name=form1table id=tab width=740pxtrth用户编号/thth论文名称/thth发表日期/thth期刊名称/thth作者排名/thth期刊类型/thth备注/thth操作/th/tr%for (int i = 0; i list.size(); i++) {blog = (Article) list.get(i);%trtd %=blog.getUser().getUid()%/tdtd a href=/JavaTask/servlet/Manag