onserver.java

it s a java feil,not very good !

package server;
import java.awt.GridLayout;
import java.awt.TextArea;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
public class onserver extends JFrame implements ActionListener{
	static onserver frm=new onserver();
	static JTextField port,id;
	static JButton bport,bchaxun,bshanchu;
	static TextArea ta=new TextArea();
	
	static String dbdriver="com.mysql.jdbc.Driver";
	static String dburl="jdbc:mysql://localhost:3306/telephone1";
	static String dbuser="root";
	static String dbpassword="000";
	
	static int water;
	static String sid,cnumber,pay,caozuo,dtime,to,last="",sh,end;
	public static void main(String[] args) 
	{
		frm.setTitle("更新查询");
		frm.setSize(700,550);
		port=new JTextField(8);
		id=new JTextField(8);
		
		ta.setEditable(false);
		bport=new JButton("启动服务器");
		bchaxun=new JButton("查询日志");
		bshanchu=new JButton("删除");

		JPanel p1=new JPanel();
		JPanel p2=new JPanel();
		JPanel p3=new JPanel();
		
		p2.add(new JLabel("端口号"));
		p2.add(port);
		p2.add(bport);
		p3.add(new JLabel("职工号"));
		p3.add(id);
		p3.add(bchaxun);
		p3.add(bshanchu);
		
		p1.setLayout(new GridLayout(2,1));
		p1.add(p2);
		p1.add(p3);
		frm.setLayout(new GridLayout(2,1));
		frm.add(p1);
		frm.add(ta);
		bport.addActionListener(frm);
		bchaxun.addActionListener(frm);
		bshanchu.addActionListener(frm);
		frm.addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e){System.exit(0);}});
		frm.setVisible(true);
	}
		public void actionPerformed(ActionEvent e)
		{
			JButton s=(JButton)e.getSource();
			if(s==bport){
				int Port=Integer.parseInt(port.getText().toString().trim());
				try{
				new Server(Port);
				}catch(Exception server){System.out.println(server);}
			}
			if(s==bshanchu){
				try
				  {
					Class.forName(dbdriver);
					Connection conn=DriverManager.getConnection(dburl,dbuser,dbpassword);
					String s1="'"+id.getText().toString().trim()+"'";
				    String sql="delete from diary where sid="+s1;
				    Statement stmt=conn.createStatement();
				    stmt.executeUpdate(sql);
				    stmt.executeUpdate("commit");
				    stmt.close();
				    conn.close();
				  }
				catch(Exception ea){System.out.println(ea);}
			}
			if(s==bchaxun){
				try
				  {
					Class.forName(dbdriver);
					Connection conn=DriverManager.getConnection(dburl,dbuser,dbpassword);
					System.out.println("开始操作");
					String s1="'"+id.getText().toString().trim()+"'";
				    String sql="select * from diary where sid="+s1;
				    Statement stmt=conn.createStatement();
				    ResultSet rs=stmt.executeQuery(sql);
				    String lg="------------------------------------------------------------------------";
				    sh="|"+"\t";
				    to=lg+"\n"+sh+"water"+sh+"sid"+sh+"cnumber"+sh+"pay"+sh+"caozuo"+sh+"dtime"+sh+"\n"+lg+"\n";
				    while(rs.next()){
				    	water=rs.getInt("water");
				    	sid=rs.getString("sid");
				    	cnumber=rs.getString("cnumber");
				    	pay=rs.getString("pay");
				    	caozuo=rs.getString("caozuo");
				    	dtime=rs.getString("dtime");
				    	String W=Integer.toString(water);
				    	last=last+sh+W+sh+sid+sh+cnumber+sh+pay+sh+caozuo+sh+dtime+sh+"\n";
				    }
				    end=to+last+lg+"\n";
				    ta.setText(end);
				  }
				  catch(Exception eh)
				  {System.out.println(eh);}
			}
		}
}