package?client;

import?java.applet.applet;
import?java.awt.Button;
import?java.awt.Checkbox;
import?java.awt.CheckboxGroup;
import?java.awt.Choice;
import?java.awt.Color;
import?java.awt.Font;
import?java.awt.Label;
import?java.awt.Panel;
import?java.awt.TextArea;
import?java.awt.TextField;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.io.DataInputStream;
import?java.io.DataOutputStream;
import?java.io.IOException;
import?java.net.InetAddress;
import?java.net.Socket;

public?class?DatabaseClient?extends?applet?implements?RunnableActionListener{
????String?formName;???//數據庫表名
????TextField?輸入查詢內容;
????Choice?choice;
????Checkbox?完全一致前方一致后方一致中間包含;
????CheckboxGroup?group=null;
????Button?查詢;
????TextArea?顯示查詢結果;
????Label?提示條;
????Socket?socket=null;
????DataOutputStream?out=null;
????DataInputStream?in=null;
????Thread?thread;
????boolean?ok=false;
????int?N=0;??//字段個數
????String?[]ziduanName;	//字段名字
????String?[]ziduanExplain;	//存放字段解釋的數組
????public?void?init（）{
????	thread?=?new?Thread（this）;
????	輸入查詢內容=new?TextField（19）;
????	查詢=new?Button（“查詢“）;
????	choice=new?Choice（）;
????	formName=getParameter（“0“）;	//從index.html得到“0”的值
????	String?number=getParameter（“ziduanAmount“）;
????	N=Integer.parseInt（number）;
????	ziduanName=new?String[N];
????	ziduanExplain=new?String[N];
????	for（int?i=1k=0;i<=N;i++k++）{
????		String?str=getParameter（““+i）;??//從index。html得到字段名稱以及解釋
????		ziduanName[k]=str.substring（0str.indexOf（“:“））.trim（）;
????		ziduanExplain[k]=str.substring（str.indexOf（“:“）+1）.trim（）;
????	}
????	for（int?k=0;k????		choice.add（ziduanExplain[k]）;
????	}
????	choice.select（0）;
????	group=new?CheckboxGroup（）;
????	完全一致=new?Checkbox（“完全一致“truegroup）;
????	前方一致=new?Checkbox（“前方一致“falsegroup）;
????	后方一致=new?Checkbox（“后方一致“falsegroup）;
????	中間包含=new?Checkbox（“中間包含“falsegroup）;
????	顯示查詢結果=new?TextArea（843）;
????	提示條=new?Label（“正在連接服務器，請稍后...“Label.CENTER）;
????	提示條.setForeground（Color.red）;
????	提示條.setFont（new?Font（“TimesRoman“Font.BOLD24））;
????	Panel??box1=new?Panel（）;
????	box1.add（new?Label（“輸入查詢內容：“Label.CENTER））;
????	box1.add（輸入查詢內容）;
????	box1.add（choice）;
????	box1.add（查詢）;
????	Panel?box2=new?Panel（）;
????	box2.add（new?Label（“選擇查詢條件：“Label.CENTER））;
????	box2.add（完全一致）;
????	box2.add（前方一致）;
????	box2.add（后方一致）;
????	box2.add（中間包含）;
????	Panel?box3=new?Panel（）;
????	box3.add（new?Label（“查詢結果：“Label.CENTER））;
????	box3.add（顯示查詢結果）;
????	add（提示條）;
????	add（box1）;
????	add（box2）;
????	add（box3）;
????	查詢.addActionListener（this）;
????	setBackground（Color.cyan）;
????}
????public?void?start（）{
????	ok=true;
????	if（socket!=null&&in!=null&&out!=null）{
????		try{
????			socket.close（）;
????			in.close（）;
????			out.close（）;
????		}catch（Exception?ee）{}
????	}
????	try{
????		socket=new?Socket（this.getCodebase（）.getHost（）6666）;
????		in=new?DataInputStream（socket.g