信息中心完成网站建设,盐城高端网站建设,三亚网站建设价格,上海app开发网站建设JAVAWML信息查询与后端信息发布系统实现
一、系统概述
本系统基于Java和WML(无线标记语言)技术开发#xff0c;实现了移动设备上的信息查询与后端信息发布功能。系统采用B/S架构#xff0c;服务器端使用Java Servlet处理请求#xff0c;数据库采用MySQL存储信息#xff0…JAVAWML信息查询与后端信息发布系统实现
一、系统概述
本系统基于Java和WML(无线标记语言)技术开发实现了移动设备上的信息查询与后端信息发布功能。系统采用B/S架构服务器端使用Java Servlet处理请求数据库采用MySQL存储信息客户端通过WAP浏览器访问WML页面。系统支持信息分类查询、关键词搜索、信息发布与管理等功能为移动设备用户提供便捷的信息获取渠道。
二、系统架构设计
1. 技术选型
前端WML (Wireless Markup Language)后端Java Servlet、JSP数据库MySQL开发工具Eclipse、Tomcat
2. 系统架构
├── src
│ ├── main
│ │ ├── java
│ │ │ └── com
│ │ │ └── wmlsystem
│ │ │ ├── controller (控制器层)
│ │ │ ├── model (模型层)
│ │ │ ├── dao (数据访问层)
│ │ │ └── utils (工具类)
│ │ ├── webapp
│ │ │ ├── WEB-INF
│ │ │ │ ├── web.xml
│ │ │ │ └── views (JSP页面)
│ │ │ └── wml (WML页面)三、核心代码实现
1. WML页面设计
!-- index.wml --
?xml version1.0 encodingUTF-8?
!DOCTYPE wml PUBLIC -//WAPFORUM//DTD WML 1.1//EN http://www.wapforum.org/DTD/wml_1.1.xml
wmlcard idmain title信息查询系统p aligncenterbigb信息查询系统/b/bigbr/br/a hrefcategories.wml分类查询/abr/a hrefsearch.wml关键词搜索/abr/a hreflogin.wml管理入口/abr//p/card
/wml!-- categories.wml --
?xml version1.0 encodingUTF-8?
!DOCTYPE wml PUBLIC -//WAPFORUM//DTD WML 1.1//EN http://www.wapforum.org/DTD/wml_1.1.xml
wmlcard idcategories title信息分类p aligncenterbigb信息分类/b/bigbr/br/a hreflist.wml?categorynews新闻资讯/abr/a hreflist.wml?categoryproducts产品信息/abr/a hreflist.wml?categoryevents活动通知/abr/a hreflist.wml?categoryfaq常见问题/abr/a hrefindex.wml返回首页/a/p/card
/wml2. 数据库连接工具
// DBConnectionUtil.java
public class DBConnectionUtil {private static final String URL jdbc:mysql://localhost:3306/wmlsystem;private static final String USER root;private static final String PASSWORD password;public static Connection getConnection() throws SQLException {return DriverManager.getConnection(URL, USER, PASSWORD);}public static void close(Connection conn, Statement stmt, ResultSet rs) {try {if (rs ! null) rs.close();if (stmt ! null) stmt.close();if (conn ! null) conn.close();} catch (SQLException e) {e.printStackTrace();}}
}3. 信息管理DAO
// InfoDAO.java
public class InfoDAO {// 获取分类信息列表public ListInfo getInfoListByCategory(String category, int page, int pageSize) {ListInfo infoList new ArrayList();Connection conn null;PreparedStatement stmt null;ResultSet rs null;try {conn DBConnectionUtil.getConnection();String sql SELECT * FROM information WHERE category ? ORDER BY publish_time DESC LIMIT ? OFFSET ?;stmt conn.prepareStatement(sql);stmt.setString(1, category);stmt.setInt(2, pageSize);stmt.setInt(3, (page - 1) * pageSize);rs stmt.executeQuery();while (rs.next()) {Info info new Info();info.setId(rs.getInt(id));info.setTitle(rs.getString(title));info.setContent(rs.getString(content));info.setCategory(rs.getString(category));info.setPublishTime(rs.getTimestamp(publish_time));infoList.add(info);}} catch (SQLException e) {e.printStackTrace();} finally {DBConnectionUtil.close(conn, stmt, rs);}return infoList;}// 根据关键词搜索信息public ListInfo searchInfo(String keyword, int page, int pageSize) {ListInfo infoList new ArrayList();Connection conn null;PreparedStatement stmt null;ResultSet rs null;try {conn DBConnectionUtil.getConnection();String sql SELECT * FROM information WHERE title LIKE ? OR content LIKE ? ORDER BY publish_time DESC LIMIT ? OFFSET ?;stmt conn.prepareStatement(sql);stmt.setString(1, % keyword %);stmt.setString(2, % keyword %);stmt.setInt(3, pageSize);stmt.setInt(4, (page - 1) * pageSize);rs stmt.executeQuery();while (rs.next()) {Info info new Info();info.setId(rs.getInt(id));info.setTitle(rs.getString(title));info.setContent(rs.getString(content));info.setCategory(rs.getString(category));info.setPublishTime(rs.getTimestamp(publish_time));infoList.add(info);}} catch (SQLException e) {e.printStackTrace();} finally {DBConnectionUtil.close(conn, stmt, rs);}return infoList;}// 发布新信息public int publishInfo(Info info) {Connection conn null;PreparedStatement stmt null;ResultSet rs null;int id -1;try {conn DBConnectionUtil.getConnection();String sql INSERT INTO information (title, content, category, publish_time) VALUES (?, ?, ?, NOW());stmt conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);stmt.setString(1, info.getTitle());stmt.setString(2, info.getContent());stmt.setString(3, info.getCategory());int rows stmt.executeUpdate();if (rows 0) {rs stmt.getGeneratedKeys();if (rs.next()) {id rs.getInt(1);}}} catch (SQLException e) {e.printStackTrace();} finally {DBConnectionUtil.close(conn, stmt, rs);}return id;}// 其他方法省略...
}4. Servlet控制器
// InfoListServlet.java
WebServlet(/list.wml)
public class InfoListServlet extends HttpServlet {private static final long serialVersionUID 1L;private InfoDAO infoDAO new InfoDAO();protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response.setContentType(text/vnd.wap.wml;charsetUTF-8);PrintWriter out response.getWriter();String category request.getParameter(category);int page Integer.parseInt(request.getParameter(page));int pageSize 10;ListInfo infoList infoDAO.getInfoListByCategory(category, page, pageSize);out.println(?xml version\1.0\ encoding\UTF-8\?);out.println(!DOCTYPE wml PUBLIC \-//WAPFORUM//DTD WML 1.1//EN\ \http://www.wapforum.org/DTD/wml_1.1.xml\);out.println(wml);out.println(card id\list\ title\ category 列表\);out.println(p align\center\);out.println(bigb category 列表/b/bigbr/);out.println(/p);if (infoList.isEmpty()) {out.println(p align\center\暂无信息/p);} else {out.println(p);for (Info info : infoList) {out.println(a href\detail.wml?id info.getId() \ info.getTitle() /abr/);}out.println(/p);// 分页导航out.println(p align\center\);if (page 1) {out.println(a href\list.wml?category category page (page - 1) \上一页/a );}if (infoList.size() pageSize) {out.println(a href\list.wml?category category page (page 1) \下一页/a);}out.println(/p);}out.println(p align\center\);out.println(a href\categories.wml\返回分类/abr/);out.println(a href\index.wml\返回首页/a);out.println(/p);out.println(/card);out.println(/wml);}
}// PublishServlet.java
WebServlet(/publish.do)
public class PublishServlet extends HttpServlet {private static final long serialVersionUID 1L;private InfoDAO infoDAO new InfoDAO();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(UTF-8);String title request.getParameter(title);String content request.getParameter(content);String category request.getParameter(category);Info info new Info();info.setTitle(title);info.setContent(content);info.setCategory(category);int result infoDAO.publishInfo(info);response.setContentType(text/vnd.wap.wml;charsetUTF-8);PrintWriter out response.getWriter();out.println(?xml version\1.0\ encoding\UTF-8\?);out.println(!DOCTYPE wml PUBLIC \-//WAPFORUM//DTD WML 1.1//EN\ \http://www.wapforum.org/DTD/wml_1.1.xml\);out.println(wml);out.println(card id\result\ title\发布结果\);if (result 0) {out.println(p align\center\信息发布成功/p);} else {out.println(p align\center\信息发布失败/p);}out.println(p align\center\);out.println(a href\admin.wml\返回管理页面/abr/);out.println(/p);out.println(/card);out.println(/wml);}
}5. 信息管理页面
!-- publish.wml --
?xml version1.0 encodingUTF-8?
!DOCTYPE wml PUBLIC -//WAPFORUM//DTD WML 1.1//EN http://www.wapforum.org/DTD/wml_1.1.xml
wmlcard idpublish title发布信息pb标题:/bbr/input typetext nametitle maxlength50/br/b分类:/bbr/select namecategoryoption valuenews新闻资讯/optionoption valueproducts产品信息/optionoption valueevents活动通知/optionoption valuefaq常见问题/option/selectbr/b内容:/bbr/textarea namecontent rows8 maxlength1000/textareabr/anchor发布go hrefpublish.do methodpostpostfield nametitle value$title/postfield namecategory value$category/postfield namecontent value$content//go/anchorbr/a hrefadmin.wml返回/a/p/card
/wml四、系统界面设计
1. 前端WML页面设计
系统的前端使用WML语言设计包括以下主要页面
首页提供分类查询、关键词搜索和管理入口分类列表页显示特定分类的信息列表信息详情页显示信息的详细内容搜索页提供关键词搜索功能管理页管理员登录后可进行信息发布、编辑和删除
2. 后端管理界面
后端管理界面使用JSP和Servlet实现包括
管理员登录页面信息发布页面信息管理页面分类管理页面
3. 界面交互逻辑
// 生成WML页面的辅助方法
private void generateWMLInfoList(PrintWriter out, ListInfo infoList, String category, int page) {out.println(?xml version\1.0\ encoding\UTF-8\?);out.println(!DOCTYPE wml PUBLIC \-//WAPFORUM//DTD WML 1.1//EN\ \http://www.wapforum.org/DTD/wml_1.1.xml\);out.println(wml);out.println(card id\list\ title\ category 列表\);out.println(p align\center\);out.println(bigb category 列表/b/bigbr/);out.println(/p);if (infoList.isEmpty()) {out.println(p align\center\暂无信息/p);} else {out.println(p);for (Info info : infoList) {// 截断过长的标题String shortTitle info.getTitle();if (shortTitle.length() 20) {shortTitle shortTitle.substring(0, 20) ...;}out.println(a href\detail.wml?id info.getId() \ shortTitle /abr/);}out.println(/p);// 分页导航out.println(p align\center\);if (page 1) {out.println(a href\list.wml?category category page (page - 1) \上一页/a );}if (infoList.size() 10) {out.println(a href\list.wml?category category page (page 1) \下一页/a);}out.println(/p);}out.println(p align\center\);out.println(a href\categories.wml\返回分类/abr/);out.println(a href\index.wml\返回首页/a);out.println(/p);out.println(/card);out.println(/wml);
}五、系统部署与测试
1. 环境要求
JDK 1.8Apache Tomcat 8MySQL 5.7WAP模拟器或支持WAP的手机
2. 部署步骤
创建数据库并导入表结构配置数据库连接信息将项目部署到Tomcat服务器使用WAP模拟器或手机访问系统
3. 测试用例
// InfoDAOTest.java
public class InfoDAOTest {private InfoDAO infoDAO new InfoDAO();Testpublic void testPublishInfo() {Info info new Info();info.setTitle(测试信息);info.setContent(这是一条测试信息用于测试信息发布功能。);info.setCategory(news);int result infoDAO.publishInfo(info);assertTrue(result 0);}Testpublic void testGetInfoListByCategory() {ListInfo infoList infoDAO.getInfoListByCategory(news, 1, 10);assertNotNull(infoList);}Testpublic void testSearchInfo() {ListInfo infoList infoDAO.searchInfo(测试, 1, 10);assertNotNull(infoList);}
}六、毕业设计文档框架
1. 论文框架
引言相关技术综述系统需求分析系统设计系统实现系统测试总结与展望
七、总结
本系统基于Java和WML技术实现了移动设备上的信息查询与后端信息发布功能采用B/S架构具有良好的可扩展性和可维护性。系统支持信息的分类查询、关键词搜索和后台管理为移动设备用户提供了便捷的信息获取渠道。通过本项目的开发深入掌握了Java Web开发技术和WML页面设计。
