fcomdraw.java

eclipse java/jsp 航空管理系统

/*
 * Created on 2005-4-20
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package ddl.model;

import java.sql.Connection;
//import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import zhangchunliang.model.AppMode;
import kangyi.ConnectionPool.DbConnection;
/**
 * @author duzhibo@neusoft
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class FcomDraw {
    DbConnection db=null;
    Connection con=null;
	/** 构造方法连接数据库 */
	//public FcomDraw() {
	//	try {
		//	Class.forName("com.mysql.jdbc.Driver");
		//} catch (ClassNotFoundException e) {
		//	e.getMessage();
	//	}
	//}

	/**
	 * 动态下拉列表的方法
	 * 
	 * @return StringBuffer中为存放所有国家的下拉列表
	 */
	public StringBuffer fcomAddDraw() {
		
		AppMode.registerUser();
		
		//StringBuffer conSql = new StringBuffer(500);
		//conSql.append("jdbc:mysql://192.168.219.148/ciqms?user=");
		//conSql.append("ddl");
		//conSql.append("&password=");
		//conSql.append("223754301809");
		//conSql.append("&useUnicode=true&characterEncoding=GBK");
		//String conmysql = conSql.toString();
		//Connection con = null;
		Statement sql = null;
		ResultSet rs = null;
		/** 存放返回结果的 StringBuffer */
		StringBuffer str = new StringBuffer();
		str.append("<select name=\"flightComName\">");
		try {
			//con = DriverManager.getConnection(conmysql);
            db=new DbConnection();
            con=db.getCon();
			sql = con.createStatement();
			/** 选择出所有的国家名称 */
			rs = sql.executeQuery("SELECT distinct fcom from flightcom");
			while (rs.next()) {
				str.append("<option value=\"");
				/** 每个航空公司在下拉列表中的值 */
				str.append(rs.getString(1));
				str.append("\">");
				/** 显示在JSP上的国家名字 */
				str.append(rs.getString(1));
			}
			str.append("</select>");
			con.close();
			
			AppMode.loginoutUser();
			
			return str;
		} catch (Exception e) {
			
			AppMode.loginoutUser();
			
			/** 如果出现异常返回新的字符串 */
			return new StringBuffer("无法建立连接" + e);
		}
	}
}