selectcontrol.java

一个javaweb开的小例子

package cn.com.pkusoft.control.select;

import cn.com.pkusoft.control.*;
import java.util.Collections;
import java.sql.Connection;
import java.sql.Statement;
import java.util.List;
import java.sql.ResultSet;
import cn.com.pkusoft.entity.ConnectionFactory;
import java.sql.SQLException;
import java.util.ArrayList;
import cn.com.pkusoft.entity.dao.T_Dp_User_Dao;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;



public class SelectControl extends BaseControl
{
    public SelectControl()
    {
    }
    public void doInit()
    {
	/**@todo Implement this cn.com.pkusoft.control.BaseControl abstract method*/
    }

	public List prepareUser()
   {
	   //模拟一段数据处理代码，真实情况下应该是从数据库中取数据或者别的。

	  /* try
	   {
		   Connection conn = ConnectionFactory.getStaticInstance().getConnection();

		   Statement stmt = conn.createStatement(java.sql.ResultSet.
												 TYPE_SCROLL_INSENSITIVE,
												 java.sql.ResultSet.CONCUR_READ_ONLY);

		   String strSql = "SELECT MANTECHNUM, REGIMANNUM, TECHNUM, SKILLED, LASTTIME, REMARK FROM DP_MANTECH";
		   ResultSet rs = stmt.executeQuery(strSql);

		   while (rs.next())
		   {
			   String str = rs.getString("MANTECHNUM");
			   System.out.println("str is " + str);
		   }
	   }
	   catch (SQLException ex)
	   {
		   System.out.println("cann't get the connection! ");
	   }

	   List userList = new ArrayList();

	   userList = new ArrayList();
	   userList.add("tom");
	   userList.add("jack");
	   userList.add("zhuhp");
	   userList.add("panjin");*/
	   String loginnameTemp = "'tanglijun'";
	   String loginname = "LOGINNAME = " + loginnameTemp;
	   //String loginname = "xyh";
		T_Dp_User_Dao dpuser = new T_Dp_User_Dao();



		List list = null;
		try
		{
			list = dpuser.select(loginname);

		}
		catch(java.sql.SQLException e)
		{
			System.out.println("SelectControl-----SQLException" + e.getMessage());
		}
		catch(Exception e)
		{
			System.out.println("SelectControl-----Exception"+ e.getMessage());
		}

	   return list;
   }


}