addplanecomno.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 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 AddPlaneComNo {
    DbConnection db=null;
    Connection con=null;
	/**航空公司的名称*/
	public String flightComName;

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

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

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

	public int addSqlExecute() {
		
		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;
		s1 = "INSERT INTO flightcom (fno,fcom,insert_date,update_date) ";
		s2 = "VALUES (" + flightNo + "," + flightComName + ","+insert_date+","+update_date+")";
		/**数据库的主机地址*/
		//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);
            db=new DbConnection();
            con=db.getCon();
			sql = con.createStatement();
			sql.executeUpdate(s1 + s2);
			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;
		}
	}
}