testdata.java

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

package servlet;
import java.sql.*;
import java.util.Set;
import java.math.*;

import javax.servlet.*;
import javax.sql.*;
public class testData
{
	/**
	 * @param args
	 */
	
	public static void main(String[] args)
	{
		userBean uber=new userBean();
		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();
            

            String name="yilying";
            String password="850402";
            String sco="0";
            int sc=0;
            String query = "SELECT * FROM Room;";
            ResultSet rs = stmt.executeQuery(query);
            if (rs.next()) {
                if (rs.getString("password").equals(password)) 
                {
                    uber.setUsername(name);
                    uber.setFname(rs.getString("fname"));
                    uber.setLname(rs.getString("lname"));
                    uber.setGender(rs.getString("gender"));
                    uber.setDob(rs.getString("dob"));
                    uber.setEmail(rs.getString("email"));
                    uber.setAdd(rs.getString("address"));
                    uber.setTel(rs.getString("tel"));
                    uber.setId(rs.getString("ID"));
                    String type=rs.getString("type");
                    uber.setType(type);
                    sco=rs.getString("score");
                    sc=Integer.valueOf(sco);
                    uber.setScore(sco);
                    uber.setMessage("Success");
                    if (sc>0 && sc<100)
                    {
                    	uber.setDiscount("1.0");
                    }
                    else if (sc>=100 && sc<300)
                    {
                    	uber.setDiscount("0.95");
                    }
                    else if (sc>=300 && sc<500)
                    {
                    	uber.setDiscount("0.90");
                    }
                    else if (sc>=500 && sc<1000)
                    {
                    	uber.setDiscount("0.85");
                    }
                    else if (sc>=1000 && sc<1500)
                    {
                    	uber.setDiscount("0.80");
                    }
                    else uber.setDiscount("0.78");

                    if (type.equals("0"))
                    {
                    	System.out.println(type+" | "+sc);
                    }
                    else
                    {
                    	System.out.println(type);
                    }
                } else {
                    uber.setMessage("Incorrect password");
                    System.out.println("I P");
                }
            } else {
                uber.setMessage("No such user");
                System.out.println("N S U");
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException e)
        {
        	
        	e.printStackTrace();
        }
        catch (Exception e) {
        	System.out.println("Error!:  "+e.getCause()+"  |  "+e.getStackTrace()+"  |  "+e.getMessage());
        }
        
	         
	}

}