🚀 go-pugleaf

������JB9�ģ���·���Ѿ����ˣ�
.;D:\JBuilder9\jdk1.4\lib\dt.jar;D:\JBuilder9\jdk1.4\lib\tools.jar;D:\JBuild
er9\jdk1.4\jre\lib\rt.jar;D:\JBuilder9\jdk1.4\jre\lib\ext\dnsns.jar;D:\JBuil
der9\jdk1.4\jre\lib\ext\ldapsec.jar;D:\JBuilder9\jdk1.4\jre\lib\ext\localeda
ta.jar;D:\JBuilder9\jdk1.4\jre\lib\ext\sunjce_provider.jar;
�����ڱ���һ�������ǻ����и�����
ava.lang.NoClassDefFoundError: mhcxserver/Application1
Exception in thread "main"
�һ�����.net��ijһ�����Ҳ���������ൽ��Ҫ��ô���أ���
��ԭ����������ˣ����ʱ��û�а��չ淶�࣬�� ��������ô�������˵�ɣ���
package mhcxserver;
//��������
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.io.*;
import java.util.*;
import java.net.*;
import java.sql.*;
import java.text.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
public class mhcxserverframe{
  final int PORT=9090;
  public mhcxserverframe(){
    ServerSocket rServer=null;
    Socket request=null;
    ServerThread receiveThread=null;
    try{
      rServer=new ServerSocket(PORT);      //����һ���������˿���9090
      System.out.println("Now,server is running......");
      while(true){
        request=rServer.accept();        //����һ��SOCKET
        receiveThread=new ServerThread(request);    //������SOCKET���߳�
        receiveThread.start();                     //�����߳�
      }
    }catch(IOException e){
      System.out.println(e.getMessage());
    }
  }
  public static void main(String args[]){
     new mhcxserverframe();
   }
}
   class ServerThread extends Thread{                  //����һ���߳���
     Socket request;
     BufferedReader input;                  //����������
     PrintWriter output;                   //��ӡ�����
     public ServerThread(Socket s) {
       this.request = s;
       InputStreamReader reader;                  //����������
       OutputStreamWriter writer;                    //���������
       try {
         reader = new InputStreamReader(request.getInputStream());
         writer = new OutputStreamWriter(request.getOutputStream());
         input = new BufferedReader(reader);           //�ѵõ���������ת��
         output = new PrintWriter(writer, true);        //�����
       }
       catch (IOException e) {
         System.out.println(e.getMessage());
       }
     }
     public void run() {
       String command = null;
       String str = null;
       String sqlstr = null;
       String temp = null;
       boolean done = false;
       while (!done) {
         try {
           str = input.readLine().trim().toString();
           temp = str;
         }
         catch (IOException e) {
           System.out.println(e.getMessage());
         }
         StringTokenizer result = new StringTokenizer(str, ":");
         command = result.nextToken();                          //�õ�COMMAN
D
         if (str == null || command.equals("QUIT"))
           done = true;
         else
         if (command.equals("REQUESTLOGGIN")) {                    //command
��REQUESTLOGGINִ��
           if (result.hasMoreTokens())
                 sqlstr = result.nextToken();                //�õ�SQL
           System.out.println(sqlstr);
           String answer = null;
           Operate opst = new Operate();
           answer = opst.operatesql1(sqlstr);               //ִ��SQL
           StringBuffer msg = new StringBuffer("MSG:");
           msg.append(answer);
           output.println(msg);          //���ִ�н��
           output.flush();
         }
         else
         if (command.equals("SHOWMESSAGE")) {
           String answer = null;
           Operate opst = new Operate();
           answer = opst.operatesql2();
           StringBuffer msg = new StringBuffer("MSG||");
           msg.append(answer);
           output.println(msg);
           output.flush();
         }
         else
         if (command.equals("CHOOSE")) {
           if (result.hasMoreTokens())
             sqlstr = result.nextToken();
           System.out.println(sqlstr);
           String answer = null;
           Operate opst = new Operate();
           answer = opst.operatesql3(sqlstr);
           StringBuffer msg = new StringBuffer("MSG:");
           msg.append(answer);
           output.println(msg);
           output.flush();
         }
         else
         if (command.equals("MESSAGE")) {
           if (result.hasMoreTokens())
             sqlstr = result.nextToken();
           System.out.println(sqlstr);
           String answer = null;
           Operate opst = new Operate();
           answer = opst.operatesql4(sqlstr);
           StringBuffer msg = new StringBuffer("MSG&");
           msg.append(answer);
           System.out.println(msg);
           output.println(msg);
           output.flush();
         }
         else
         if (command.equals("INFORMATION")) {
           if (result.hasMoreTokens())
             sqlstr = result.nextToken();
           System.out.println(sqlstr);
           String answer = null;
           Operate opst = new Operate();
           answer = opst.operatesql5(sqlstr);
           StringBuffer msg = new StringBuffer("MSG:");
           msg.append(answer);
           System.out.println(msg);
           output.println(msg);
           output.flush();
         }
         else
         if (command.equals("NEWS")) {
           String sqlstr1 = null,sqlstr2=null;
           StringTokenizer rt = new StringTokenizer(temp, "&");
           String head = rt.nextToken();
           if (rt.hasMoreTokens())
             sqlstr1 = rt.nextToken();
           Operate opst1 = new Operate();
           if(rt.hasMoreTokens())
             sqlstr2=rt.nextToken();
           opst1.operatesql6(sqlstr1,sqlstr2);
           }
          else
            if(command.equals("RUQUESTCLIENT")){
              String sqlstr2="";
              if (result.hasMoreTokens())
                sqlstr = result.nextToken();
               if(result.hasMoreTokens())
                 sqlstr2=result.nextToken();
              System.out.println(sqlstr);
              String answer = null;
              Operate opst = new Operate();
              answer = opst.operatesql7(sqlstr,sqlstr2);
              StringBuffer msg = new StringBuffer("MSG&");
              msg.append(answer);
              System.out.println(msg);
              output.println(msg);
              output.flush();
            }
            else
              if(command.equals("CHECK")){
                String sqlstr1="",sqlstr2="",sqlstr3="",sqlstr4="";
                if(result.hasMoreTokens())
                  sqlstr1=result.nextToken();
                if(result.hasMoreTokens())
                  sqlstr2=result.nextToken();
                if(result.hasMoreTokens())
                  sqlstr3=result.nextToken();
                if(result.hasMoreTokens())
                  sqlstr4=result.nextToken();
                System.out.println(sqlstr1);
                System.out.println(sqlstr2);
                System.out.println(sqlstr3);
                System.out.println(sqlstr4);
                Operate opst=new Operate();
                  opst.operatesql8(sqlstr1,sqlstr2,sqlstr3,sqlstr4);
              }
            }
         try {
           request.close();
         }
         catch (IOException e) {
           System.out.println(e.getMessage());
           return;
         }
         command = null;
       }
     }
  class Operate {                    //���������
       String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
       String databaseURL = "jdbc:odbc:mhcx";
       String user = "mhcx";
       String password = "mhcx";
       Operate() {
       }
       public void driver() {
         try {
           Class.forName(driverName);
           System.out.println("�ɹ�����JDBC-ODBC�����");
         }
         catch (java.lang.ClassNotFoundException ex) {
           System.out.println("����JDBC-ODBC�����ʧ��");
           System.out.println(ex.getMessage());
         }
       }               //������
       public String operatesql1(String s) {
         driver();
         String rslt = "";
         try {
           Connection con = DriverManager.getConnection(databaseURL, user,
               password);
           System.out.println("����bjtdb��ݿ�ɹ�");
           Statement stmt = con.createStatement();
           try {
             ResultSet result = stmt.executeQuery(s);
             if (result.next()) {
               String name = result.getString(1);
               rslt = "OK:" + name;
             }
             else
               rslt = "NO";
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
           }
           con.close();
         }
         catch (SQLException ex) {
           System.out.print("����bjtdb��ݿ�ʧ��");
           System.err.println("SQLException:" + ex.getMessage());
         }
         return rslt;
       }                     //������ݿ⣬��ִ��SQL����������Ҫ��ֵ
       public String operatesql2() {
         driver();
         StringBuffer answer = new StringBuffer();
         StringBuffer answer1 = new StringBuffer();
         StringBuffer answer2 = new StringBuffer();
         StringBuffer answer3 = new StringBuffer();
         try {
           Connection con = DriverManager.getConnection(databaseURL, user,
               password);
           System.out.println("����bjtdb��ݿ�ɹ�");
           Statement stmt = con.createStatement();
           String sqlstr = "select * from ����;";
           String sqlstr1 = "select * from ʱ��;";
           try {
             ResultSet result = stmt.executeQuery(sqlstr);
             while (result.next()) {
               String rslt = result.getString(2) + ":";
               String rslt1 = result.getString(3) + ":";
               answer1.append(rslt);
               answer2.append(rslt1);
             }
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
           }
           try {
             ResultSet result = stmt.executeQuery(sqlstr1);
             while (result.next()) {
               String rslt = result.getString(2) + ":";
               answer3.append(rslt);
             }
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
           }
           con.close();
         }
         catch (SQLException ex) {
           System.out.print("����bjtdb��ݿ�ʧ��");
           System.err.println("SQLException:" + ex.getMessage());
         }
         answer.append(answer1);
         answer.append("&&");
         answer.append(answer2);
         answer.append("&&");
         answer.append(answer3);
         return answer.toString();
       }
       public String operatesql3(String sqlstr) {
         StringBuffer answer = new StringBuffer();
         driver();
         try {
           Connection con = DriverManager.getConnection(databaseURL, user,
               password);
           System.out.println("����bjtdb��ݿ�ɹ�");
           Statement stmt = con.createStatement();
           try {
             ResultSet result = stmt.executeQuery(sqlstr);
             while (result.next()) {
               String rslt = result.getString(1) + ":";
               answer.append(rslt);
             }
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
           }
           con.close();
         }
         catch (SQLException ex) {
           System.out.print("����bjtdb��ݿ�ʧ��");
           System.err.println("SQLException:" + ex.getMessage());
         }
         return answer.toString();
       }
       public String operatesql4(String sqlstr) {
         StringBuffer answer = new StringBuffer();
         String index_result, start_result, end_result, time_result;
         int big_result, bigleave_result, bigmoney_result, small_result,
             smallleave_result, smallmoney_result;
         driver();
         try {
           Connection con = DriverManager.getConnection(databaseURL, user,
               password);
           System.out.println("����bjtdb��ݿ�ɹ�");
           Statement stmt = con.createStatement();
           try {
             ResultSet result = stmt.executeQuery(sqlstr);
             while (result.next()) {
               index_result = result.getString(1) + "&";
               answer.append(index_result);
               start_result = result.getString(2) + "&";
               answer.append(start_result);
               end_result = result.getString(3) + "&";
               answer.append(end_result);
               time_result = result.getTimestamp(4).toString() + "&";
               answer.append(time_result);
               big_result = result.getInt(5);
               answer.append(big_result);
               answer.append("&");
               bigleave_result = result.getInt(6);
               answer.append(bigleave_result);
               answer.append("&");
               bigmoney_result = result.getInt(7);
               answer.append(bigmoney_result);
               answer.append("&");
               small_result = result.getInt(8);
               answer.append(small_result);
               answer.append("&");
               smallleave_result = result.getInt(9);
               answer.append(smallleave_result);
               answer.append("&");
               smallmoney_result = result.getInt(10);
               answer.append(smallmoney_result);
             }
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
           }
           con.close();
         }
         catch (SQLException ex) {
           System.out.print("����bjtdb��ݿ�ʧ��");
           System.err.println("SQLException:" + ex.getMessage());
         }
         return answer.toString();
       }
       public String operatesql5(String strall) {
         String seat_name = "", flight_name = "";
         String tempseat = "";
         String sqlstrnew2 = "", sqlstr11 = "", sqlstr = "";
         int seat_number = 1, temp_number = 1;
         StringTokenizer results = new StringTokenizer(strall, "&");
         StringBuffer answer = new StringBuffer();
         sqlstr = results.nextToken();
         if (results.hasMoreTokens())
           temp_number = Integer.parseInt(results.nextToken());
         seat_number = temp_number;
         if (results.hasMoreTokens())
           flight_name = results.nextToken();
         if (results.hasMoreTokens())
           sqlstrnew2 = results.nextToken();
         Vector myvector = new Vector();
         driver();
         try {
           Connection con = DriverManager.getConnection(databaseURL, user,
               password);
           System.out.print("����bjtdb��ݿ�ɹ�");
           Statement stmt = con.createStatement();
           try {
             ResultSet result = stmt.executeQuery(sqlstr);
             String temp;
             while (result.next() && result.getBoolean(3) == true) {
               temp = result.getString(2);
             }
             seat_name = result.getString(2);
             tempseat = tempseat + seat_name;
             myvector.addElement(seat_name);
             while (result.next() && seat_number > 1) {
               seat_name = result.getString(2);
               tempseat = tempseat + "||" + seat_name;
               myvector.addElement(seat_name);
               seat_number--;
             }
             answer.append(tempseat);
             int i = temp_number;
             while (i >= 1) {
               i--;
               seat_name = myvector.elementAt(i).toString();
               System.out.println(seat_name + "dfdf");
               String sqlstrnew1 = "update ���" + flight_name +
                   " set Ԥ��=true where ��λ��='" + seat_name + "';";
               int no = stmt.executeUpdate(sqlstrnew1);
             }
             int no1 = stmt.executeUpdate(sqlstrnew2);
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
           }
           con.close();
         }
         catch (SQLException ex) {
           System.out.print("������ݿ�ʧ��");
           System.err.println("SQLException:" + ex.getMessage());
         }
         return answer.toString();
       }
       public int  operatesql6(String sqlstr,String sqlstrs) {
         driver();
         try {
           System.out.print(sqlstr);
           Connection con = DriverManager.getConnection(databaseURL, user,
               password);
           System.out.print("����bjtdb��ݿ�ɹ�");
           Statement stmt = con.createStatement();
           try {
             int no2 = stmt.executeUpdate(sqlstr);
             int no3=stmt.executeUpdate(sqlstrs);
           }
           catch (SQLException ex) {
             System.out.println("��ѯ��ݿ����ʧ��!");
             System.err.println("SQLException:" + ex.getMessage());
             return 0 ;
           }
           con.close();
         }
         catch (SQLException ex) {
           System.out.print("������ݿ�ʧ��");
           System.err.println("SQLException:" + ex.getMessage());
           return 0;
         }
         return 0;
       }
      public String operatesql7(String sqlstr,String sqlstr2){
         String tab_name,seat_name,flight_name,name_name,
        age_name,sex_name,start_name,end_name,time_name,ID_name,allmoney_nam
e,take="";;
        StringBuffer answer=new StringBuffer();
        boolean taketicket=false;
        driver();
         try{
           Connection con=DriverManager.getConnection(databaseURL,user,passw
ord);
           Statement stmt=con.createStatement();
           try{
             ResultSet result=stmt.executeQuery(sqlstr);
             if(result.next()){
               String name=result.getString(1)+"&";
               answer.append(name);
               flight_name=result.getString(3)+"&";
               answer.append(flight_name);
               seat_name=result.getString(4)+"&";
               answer.append(seat_name);
               name_name=result.getString(5)+"&";
               answer.append(name_name);
               age_name=result.getString(6)+"&";
               answer.append(age_name);
               sex_name=result.getString(7)+"&";
               answer.append(sex_name);
               ID_name=result.getString(8)+"&";
               answer.append(ID_name);
               start_name=result.getString(9)+"&";
               answer.append(start_name);
               end_name=result.getString(10)+"&";
               answer.append(end_name);
               time_name=result.getString(11)+"&";
               answer.append(time_name);
               allmoney_name=result.getString(14)+"&";
               answer.append(allmoney_name);
             }
             ResultSet result2=stmt.executeQuery(sqlstr2);
             if(result2.next())
               taketicket=result2.getBoolean(4);
            if(taketicket==false)
               take="false";
            if(taketicket==true)
              take="true";
             answer.append(take);
             System.out.println("Ʊ"+take);
             }catch(SQLException ex){
         System.out.print("��ѯʧ��");
         con.close();
       }
     }catch(SQLException ex){
       System.out.print("������ݿ����");
     }
     return answer.toString();
   }
    public void operatesql8(String sqlstr1,String sqlstr2,String sqlstr3,Str
ing sqlstr4){
      driver();
      try{
          Connection con=DriverManager.getConnection(databaseURL,user,passwo
rd);
          Statement stmt=con.createStatement();
          try{
            int no1 =stmt.executeUpdate(sqlstr1);
            int no2=stmt.executeUpdate(sqlstr2);
            int no4=stmt.executeUpdate(sqlstr4);
            int no3=stmt.executeUpdate(sqlstr3);
            }catch(SQLException ex){
        System.out.print("����ʧ��");
        con.close();
      }
      con.close();
    }catch(SQLException ex){
      System.out.print("������ݿ����");
    }
  }
}


--
���Ǹ���ì�ܵ��ˣ���ĺ�ì�ܡ�����ʱ�������һ���£�������ʱ���ֻ��ϲ���Ǽ��
��ͬ���¡�
����ʱ�ֺܸ���ḻ�ɣ��һ�Ϊ��С����������Ҳ��Ϊ��С����������ơ�
���� ���� ���� ���� ���� ���� ��- ���� ���� ���� ���� ���� ���� ���� ���� ����
--I LOVE @^her^@
--I LOVE @^Linux^@

�� ��Դ:��Ʈ��ˮ�Ƽ� Freecity.dhs.org��[FROM: BEZY]