jan|java简单留言板实现代码

时间：2017-03-13 来源：留言阅读：

java简单留言板实现代码

数据库教程对应的表：

guestbook：id ,name,phone,email,title,content,time;                   id

新建web project：guestbook

build Path：引入连接数据库的驱动的类库

在webRoot目录中加入：

+faceditor

+js

web.xml

代码：

xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

    AddMessageServlet
    webbook.guestbook.AddMessageServlet

    GetMessagesServlet
    webbook.guestbook.GetMessagesServlet


    AddMessageServlet
    /servlet/addMessage

    GetMessagesServlet
    /servlet/getMessages

addMessage.htm

代码：

<script type="text/网页特效" src="/guestbook/js/validation-framework.js"></script>
<script type="text/javascript" src="/guestbook/fckeditor/fckeditor.js"></script>
add message

请您输入留言

查看留言


      姓名：





      E-Mail：





      电话：





      主题：





      内容：

<script type="text/javascript">
      var oFCKeditor = new FCKeditor("content");
      oFCKeditor.BasePath = "/guestbook/fckeditor/" ;
      oFCKeditor.Height = 300 ;
   oFCKeditor.ToolbarSet = "Basic";
   oFCKeditor.Create() ;
</script>










content.html

display content

留言内容


      编号
      12


      姓名
      liuwei


      电话
      2922266


      email
      php教程a@sina.com.cn


      主题
      you can test


      内容
      test content!


    编号


    姓名


    电话


    email


    主题


    内容


    编号


    姓名


    电话


    email


    主题



内容







validation-config.xml

代码；









---------------------------------------------------------------------

******************************************************

这是一个很有用的工具类，包含了：

　　判读字符串参数是否为空：validateNull(String args)

　　判断输入的字符串参数是否为空或者是"null"字符：chanageNull(String source, String target)

　　过滤<, >,n 字符的方法：filterHtml(String input)

*****************************************************

---------------------------------------------------------------------

StringUtil.java

代码：

package webbook.util;

public class StringUtil {

/**
* 判断输入的字符串参数是否为空。
* @param args 输入的字串
* @return true/false
*/
public static boolean validateNull(String args) {
if (args == null || args.length() == 0) {
   return true;
} else {
   return false;
}
}

/**
* 判断输入的字符串参数是否为空或者是"null"字符,如果是,就返回target参数,如果不是,就返回source参数。
*/
public static String chanageNull(String source, String target) {
if (source == null || source.length() == 0 || source.equalsIgnoreCase("null")) {
   return target;
} else {
   return source;
}
}

/**
* 过滤<, >,n 字符的方法。
* @param input 需要过滤的字符
* @return 完成过滤以后的字符串
*/
public static String filterHtml(String input) {
if (input == null) {
   return null;
}
if (input.length() == 0) {
   return input;
}
input = input.replaceAll("&", "&");
input = input.replaceAll("<", "<");
input = input.replaceAll(">", ">");
input = input.replaceAll(" ", " ");
input = input.replaceAll(""", "'");
input = input.replaceAll(""", """);
input = input.replaceAll("n", "
");
return input;

}
}

AddmessageServlet.java

代码；

package webbook.guestbook;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import webbook.util.StringUtil;

public class AddMessageServlet extends HttpServlet {

private static final long serialVersionUID = -8349454122547148005L;

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String url = "jdbc:oracle:thin:@192.168.1.20:1521:ora9";
String username = "scott";
String password = "tiger";

String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
int result = 0;
Connection conn = null;

request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String title = request.getParameter("title");

response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("");
out.println("guestbook input page");
out.println("");

if (StringUtil.validateNull(name)) {
   out.println("对不起，姓名不能为空，请您重新输入！
");
   out.println("添加新的留言
");
} else if (StringUtil.validateNull(title)) {
   out.println("对不起，主题不能为空，请您重新输入！
");
   out.println("添加新的留言
");
} else {
   try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    conn = DriverManager.getConnection(url, username, password);

    PreparedStatement ps教程tmt = conn.prepareStatement(sql);
    pstmt.setString(1, StringUtil.filterHtml(name));
    pstmt.setString(2, StringUtil.filterHtml(request.getParameter("email")));
    pstmt.setString(3, StringUtil.filterHtml(request.getParameter("phone")));
    pstmt.setString(4, StringUtil.filterHtml(title));
    pstmt.setString(5, request.getParameter("content"));

                     //设置格式化时间

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
    pstmt.setString(6, sdf.format(new java.util.Date()));

    result = pstmt.executeUpdate();
    pstmt.close();
   } catch (ClassNotFoundException e) {
    e.printStackTrace();
   } catch (SQLException e) {
    e.printStackTrace();
   } finally {
    try {
     conn.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if (result == 0) {
    out.println("对不起，添加留言不成功，请您重新输入！
");
    out.println("添加新的留言
");
   } else {
    out.println("祝贺您，成功添加留言。
");
    out.println("查看所有留言内容
");
   }
   out.println("");
   out.println("");
   out.flush();
   out.close();
}
}
}

GetMessageServlet.java

代码：

package webbook.guestbook;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import webbook.util.StringUtil;

public class GetMessagesServlet extends HttpServlet {
private static final long serialVersionUID = 5964428201228635704L;

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String url = "jdbc:oracle:thin:@192.168.1.20:1521:ora9";
String username = "scott";
String password = "tiger";
String sql = "select * from guestbook order by id desc";
Connection conn = null;
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("");
out.println("display messages");
out.println("");
out.println("添加新的留言内容
");
out.println("留言内容

");
try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn = DriverManager.getConnection(url, username, password);
   PreparedStatement pstmt = conn.prepareStatement(sql);

   //查询结果是一个ResultSet对象。
   ResultSet rs = pstmt.executeQuery();
   while (rs.next()) {
    this.printRow(out, rs);
   }
   rs.close();
   pstmt.close();
} catch (ClassNotFoundException e) {
   e.printStackTrace();
} catch (SQLException e) {
   e.printStackTrace();
} finally {
   try {
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
}
out.println(" ");
out.println("");
out.flush();
out.close();
}

private void printRow(PrintWriter out, ResultSet rs) throws SQLException {
out.println("");
out.println("编号");
out.println("" + rs.getInt("id") + "");
out.println("姓名" + rs.getString("name") + "");
out.println("电话" + StringUtil.chanageNull(rs.getString("phone"), "没填") + "");
out.println("email" + StringUtil.chanageNull(rs.getString("email"), "没填") + "");
out.println("主题" + rs.getString("title") + " ");
out.println("内容");
out.println("" + StringUtil.chanageNull(rs.getString("content"), "没填") + "");
out.println("时间" + rs.getString("time") + " ");
out.println("
");
}
}

jan|java简单留言板实现代码

http://m.bbyears.com/zhufuduanxin/31149.html

推荐访问:java学习路线 jason jar

上一篇：seo需要学多久_SEO需要明白搜索引擎惩罚网站的几个原则

下一篇：[httpheadersecurityfilter]HttpHelpers类普通GET和POST方式，带Cookie和带证书验证模式