zhanjiangbean.java

利用jsp

/*
 * Created on 2008-3-10
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ibm.j2ee.zhanjiang.bean;

/**
 * @author J2EE
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
 * @author J2EE
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class zhanjiangBean implements Serializable {
		private String des;
		/**
		 * 
		 */
		public zhanjiangBean() {
			super();
			// TODO Auto-generated constructor stub
		}
		public void getDes( String ID ){

			Conn.DBConnect();
			String query;

			try {
						
				if( ID == null )
					query = new String("SELECT * FROM zjTravel WHERE ID = 'zhanjiang_cunjin'");
				else
					query = new String("SELECT * FROM zjTravel WHERE ID = '"+ID+"'");
	
				Statement PS = Conn.getConnection().createStatement();
				
	
				rs = PS.executeQuery(query);
	
			}catch (SQLException e) {
				e.printStackTrace();
			}
		}
		/**
		 * @return
		 */
		public String getDes() {
			return des;
		}


		/**
		 * @param string
		 */
		public void setDes(String string) {
			des = string;
		}

	
		public ResultSet getRs(){
			return rs;
		}
		private DBConnection Conn = new DBConnection();
		private ResultSet rs;
		/**
		 * @return
		 */
		public DBConnection getConn() {
			return Conn;
		}

		/**
		 * @param connection
		 */
		public void setConn(DBConnection connection) {
			Conn = connection;
		}


}