newbean.java

JAVA的好书,大家快来下载呀.斑竹给我点积分好么

/*
 * 创建日期 2005-7-24
 *
 * 更改所生成文件模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
package servlets;
import java.util.*;
import java.util.HashMap;
import java.sql.*;
import javax.servlet.http.HttpServletRequest;
//import javax.servlet.*;
import javax.servlet.http.*;
/**
 * @author Administrator
 *
 * 更改所生成类型注释的模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
public class newbean implements TestInter
{
	/* （非 Javadoc）
	 * @see servlets.TestInter#findListData(javax.servlet.http.HttpServletRequest)
	 */
	public HashMap findListData(HttpServletRequest request)
	{
		
//		OmPreparedQuery db = new OmPreparedQuery();
//		
//		String name = request.getParameter("name");
//		String pass = request.getParameter("pass");
//		String SQL = "";
//		SQL = "";
//		SQL += " SELECT * FROM USERS 	";
//		SQL += "    WHERE 					";
//		SQL += " 			NAME   = '" + name + "'	 ";
//		SQL += " 		AND PASSWORD = '" + pass + "'	 ";
//		System.out.print("5555555555555555555555");
//		try
//		{
//			db.setConnectDataBase();
//			ResultSet rs = db.executeQuery(SQL);
//			if (rs.next())
//			{
//				HttpSession session = request.getSession();
//				session.setAttribute("name", name);
//			}
//		}
//		catch (Exception e)
//		{
//			System.out.println("有异常：" + e.getMessage());
//		}

		String userName = request.getParameter("name");
		String password = request.getParameter("pass");

		String sql = "";
		sql = " SELECT JIBIE FROM USERS WHERE NAMES = '" + userName + "' AND PASSWORD = '" + password + "'";
		String jibie = "";
		OmPreparedQuery db = new OmPreparedQuery();
		try
		{
			db.setConnectDataBase();
			ResultSet rs = db.executeQuery(sql);
			System.out.println(sql);
			while(rs.next())
			{
				jibie = rs.getString("JIBIE");
			}
		}
		catch(Exception e)
		{
		}
		
		sql  = "";
		sql += " SELECT ";
		sql += " MOKUAI_NAME, ";
		sql += " URL ";
		sql += " FROM MOKUAI ";
		sql += " WHERE ";
		
//		sql ="";
//		sql+="SELECT MOKID,UPDATES,DELETES,INSERTS,MOKUAI_NAME,URL FROM QX,MOKUAI";
//		sql+=" WHERE QX.NAMES='"+userName+"'AND QX.MOKID=MOKUAI.MOKUAI_ID and   ";
		if(jibie.equals("1"))
		{
			sql += " JIBIE1 = '1'";
		}
		else if(jibie.equals("2"))
		{
			sql += " JIBIE2 = '1'";
		}
		else if(jibie.equals("3"))
		{
			sql += " JIBIE3 = '1'";
		}

		List resultList = new ArrayList();
		HttpSession session=request.getSession();
		try
		{
			ResultSet rss = db.executeQuery(sql);
			System.out.println(sql);
			while(rss.next())
			{
				
				SetNum num = new SetNum();
				
				num.setName(rss.getString("MOKUAI_NAME"));
				System.out.println("===================================.>" + num.getName());
				num.setUrl(rss.getString("URL"));
				System.out.println("-----------------------------------"+num.getUrl());
				resultList.add(num);
//				String ID=rss.getString("MOKID");
//			
//				session.setAttribute(ID+"insert",rss.getString("INSERT"));
//				session.setAttribute(ID+"update",rss.getString("UPDATE"));
//				session.setAttribute(ID+"DELETE",rss.getString("DELETE"));
//				
				
			}
			System.out.println(sql);
		}
		
		catch(Exception e)
		{
		}

		db.closeAll();
		
		HashMap hashMap = new HashMap();
		hashMap.put("resultList",resultList);
		System.out.print("qqqqqqqqqqqqqqqqqqqqqqqqqqq"+resultList);
		return hashMap;
	}
	/* （非 Javadoc）
	 * @see servlets.TestInter#findOneData(javax.servlet.http.HttpServletRequest)
	 */
	public HashMap findOneData(HttpServletRequest request)
	{
		OmPreparedQuery db=new OmPreparedQuery();
		
		String biaoti=request.getParameter("biaoti");
		String SQL="";
		SQL="";
		SQL+=" select * from FLOWS ";
		SQL+=" where ";
		SQL+=" TITLE like '%"+biaoti+"'%";
		try
		{
			db.setConnectDataBase();
			ResultSet rs=db.executeQuery(SQL);
			if(rs.next())
			{
				HttpSession session=request.getSession();
				session.setAttribute("rs",rs);
			}
			
		}
		catch(Exception e)
		{
			System.out.println("有异常:"+e.getMessage());
		}
		return null;
	}
	/* （非 Javadoc）
	 * @see servlets.TestInter#insertData(javax.servlet.http.HttpServletRequest)
	 */
	public HashMap insertData(HttpServletRequest request)
	{
		OmPreparedQuery db=new OmPreparedQuery();
		
		String biaoti=request.getParameter("text1");
		String content=request.getParameter("text3");
		String fujian=request.getParameter("text4");
		String sendto=request.getParameter("text2");
		String sendfrom=request.getParameter("text6");
		String sql="";
		sql="";
		sql+=" insert into FLOWS(TITLE,CONTENT,FUJIAN,SENDTO,SENDFROM) ";
		sql+="  values('"+biaoti+"','"+content+"','"+fujian+"','"+sendto+"','"+sendfrom+"')";
		try
		{
			db.setConnectDataBase();
			db.executeInsert(sql);
			System.out.println("777777777777777777777");	
			
		}
		catch(Exception e)
		{
			System.out.println("出现异常:"+e.getMessage());
		}
		
		
		return null;
	}
	/* （非 Javadoc）
	 * @see servlets.TestInter#updateData(javax.servlet.http.HttpServletRequest)
	 */
	public HashMap updateData(HttpServletRequest request)
	{
		// TODO 自动生成方法存根
		return null;
	}
	/* （非 Javadoc）
	 * @see servlets.TestInter#deleteData(javax.servlet.http.HttpServletRequest)
	 */
	public HashMap deleteData(HttpServletRequest request)
	{
		// TODO 自动生成方法存根
		return null;
	}
}