jetspeed学习笔记2 -

danwind

浏览: 232766 次
性别:
来自: 广东

最近访客更多访客>>

dd533

裴喜龙

xuyongff

MonsterDoctor

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

jetspeed学习笔记2

博客分类：

portals

SQL MySQL JSP 编程 JDBC

1.这次主要是针对portlet编程，首先建立java类TestDataPortlet extends GenericPortlet，重写doView、processAction、init和destroy。代码如下所示：

package com.tortrend.portlet;

import java.io.IOException;
import java.util.List;

import javax.portlet.ActionRequest;
import javax.portlet.ActionResponse;
import javax.portlet.EventRequest;
import javax.portlet.EventResponse;
import javax.portlet.GenericPortlet;
import javax.portlet.PortletConfig;
import javax.portlet.PortletException;
import javax.portlet.PortletRequestDispatcher;
import javax.portlet.PortletSession;
import javax.portlet.RenderRequest;
import javax.portlet.RenderResponse;
import javax.portlet.WindowState;

import com.tortrend.general.TestDataBean;
import com.tortrend.general.TestDataDAOImpl;

public class TestDataPortlet extends GenericPortlet {

	private static final String NORMAL_VIEW = "/test/normal.jsp";
	private static final String MAXIMIZED_VIEW = "/test/maximized.jsp";
	private static final String HELP_VIEW = "/test/help.jsp";

	private PortletRequestDispatcher normalView;
	private PortletRequestDispatcher maximizedView;
	private PortletRequestDispatcher helpView;

	protected void doView(RenderRequest request, RenderResponse response)
			throws PortletException, IOException {
		System.out.println("testdataportlet doView ...");
		PortletSession session = request.getPortletSession();
		if ("delete".equals(request.getParameter("actionflag"))) {
			int id = Integer.parseInt(request.getParameter("id"));
			TestDataDAOImpl.delete(id);
			System.out.println("testdataportlet doView delete");
		} else if("adduser".equals(request.getParameter("actionflag"))) {
			int id = TestDataDAOImpl.getCount() + 1;
			TestDataBean tdb = new TestDataBean();
			tdb.setId(id);
			tdb.setName("wgj" + id);
			tdb.setPassword("123");
			TestDataDAOImpl.add(tdb);
			System.out.println("testdataportlet doView add");
		} else if("update".equals(request.getParameter("actionflag"))) {
			int id = Integer.parseInt(request.getParameter("id"));
			TestDataDAOImpl.update(id);
			session.removeAttribute("test.list");
			System.out.println("testdataportlet doView update");
		}
		int curp = request.getParameter("curp") != null ? Integer.parseInt(request.getParameter("curp")):1;
		int pagesize = 5;
		int totalNum = TestDataDAOImpl.getCount();
		int totalPage = (totalNum + pagesize - 1 ) / pagesize;

		List<TestDataBean> list = TestDataDAOImpl.getSome(curp, pagesize);
		session.setAttribute("test.list", list);
		session.setAttribute("test.curp", curp);
		session.setAttribute("test.totalPage", totalPage);
		if (WindowState.MINIMIZED.equals(request.getWindowState())) {
			return;
		}

		if (WindowState.NORMAL.equals(request.getWindowState())) {
			normalView.include(request, response);
		} else {
			maximizedView.include(request, response);
		}
		
		
	}	
public void processAction(ActionRequest request, ActionResponse arg1)
			throws PortletException, IOException {
		if("Submit".equals(request.getParameter("actionflag"))) {
			//System.out.println("testdataportlet processAction checklogin");
			PortletSession session = request.getPortletSession();
			String name = request.getParameter("username");
			String password = request.getParameter("password");
			System.out.println("name=" + name);
			System.out.println("password=" + password);
			if(TestDataDAOImpl.checkLogin(name, password)) {
				session.setAttribute("test.username", name);
				List<TestDataBean> list = TestDataDAOImpl.getAll();
				session.setAttribute("test.list", list);
				//System.out.println("testdataportlet processAction checklogin success");
			} else {
				session.setAttribute("test.username", null);
				//System.out.println("testdataportlet processAction checklogin failure");
			}
		} else if ("delete".equals(request.getParameter("actionflag"))) {
			int id = Integer.parseInt(request.getParameter("id"));
			TestDataDAOImpl.delete(id);
			System.out.println("testdataportlet processAction delete");
		}
	}

	public void init(PortletConfig config) throws PortletException {
		super.init(config);
		normalView = config.getPortletContext().getRequestDispatcher(
				NORMAL_VIEW);
		maximizedView = config.getPortletContext().getRequestDispatcher(
				MAXIMIZED_VIEW);
		helpView = config.getPortletContext().getRequestDispatcher(HELP_VIEW);
	}
	
	 public void destroy() {
	        normalView = null;
	        maximizedView = null;
	        helpView = null;
	        super.destroy();
	    }

}

2.所对应的jsp代码如下：

<%@ page session="false" import="java.util.*,javax.portlet.*,com.tortrend.general.*" %>
<%@taglib uri="http://java.sun.com/portlet" prefix="portlet" %>
<portlet:defineObjects/>

<%
	PortletSession session = renderRequest.getPortletSession();
	String username = (String)session.getAttribute("test.username");
	List<TestDataBean> list = (List<TestDataBean>)session.getAttribute("test.list");
	int curp = (Integer)session.getAttribute("test.curp");
	int totalPage = (Integer)session.getAttribute("test.totalPage");
	int lastPage = curp - 1;
	int nextPage = curp + 1;
	//System.out.println("username=" + username);
%>

<DIV style="margin: 12px; margin-bottom: 36px">
	<%
		if (username != null) {
	%>
			Hello <%=username %>.<br><span><a href="<portlet:renderURL>
					<portlet:param name="actionflag" value="adduser"/>
					</portlet:renderURL>">add user</a></span>
		<% if(list.size() > 0) { %>
			<table  border="1" width="80%">
			<% for(TestDataBean tdb : list) { %>
				<tr>
					<td width="60%"><a href="#"><%=tdb.getName() %></a></td>
					<td width="50px;"><a href="<portlet:renderURL>
					<portlet:param name="actionflag" value="update"/>
					<portlet:param name="id" value="<%=String.valueOf(tdb.getId()) %>" />
					</portlet:renderURL>">EDIT</a></td>
					<td width="50px;"><a href="<portlet:renderURL>
					<portlet:param name="actionflag" value="delete"/>
					<portlet:param name="id" value="<%=String.valueOf(tdb.getId()) %>" />
					</portlet:renderURL>">DELETE</a></td>
				</tr>
			<% } %>
			</table>
			<% if(curp > 1) { %>
				<span><a href="<portlet:renderURL>
					<portlet:param name="curp" value="<%=String.valueOf(lastPage) %>"/>
					</portlet:renderURL>">last page</a></span>
			<% } else { %>
				<span>last page</span>
			<% } %>
			<% if(curp < totalPage) { %>
				<span><a href="<portlet:renderURL>
					<portlet:param name="curp" value="<%=String.valueOf(nextPage)  %>"/>
					</portlet:renderURL>">next page</a></span>
			<% } else { %>
				<span>next page</span>
			<% } %>
			
		<% } %>
	<%
		}
	%>
	<FORM method="POST" action="<portlet:actionURL/>">
		<INPUT name="username" type="text"/><br>
		<INPUT name="password" type="password"/><br>
		<INPUT name="actionflag" type="submit" value="Submit"/>
	</FORM>
</DIV>

3.数据库处理文件

package com.tortrend.general;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class TestDataDAOImpl {
	private static String DRIVER = "org.gjt.mm.mysql.Driver";
	private static String URL = "jdbc:mysql://127.0.0.1:3307/protal";
	private static String USERNAME = "root";
	private static String PASSWORD = "root";
	private static Connection conn = null;
	private static PreparedStatement pst = null;
	private static ResultSet rs = null;
	
	static {
		try {
			Class.forName(DRIVER);
			conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
	public static List<TestDataBean> getAll() {
		List<TestDataBean> list = new ArrayList<TestDataBean>();
		String sql = "select * from test_data";
		try {
			pst = conn.prepareStatement(sql);
			rs = pst.executeQuery();
			while(rs.next()) {
				TestDataBean tdb = new TestDataBean();
				tdb.setId(rs.getInt("id"));
				tdb.setName(rs.getString("name"));
				tdb.setPassword(rs.getString("password"));
				list.add(tdb);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public static List<TestDataBean> getSome(int page, int pagesize) {
		List<TestDataBean> list = new ArrayList<TestDataBean>();
		String sql = "select * from test_data order by id limit ?,?";
		try {
			pst = conn.prepareStatement(sql);
			pst.setInt(1, (page - 1) * pagesize);
			pst.setInt(2, pagesize);
			rs = pst.executeQuery();
			while(rs.next()) {
				TestDataBean tdb = new TestDataBean();
				tdb.setId(rs.getInt("id"));
				tdb.setName(rs.getString("name"));
				tdb.setPassword(rs.getString("password"));
				list.add(tdb);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public static boolean checkLogin(String name, String password) {
		boolean flag = false;
		String sql = "select name from test_data where name = ? and password = ?";
		try {
			pst = conn.prepareStatement(sql);
			pst.setString(1, name);
			pst.setString(2, password);
			rs = pst.executeQuery();
			if(rs.next()) {
				flag = true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return flag;
	}
	
	public static int getCount() {
		String sql = "select count(*) num from test_data";
		try {
			pst = conn.prepareStatement(sql);
			rs = pst.executeQuery();
			if(rs.next()) {
				return rs.getInt("num");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return 0;
	}
	
	public static void add(TestDataBean tdb) {
		String sql = "insert into test_data values(?, ?, ?)";
		try {
			pst = conn.prepareStatement(sql);
			pst.setInt(1, tdb.getId());
			pst.setString(2, tdb.getName());
			pst.setString(3, tdb.getPassword());
			pst.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void update(int id) {
		String sql = "update test_data set name = ? where id = ?";
		try {
			pst = conn.prepareStatement(sql);
			pst.setString(1, "wgj-update");
			pst.setInt(2, id);
			pst.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void delete(int id) {
		String sql = "delete from test_data where id = ?";
		try {
			pst = conn.prepareStatement(sql);
			pst.setInt(1, id);
			pst.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

分享到：