ways.java

用struts2+jsp开发的留言板

	}
	try {
		  sqlMap.startTransaction();
	        sqlMap.delete("deleteUser",userInfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}
/**
 * 审核留言
 * @param liuYaninfo
 */
public static void audioinfo(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.update("audio",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}
/**
 * 返回未审核的留言
 * @param liuYaninfo
 * @return
 */
public static List<LiuYaninfo> NOAudio(LiuYaninfo liuYaninfo){
	String resource="com/tianji/liuyan/map/SqlMapConfigInfo.xml";
	SqlMapClient sqlMap=null;
	List 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();
	       list=sqlMap.queryForList("NoAudio",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 返回未回复的留言
 * @param liuYaninfo
 * @return
 */
public static List<LiuYaninfo> NOReply(LiuYaninfo liuYaninfo){
	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();
	        list=sqlMap.queryForList("NOReply",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 返回已经审核的留言
 * @param liuYaninfo
 * @return
 */
public static List<LiuYaninfo> HavaAudio(LiuYaninfo liuYaninfo){
	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();
	        list=sqlMap.queryForList("HavaAudio",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}
/**
 * 返回已经回复的留言
 * @param liuYaninfo
 * @return
 */
public static List<LiuYaninfo> HavaReply(LiuYaninfo liuYaninfo){
	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();
	       list=sqlMap.queryForList("HavaReply",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return list;
}

public static String updatereply(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.update("updatereply",liuYaninfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	return admin_page;
}
/**
 * 修改密码
 * @param userInfo
 */
public static void changepass(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();
	}
	try {
		  sqlMap.startTransaction();
	        sqlMap.update("updatePasswordUser",userInfo);
	    	sqlMap.commitTransaction();
	} catch (SQLException e) {
		System.out.println(e.getMessage());
	} finally {
		try {
			sqlMap.endTransaction();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}
public static void main(String[] args) {
	/*
	 * insrtuser的测试
	 */
//	UserInfo user=new UserInfo();
//	user.setUsername("zhouman");
//    user.setPassword("200520");
//    user.setEmail("[e-mail]");
//    user.setLogintime("2009-03-17");
//    insertUser(user);
	/*
	 * check的测试
//	 */
//	Boolean boolean1=check("shenang","200520");
//	System.out.println(boolean1);
	/*
	 * getmessage测试
	 */
//	LiuYaninfo liuYaninfo=new LiuYaninfo();
//	List<LiuYaninfo> list=getMessage();
//	for (int i = 0; i < list.size(); i++) {
//	   // System.out.print(((LiuYaninfo) list.get(i)).getId());
//	    System.out.print(((LiuYaninfo) list.get(i)).getUsername());
//		System.out.println();
//	}
	
	/*
	 * addinfo测试
	 */
//	LiuYaninfo liuYaninfo=new LiuYaninfo();
//	liuYaninfo.setStatus(0);
//	liuYaninfo.setIp("222.132.23.212");
//	liuYaninfo.setInfo("good");
//	liuYaninfo.setReplyinfo("good goood");
//	liuYaninfo.setCommon_date("20009-03-02");
//	liuYaninfo.setUsername("shenang");
//	addinfo(liuYaninfo);
	/*
	 * deleteinfo测试
	 */
//	LiuYaninfo liuYaninfo=new LiuYaninfo();
//	liuYaninfo.setId(21);
//	deleteinfo(liuYaninfo);
	/*
	 * audioinfo,noaudio,havaaudio,havareply,noreply测试
	 * 
	 */
//	LiuYaninfo liuYaninfo=new LiuYaninfo();
//	liuYaninfo.setId(2);
//	liuYaninfo.setStatus(1);
//	audioinfo(liuYaninfo);
	
//	LiuYaninfo liuYaninfo=new LiuYaninfo();
//	List<LiuYaninfo> list=null;  
//	list=NOReply(liuYaninfo);  //测试时修改相应的方法即可，测试完全通过
//	for(int i=0;i<list.size();i++)
//	{
//	System.out.println(list.get(i).getId());
//	}
	/*
	 * getUserMessage测试
	 */
//	UserInfo info=new UserInfo();
//	List<UserInfo> list=null;  
//	list=getUserMessage();  //测试时修改相应的方法即可，测试完全通过
//	for(int i=0;i<list.size();i++)
//	{
//	System.out.println(list.get(i).getId());
//	System.out.println(list.get(i).getUsername());
//	}
  /*
   * deleteuser测试
   */
//	UserInfo info=new UserInfo();
//	info.setId(8);
//	deleteuser(info);
}
}