insert.java

小型简单的旅馆预订系统. 客户:预定,更改,撤销,会员积分累积,查询预定,会员. 后台:会员更改,房间更改,预定更改,预定信息统计.

/*
 * insert.java
 *
 * Created on 2007年8月28日, 上午1:20
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package servlet;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletContext;
import javax.sql.*;

/**
 *
 * @author Administrator
 */
public class insert{
    
    /** Creates a new instance of insert */
	String path;
    public insert() {
    }
    public void conn(String query){
        try{
        	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
        	String driver = "Driver={Microsoft Access Driver (*.mdb)}";
        	String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
        	String connectionString = "jdbc:odbc:"+driver+";"+dbq;
        	Connection conn = DriverManager.getConnection(connectionString);
         Statement stmt = conn.createStatement();
         stmt.executeQuery(query);
         stmt.close();
         conn.close();
        }
        catch (Exception e){
        	System.out.println(e.getCause()+": "+e.getMessage()+": "+e.getStackTrace());
        }
         
       }
    public String getQuery(String query,String colName)
    {
    	String n="0";
    	try{
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
        	String driver = "Driver={Microsoft Access Driver (*.mdb)}";
        	String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
        	String connectionString = "jdbc:odbc:"+driver+";"+dbq;
        	Connection conn = DriverManager.getConnection(connectionString);
            Statement stmt = conn.createStatement();
            ResultSet rs=stmt.executeQuery(query);
            if (rs.next())
            {
            	n=rs.getString(colName);
            }
            rs.close();
            stmt.close();
            conn.close();
           }
           catch (Exception e){
           	System.out.println(e.getCause()+": "+e.getMessage()+": "+e.getStackTrace());
           }
           
    	return n;
    }
/*  public void getQueryArray(String query,String colName)
    {
    	
    	try{
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
			String driver = "Driver={Microsoft Access Driver (*.mdb)}";
			String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
			String connectionString = "jdbc:odbc:" + driver + ";" + dbq;
			Connection conn = DriverManager.getConnection(connectionString);
			Statement stmt;
			stmt = conn.createStatement(
					ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			ResultSet rs = stmt.executeQuery(query);
			ResultSetMetaData   rm=rs.getMetaData(); 
			int colNum=rm.getColumnCount();//get column number
			int rowNum=0;
			int lop=1;
			if (rs.next())
			{
				for (rs.first(); !rs.isAfterLast(); rs.next())
				{
					rowNum++;
				}// get row number
			}
			
			String data[][]=new String[rowNum+1][colNum+1];
			for (int i=0;i<(colNum);i++)
			{
				data[0][i]=rm.getColumnName(i+1);
			}
			for (rs.first();!rs.isAfterLast();rs.next())
			{
				
				for (int i=0;i<(colNum);i++)
				{
							data[lop][i]=rs.getString(i+1);
							
				}
				lop++;
			}
			
			rs.close();
			stmt.close();
			conn.close();
           }
           catch (Exception e){
           	System.out.println(e.getCause()+": "+e.getMessage()+": "+e.getStackTrace());
           }
    	
    }*///:~
   /* public ArrayList getList(String query){
    	List list =new ArrayList();
    	try{
        	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
        	String driver = "Driver={Microsoft Access Driver (*.mdb)}";
        	String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
        	String connectionString = "jdbc:odbc:"+driver+";"+dbq;
        	Connection conn = DriverManager.getConnection(connectionString);
         Statement stmt = conn.createStatement();
         stmt.executeUpdate(query);
         stmt.close();
         conn.close();
        }
        catch (Exception e){
        	System.out.println(e.getCause()+": "+e.getMessage()+": "+e.getStackTrace());
        }
        return list;
    }*/
    public void update(String query){
    	/*@ this is an insert,update,delete execution function
    	 * 
    	 *///:~
        try{
        	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
        	String driver = "Driver={Microsoft Access Driver (*.mdb)}";
        	String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
        	String connectionString = "jdbc:odbc:"+driver+";"+dbq;
        	Connection conn = DriverManager.getConnection(connectionString);
         Statement stmt = conn.createStatement();
         stmt.executeUpdate(query);
         stmt.close();
         conn.close();
        }
        catch (Exception e){
        	System.out.println(e.getCause()+": "+e.getMessage()+": "+e.getStackTrace());
        }
         
       }
	public String getPath()
	{
		return path;
	}
	public void setPath(String path)
	{
		this.path = path;
	}
    
    }