jiaqhao.java

通过网页与服务器通信 客户端是嵌入网页的java小程序,服务器是独立运行的java程序,通过odbc连接access数据库,有聊天记录功能

import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
public class JiaQhao extends JFrame implements ActionListener
{
	Connection con;
	Statement sql;
	ResultSet rs;
	JTextField qhao,nichen;
	JTextArea shuchu;
	JButton zengjia,shuaxin;
	JLabel xinxi;
	public JiaQhao(String bt){
		super(bt);
		setSize(500,500);
		qhao=new JTextField(10);
		nichen=new JTextField(12);
		shuaxin=new JButton("刷新");
		zengjia=new JButton("增加");
		xinxi=new JLabel();
		shuchu=new JTextArea(20,100);
		shuchu.setEditable(false);
		shuchu.setLineWrap(true);
		try {
		con=DriverManager.getConnection("jdbc:odbc:qqhao","alan","");
		sql=con.createStatement();
		}catch(SQLException e1){xinxi.setText(e1.toString());}
		
		JPanel p1,p2;
		p1=new JPanel();
		p2=new JPanel(new BorderLayout());
		p1.add(qhao);
		p1.add(nichen);
		p1.add(zengjia);
		p2.add(xinxi,BorderLayout.CENTER);
		p2.add(shuaxin,BorderLayout.EAST);
		getContentPane().add(p1,BorderLayout.NORTH);
		getContentPane().add(new JScrollPane(shuchu),BorderLayout.CENTER);
		getContentPane().add(p2,BorderLayout.SOUTH);
		zengjia.addActionListener(this);
		shuaxin.addActionListener(this);
		setVisible(true);
		validate();
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		addWindowListener(new WindowAdapter()
	{
		public void windowClosing(WindowEvent e4)
		{
			try{
				sql.close();
				con.close();
				System.exit(0);
   		}catch(Exception e)
     	{
     	}
	}
	});
	}
	
	public void actionPerformed(ActionEvent a2)
	{
		if(a2.getSource()==shuaxin)
		{
			try{
			rs=sql.executeQuery("SELECT * FROM qq");
			shuchu.setText("");
			while(rs.next())
			{
				shuchu.append(rs.getString("qhao")+"			"+rs.getString("nichen")+"\n");
			}
		}catch(Exception e2){xinxi.setText(e2.toString());}
		}
		
		else if(a2.getSource()==zengjia)
		{
			String q1=qhao.getText().trim();
			String n1=nichen.getText();
			if(q1.equals("")||n1.equals("")){return;}
			String sql1="insert into qq values('"+q1+"','"+n1+"');";
			String sql2="create table "+q1+" (ID counter(1,1) not null primary key,"+q1+"date varchar(50),	"+q1+"log memo );";
			try{
			sql.execute(sql2);
			sql.executeUpdate(sql1);
			qhao.setText("");
			nichen.setText("");
		}catch(Exception e3){xinxi.setText(e3.toString());}
		shuaxin.doClick(40);
		}
	}
	public static void main(String arg[])
	{
		JiaQhao jia=new JiaQhao("增加增加...");
	}
}