ways.java

用struts2+jsp开发的留言板

package com.tianji.liuyan.action;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.tianji.liuyan.model.AdminInfo;
import com.tianji.liuyan.model.LiuYaninfo;
import com.tianji.liuyan.model.UserInfo;

public class Ways extends ActionSupport{
	private static final String admin_page = "admin";// 后面页面

	
	/**
	 * 增加一个用户，注册用户时使用此方法
	 * @param user
	 */
	public static void insertUser(UserInfo user) {
		// 首先初始化 iBatis 获得一个 SqlMapClient 对象
		String resource="com/tianji/liuyan/map/SqlMapConfiguser.xml";
		SqlMapClient sqlMap=null;
		try {
			Reader reader=Resources.getResourceAsReader(resource);
			sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch (IOException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
//		String resource = "com/ctgusec/zhupan/maps/SqlMapConfig.xml";
//		com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
//		try {
//			java.io.Reader reader = com.ibatis.common.resources.Resources
//					.getResourceAsReader(resource);
//			sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
		// sqlMap 系统初始化完毕，开始执行 update 操作
		try {
			sqlMap.startTransaction();
			//User user = new User();
			sqlMap.insert("insertUser",user);
			sqlMap.commitTransaction();
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		} finally {
			try {
				sqlMap.endTransaction();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	/**
	 *  能过输入的姓名检验用户是否在数据库中，即是否为合法用户
	 * @param str
	 * @return
	 */
public static Boolean check(String str1,String str2){
	String resource="com/tianji/liuyan/map/SqlMapConfiguser.xml";
	SqlMapClient sqlMap=null;
	List<UserInfo> list=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		sqlMap.startTransaction();
		UserInfo user = new UserInfo();
		user.setUsername(str1);
		user.setPassword(str2);
	    list=sqlMap.queryForList("getAllUser",user);
		sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	if(list.isEmpty()){
		return false;
	}else{
		return true;
	}
}

/**
 * 获得留言信息（已经审核）以便在前台显示
 * @return
 */

public static List<LiuYaninfo> getMessage(){
	String resource="com/tianji/liuyan/map/SqlMapConfigInfo.xml";
	SqlMapClient sqlMap=null;
	List<LiuYaninfo> list=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		sqlMap.startTransaction();
		LiuYaninfo liuYaninfo=new LiuYaninfo();
	     list=sqlMap.queryForList("listinfo",liuYaninfo);
		sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 获取所有留言，包括未审核
 * @return
 */
public static List<LiuYaninfo> getAllMessage(){
	String resource="com/tianji/liuyan/map/SqlMapConfigInfo.xml";
	SqlMapClient sqlMap=null;
	List<LiuYaninfo> list=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		sqlMap.startTransaction();
		LiuYaninfo liuYaninfo=new LiuYaninfo();
	     list=sqlMap.queryForList("listallinfo",liuYaninfo);
		sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 取得单个用户信息
 * @return
 */
/**
 * @return
 */
public static List<UserInfo> getUserMessage(){
	String resource="com/tianji/liuyan/map/SqlMapConfiguser.xml";
	SqlMapClient sqlMap=null;
	List<UserInfo> list=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		 sqlMap.startTransaction();
		 UserInfo userInfo=new UserInfo(); 
//		 ActionContext actionContext=ActionContext.getContext();
//		 Map request=actionContext.getParameters();
//		 String str=String.valueOf(request.get("username"));
//		 userInfo.setUsername(str);
//		 userInfo.setUsername("shenang");
//		 userInfo.setUsername("zhaoya");
	     list=sqlMap.queryForList("listalluserinfo",userInfo);
		sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 取得所有用户信息
 * @return
 */
public static List<UserInfo> getAllUserMessage(){
	String resource="com/tianji/liuyan/map/SqlMapConfiguser.xml";
	SqlMapClient sqlMap=null;
	List<UserInfo> list=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		sqlMap.startTransaction();
		UserInfo userInfo=new UserInfo();
	     list=sqlMap.queryForList("listalluserinfo",userInfo);
		sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 增加一条新的留言
 *
 */

public static void addinfo(LiuYaninfo liuYaninfo){
	String resource="com/tianji/liuyan/map/SqlMapConfigInfo.xml";
	SqlMapClient sqlMap=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		  sqlMap.startTransaction();
	        sqlMap.insert("insertinfo",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}
/**
 * 删除留言
 * @param liuYaninfo
 */

public static void deleteinfo(LiuYaninfo liuYaninfo){
	String resource="com/tianji/liuyan/map/SqlMapConfigInfo.xml";
	SqlMapClient sqlMap=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}
	try {
		  sqlMap.startTransaction();
	        sqlMap.delete("deleteinfo",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

public static void deleteuser(UserInfo userInfo){
	String resource="com/tianji/liuyan/map/SqlMapConfiguser.xml";
	SqlMapClient sqlMap=null;
	try {
		Reader reader=Resources.getResourceAsReader(resource);
		sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
	} catch (IOException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();