modifyplanecomno.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.SQLException;
import java.sql.Statement;

import zhangchunliang.model.AppMode;
import ddl.form.SelectInfoForm;

/**
 * @author duzhibo@neusoft
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */

public class ModifyPlaneComNo {
	/** 航空公司的名称 */
	public String flightComName;

	/** 航班的编号 */
	public String flightNo;

	/** 用户插入数据的时间 */
	public String insert_date;

	/** 用户更新数据的时间 */
	public String update_date;

	public String change(String s) {
		String str = s;
		try {
			byte b[] = str.getBytes("ISO-8859-1");
			str = new String(b);
			return str;
		} catch (Exception e) {
			return str;
		}
	}

	public String[] ModifyView(SelectInfoForm sif) {
		
		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();
		/** 获得FORM里的参数 */
		SelectInfoForm selectInfoForm = sif;
		Connection con = null;
		Statement sql = null;
		ResultSet rs = null;
		String fno = null;
		fno = change(selectInfoForm.getFno());
		String str[] = { "null", "null" };
		try {
			con = DriverManager.getConnection(conmysql);
			sql = con.createStatement();
			String condition = "select * from flightcom where fno='" + fno
					+ "'";
			rs = sql.executeQuery(condition);
			rs.first();
			fno = rs.getString(1);
			str[0] = fno;
			String fcom = rs.getString(2);
			str[1] = fcom;
			con.close();
			AppMode.loginoutUser();
			return str;
		} catch (SQLException e) {
			
			AppMode.loginoutUser();
			
			System.out.print(e);
			return str;
		}
	}

	public int modifySqlExecute() {
		
		AppMode.registerUser();
		
		/** 定义一个StringBuffer来对数据库操作的信息进行存储 */
		StringBuffer str = new StringBuffer();
		/** 连接数据库所要应用的变量 */
		Connection con;
		/** 执行Sql语句的时候所需要的变量 */
		Statement sql;
		/** Sql语句查询之后所需要的结果集对象 */
		ResultSet set;
		/** SQL语句的前半部分 */
		String s1;
		/** SQL语句的后半部分 */
		String s2;
		/** 连接数据库驱动参数 */
		String driver;
		/** 数据库主机地址 */
		String driverHost;
		/** 用户名及密码 */
		String driverInfo;
		/** 数据编码格式 */
		String driverCode;
		/** sql的前面半句 */
		s1 = "UPDATE flightcom SET fcom=";
		/** 的后面半句 */
		s2 = "WHERE fno=";
		/** 数据库的主机地址 */
		driverHost = "jdbc:mysql://192.168.219.148/ciqms";
		/** 数据库的用户名和密码 */
		driverInfo = "user=root&password=elite";
		/** 访问数据库的编码格式 */
		driverCode = "useUnicode=true&characterEncoding=gbk";
		driver = driverHost + "?" + driverInfo + "&" + driverCode;
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
		} catch (Exception e) {
			System.out.println(e.getMessage());
			return 6;
		}

		try {
			con = DriverManager.getConnection(driver);
			sql = con.createStatement();
			sql.executeUpdate(s1 + flightComName+",update_date="+update_date + s2 + flightNo);
			System.out.println(s1 + flightComName+",update_date="+update_date + s2 + flightNo);
			AppMode.loginoutUser();
            return 1;
		} catch (SQLException e) {
			
			AppMode.loginoutUser();
			
			System.out.println(driver);
			System.out.println("your Sql is wrong!");
			System.out.println(e);
			return 7;
		}
	}
}