J2EE 三层上应用Ajax例子（源码）

package com.wayking.AJAX.operation; import java.awt.List; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import com.wayking.AJAX.db.Conn; public class Remember { Statement stat; public Remember() { // TODO Auto-generated constructor stub try { stat = Conn.getConnection().createStatement(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void addRemenber(String message) { String sql = "insert into remember values('" + message + "')"; try { stat.execute(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public boolean isHaved(String message) { boolean isHavaed = false; ResultSet rs = null; String sql = "select * from remember where message='" + message + "'"; try { rs = stat.executeQuery(sql); if (rs != null) { isHavaed = true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return isHavaed; } public ResultSet getAllMessage() { System.out.println("开始读取数据"); ResultSet rs = null; String sql = "select message from remember"; try { rs = stat.executeQuery(sql); // System.out.println(rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } }