1、input name=username type=text id= size=30/label /trtd密码:passwordtd align=right colspan=2resetbutton重置span &/spansubmitbutton2登录/table/form(2)登录后台验证代码 public User login(final User u) Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; User user = null; try conn = DataAc
2、cess.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();/ 执行查询条件返回记录集rs if(rs.next() int uid = rs.getInt(uid user = new User(u.ge
3、tUname(), u.getUpassword(); user.setUid(uid); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally DataAccess.close(conn, pstmt, rs); return user; 二、主界面(1)获取数据库连接第一步 加载数据库驱动,此处为加载mysql驱动Class.forName(com.mysql.jdbc.Driver/ 加载mysql数据驱动第二步 创建数据库连接,注意连接数据库的URL和账号和密码Con=
4、DriverManager.getConnection(jdbc:mysql:/localhost:3306/mldn, root123111/ 创建数据连接第三步 创建一个Statement,用于执行SQL语句Statementstmt=conn.createStatement();第四步 执行SQL语句ResultSetrsstmt.executeQuery(SELECT*FROM.第五步 处理结果集while(rs.next() Stringnamers.getString(namepassrs.getString(1);第六步 关闭数据库连接rs.close();stmt.close(
5、);conn.close();(2)核心功能介绍a、论文列表查看论文列表查看表单代码:form action= width=740px 用户编号论文名称发表日期期刊名称作者排名期刊类型备注操作% for (int i = 0; i %=blog.getUser().getUid()% a href=/JavaTask/servlet/ManagerArticleServlet?status=getArticle&id=%=blog.getAname()%/a%=blog.getAdate() %=blog.getAqkname()%center%=blog.getAnamepm()%=blog
6、.getArticleType().getTypename()%textarea style=border: 0em; background-color: white; rows=1 %=blog.getAbeizhu()%/textarea javascript:p_update()img src=/JavaTask/images/edit.gif alt=编辑p_del( br style=border-bottom-style: dotted;2px/总共&%=pag.totalPageNumber()%页 ,当前是第&%=pag.getCurrentPage() %页/JavaTask
7、/servlet/AdminServletselect name=currentPage%for (int i=1;ioption value=%=i%第&/option%;%/select跳转 /JavaTask/servlet/AdminServlet?currentPage=1第一页currentPage=上一页下一页最后一页论文列表查看后台代码:public List getPerPageArticle(final int currentPage,final int perSize) List list = new ArrayList list=(List%for (int i=0;l
8、ist.size();i+)category=list.get(i);%=category.getTypeid()%=category.getTypename() %备注:textarea name= cols=18040添加新增论文后台代码:public Integer insertArticle(final Article article) int i = 0;insert into tb_article( uid,aname ,adate,aqkname, anamepm, typeid ,abeizhu )values(?,?/ 创建 prepareStatement对象 pstmt.
9、setInt(1, article.getUser().getUid(); pstmt.setString(2, article.getAname(); pstmt.setDate(3, new java.sql.Date(article.getAdate().getTime(); pstmt.setString(4, article.getAqkname(); pstmt.setInt(5, article.getAnamepm(); pstmt.setInt(6, article.getArticleType().getTypeid(); pstmt.setString(7, articl
10、e.getAbeizhu(); i= pstmt.executeUpdate(); DataAccess.close(conn, pstmt); return i;c、修改论文修改论文表单代码: Article blog=(Article)request.getAttribute(articleupdateid%=blog.getAname() % onClick=%=blog.getAdate()%=blog.getAqkname() %=blog.getAnamepm() %更新修改论文后台代码:public Integer update(final Article article) update tb_article set uid=? , aname= ? ,adate= ? ,aqkname=?, anamepm=?, typeid =? ,abeizhu=? where aid=?/ 创建 PreparedStatement 对象
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1