import java.util.*;
import java.sql.*;
import java.io.*;
import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;

public class MyAccess extends JFrame implements ActionListener,ListSelectionListener
{
 private static Connection conn;
 private static Statement comm;
 private static ResultSet rs;
 private  static int total=0,k=10,row=0,i=0;
 JLabel jl,jl2;
 JTable jt;
 JTextField jid,jname,jscore,se;
 static JButton go,add,drop,del,jbse,flush;
 JFrame jf;
 JScrollPane s;
 Vector vect=new Vector();
 String[] data = {"学号=","学号>","学号<", "姓名=", "分数=","分数>=","分数<"};
  JComboBox dataList = new JComboBox(data);
 String[] columnNames = {"学号","姓名","分数"};
 AbstractTableModel tm = new AbstractTableModel()
  {
          public int getColumnCount(){ return 3;}
          public int getRowCount(){ return k;}
          public Object getValueAt(int row, int col){ return ((Vector)vect.get(row)).get(col); }
          public String getColumnName(int column){    return columnNames[column];   }
      };
 
 public MyAccess()
 {
  jf=new JFrame("考感学院04¾U§JAVA成ç‡W½Ž¡ç†¾pȝ»Ÿ");
  jf.setSize(490,570);
  jf.locate(200,200);
  jf.setResizable(false);
  jf.getContentPane().setLayout(new FlowLayout()); 
  jl=new JLabel("考感学院04¾U§JAVA成ç‡W");
  jid=new JTextField(6);
  jname=new JTextField(5);
  jscore=new JTextField(3);
  se=new JTextField(9);
  go=new JButton("分数(�>�");
  go.addActionListener(this);
  add=new JButton("æ·ÕdŠ ");
  add.addActionListener(this);
  drop=new JButton("修改");
  drop.addActionListener(this);
  del=new JButton("删除");
  del.addActionListener(this);
  jbse=new JButton("搜烦");
  jbse.addActionListener(this);
  flush=new JButton("åˆäh–°");
  flush.addActionListener(this);
  jl2=new JLabel("");
  jl2.setForeground(Color.red);
  jf.getContentPane().add(jl);
  jt=new JTable(tm);
  jt.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
  this.jt.getSelectionModel().addListSelectionListener(this);

  
  
  s = new JScrollPane(jt);  
  jf.getContentPane().add(s);
  jf.getContentPane().add(new JLabel("学号:"));
  jf.getContentPane().add(jid);
  jf.getContentPane().add(new JLabel("姓名:"));
  jf.getContentPane().add(jname);
  jf.getContentPane().add(new JLabel("分数:"));
  jf.getContentPane().add(jscore);
  jf.getContentPane().add(add);
  jf.getContentPane().add(drop);
  jf.getContentPane().add(del);
  jf.getContentPane().add(new JLabel("搜烦学生:"));
  jf.getContentPane().add(dataList);
  jf.getContentPane().add(se);
  jf.getContentPane().add(jbse);
  jf.getContentPane().add(flush);
  jf.getContentPane().add(go);
  jf.getContentPane().add(jl2);
  
 }
public void exce(String exce)
{
 try
 { this.jt.getSelectionModel().removeListSelectionListener(this);
  rs = execQuery(exce);
  vect.removeAllElements();
  tm.fireTableDataChanged();
  total=0;
  while(rs.next())
  { 
   Vector rec_vector=new Vector();
   rec_vector.addElement(rs.getString(1));
   rec_vector.addElement(rs.getString(2));
   rec_vector.addElement(rs.getString(3));
   vect.addElement(rec_vector);
      total++;     
  }
  k=total;
  this.closeDB();
  System.out.println("vect是面�+total+"记录执行操作");
  System.out.println("成功执行:"+exce);
  this.jt.getSelectionModel().addListSelectionListener(this);  
    
 }
 catch(Exception ee)
 {
  jl2.setText("无法执行,请填入正¼‹®çš„数据");
  System.out.println("执行å¤ÞpÓ|,可能查询为空");
  k=0;
  
 }
}

public void excesql(String sql)
{
 try
 {
 conBuild();
 Statement stm=conn.createStatement();
 stm.executeUpdate(sql);
 jf.repaint();
 jl2.setText("操作已执�);
 System.out.println("成功执行:"+sql);
 this.closeDB();
 }
 catch(Exception ee)
 {
  jl2.setText("无法执行,请填入正¼‹®çš„数据");
  System.out.println(sql+"无法执行");
 }
} 

public static void regDriver()//register JDBC 桥接 driver
{
      try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();//关键�
      System.out.println("驱动注册成功");
      }
       catch(Exception e)
     {
     System.out.println("无法创徏驱动½E‹åºå®žä½“!");
    }

}
   //建立数据库连æŽ?br />public static void conBuild()//建立JDBC˜qžæŽ¥
  {
   try{
     MyAccess.regDriver();
     conn=DriverManager.getConnection("jdbc:odbc:myDSN","","");//关键�
     conn.setAutoCommit(true);
     System.out.println("成功˜qžæŽ¥æ•°æ®åº?);
     }
     catch(Exception e)
     {
      System.out.println(e.getMessage()) ;
      System.out.println("无法˜qžæŽ¥æ•°æ®åº“Connection!åQŒè¿è¡Œä¹‹å‰è¯·å…ˆè®¾¾|®æ•°æ®æº MyDSN");
     }
}

  public static ResultSet execQuery(String stmt1)//执行查询语句
    {
     try{
     conBuild();
      comm=conn.createStatement();
      rs=comm.executeQuery(stmt1);
      return rs;
     }
     catch(Exception e)
      {
       System.out.println("无法创徏Statement!");return null;
      }
}   

public static void closeDB()
{
        try{
          comm.close();
          conn.close();
          System.out.println("关闭记录集，断开数据�);
          }
          catch(Exception e)
         {
          System.out.println(e.getMessage());
         }
 }

public void actionPerformed(ActionEvent ee)// 实现ActionListener中的唯一æ–ÒŽ(gu¨©)³•
{
 if(ee.getSource()==go)
 {
  try
  {
   
   if(i==0)
   {
    exce("SELECT * FROM 成ç‡W order by 分数");
    i=1; 
    go.setText("分数(�>�");
   }

   else
   {
    exce("SELECT * FROM 成ç‡W order by 分数 desc");
    i=0;
    go.setText("分数(�>�"); 
   }
   
   jl2.setText("已按分数排序");
      
  }
  catch(Exception go)
  {
   System.out.println("出现错误");
   jl2.setText("提示:出现错误");
  }
  

  
 }
 if(ee.getSource()==add)
 {
  this.excesql("insert into 成ç‡W values('"+jid.getText()+"','"+jname.getText()+"','"+jscore.getText()+"')");
  exce("SELECT * FROM 成ç‡W order by 学号");
  jid.setText("");
  jname.setText("");
  jscore.setText("");
  jf.repaint();
    
  System.out.println("执行æ·ÕdŠ æ“ä½œ");
  
   
 }

 if(ee.getSource()==drop)
 {
  this.excesql("update 成ç‡W set 姓名='"+jname.getText()+"' ,分数="+jscore.getText()+" where 学号='"+jid.getText()+"'" );
  exce("SELECT * FROM 成ç‡W order by 学号"); 
 
 }
 if(ee.getSource()==del)
 {
  this.excesql("delete from 成ç‡W where 学号='"+jid.getText()+"'");
  exce("SELECT * FROM 成ç‡W order by 学号");
  jl2.setText("提示:成功删除ID�+jid.getText()+"的数�);
  System.out.println("执行删除操作"); 
   
 }
 if(ee.getSource()==jbse)
 {
  if(dataList.getSelectedIndex()>=4)
  {
     String sql="SELECT *  FROM 成ç‡W WHERE "+dataList.getSelectedItem()+se.getText();
   exce(sql);
  }
  else
  {
   String sql="SELECT *  FROM 成ç‡W WHERE "+dataList.getSelectedItem()+"'"+se.getText()+"'";
   exce(sql);
  }
  jl2.setText("搜烦¾l“æžœ:å…?+k+"条数æ?);
  System.out.println(k+"执行搜烦操作");
  
  jf.repaint();
 }
 
 if(ee.getSource()==flush)
 {
  exce("SELECT * FROM 成ç‡W order by 学号");
  jid.setText("");
  jname.setText("");
  jscore.setText("");
  se.setText("");
  jf.repaint();
  jl2.setText("提示:åˆäh–°æˆåŠŸ");
  
 }
 
}

public void valueChanged(ListSelectionEvent el)  //每当选择值发生更æ”ÒŽ(gu¨©)—¶è°ƒç”¨ã€?
{
  row=0;
  row=jt.getSelectedRow();
  if(row<0) row=0;  
  Object row_id=jt.getValueAt(row,0);
  Object row_name=jt.getValueAt(row,1);
  Object row_score=jt.getValueAt(row,2);
  
  jid.setText(row_id.toString());
  jname.setText(row_name.toString());
  jscore.setText(row_score.toString());
  System.out.println("选择已改�+k+"  "+total);
  
  
}

public static void main(String s[])
      {
     MyAccess ma=new MyAccess();
  ma.exce("SELECT * FROM 成ç‡W order by 学号");
     ma.jf.setVisible(true);
    
      }

}

import java.io.*;
import java.net.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;

public class yc extends JFrame
{
 public static JLabel jl1,jl2;
 public static TextArea ta1,ta2;
 public static JButton jb1,jb2;
 public static Container cp1;
  static Socket svr;
 public static PrintWriter out;
 
 
 public static void main(String arg[])
 {
  JFrame jf=new JFrame("与小新聊�-VIP             客户�);
  jf.setSize(500,450);
  jf.setResizable(false);
  jf.locate(100,100);
//  cp1=getContentPane();
  jl1=new JLabel("˜qžæŽ¥ä¸?...");
  ta1=new TextArea();
  ta2=new TextArea();
  jb1=new JButton("发�);
  jb1.addActionListener(new Listener());
  jb2=new JButton("清空");
  jb2.addActionListener(new Listener());
  jf.getContentPane().setLayout(new FlowLayout());
  jf.getContentPane().add(jl1);
   jf.getContentPane().add(ta1);
   jf.getContentPane().add(ta2);
   jf.getContentPane().add(jb1);
   jf.getContentPane().add(jb2);
   
  jf.setVisible(true);
  try
  {
   target2 outmsg2=new target2();
   Thread outthread2=new Thread(outmsg2);
   outthread2.start();
   QQ();

   
   
  }
  catch(Exception e)
  {
   
  }
  
  
 }
 
static void QQ()throws Exception
{
  System.out.println("正在˜qžæŽ¥æœåŠ¡å™?è¯ïL(f¨¥ng)¨å€?..");
  //与指定地址的服务器相连æŽ?br />  svr=new Socket("127.0.0.1",3300);//要连接远½E‹ä¸»æœø™¯·å¡«IP
 //svr=new Socket(InetAddress.getLocalHost(),3300)
  jl1.setText("ä¸?+svr.getInetAddress()+"˜qžæŽ¥æˆåŠŸ!误‚¾“å‡ø™¦ä¼ é€çš„信息...");

 }
 
 
}

 

 class Listener implements ActionListener{
  public void actionPerformed(ActionEvent e)
  {
   
    if(e.getSource()==yc.jb2)
     {
        yc.ta1.setText("");
     }
    
    else
    {
     try
    {
     
     yc.out=new PrintWriter(yc.svr.getOutputStream());
     yc.out.println(yc.ta2.getText());
     yc.out.flush();
     yc.ta1.append("[自己]�\n"+yc.ta2.getText()+"\n");
     yc.ta2.setText("");
 
   
    }
     catch(Exception ee)
     {
      
     }
     
    }
   
    

    
  }
 }
 
 
 
 
class target2 implements Runnable
{
 public void run()
 {
   
    while(true)
    {
     
   try
   {
    
    BufferedReader in=new BufferedReader(new InputStreamReader(yc.svr.getInputStream()));
      String str=in.readLine();
       str="[服务�+yc.svr.getInetAddress()+"]�\n"+str;
       yc.ta1.append(str+"\n");
   }
   
   catch(Exception ee)
   {
    ;
   } 
     
     
     
     }
 }
}
 

 

 

———————————————————————————————�/p>

 

 

//QQ服务�/p>

import java.io.*;
import java.net.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;

public class ycserver extends JFrame
{
 public static JLabel jl1;
 public static TextArea ta1,ta2;
 public static JButton jb1,jb2;
 public static Container cp1;
 public static ServerSocket svr; 
 public static Socket clt;
 public static Thread thread;
 public static int i=0;
 

  
 public static void main(String arg[])
 {
  JFrame jf=new JFrame("与杨彩聊�-VIP            服务�);
  jf.setSize(500,450);
  jf.locate(200,200);
  jf.setResizable(false);
  ta1=new TextArea();
  ta2=new TextArea();
  jb1=new JButton("发�);
  jb2=new JButton("清空");
  jl1=new JLabel("½{‰å¾…˜qžæŽ¥");
  jb1.addActionListener(new jb1Listener());
  jb2.addActionListener(new jb1Listener());
  jf.getContentPane().setLayout(new FlowLayout());
  jf.getContentPane().add(jl1);
   jf.getContentPane().add(ta1);
   jf.getContentPane().add(ta2);
   jf.getContentPane().add(jb1);
   jf.getContentPane().add(jb2);
   
  jf.setVisible(true);
  try
  {
   target outmsg=new target();
   Thread outthread=new Thread(outmsg);
   outthread.start();
   
   wait wait1=new wait();
   Thread waitthread=new Thread(wait1);
   waitthread.start();
   
   QQ();

   

  }
  catch(Exception e)
  {
   
  }
  
  
 }
 
 
static void QQ()throws Exception
{/*
 //建立服务器套节字
  svr=new ServerSocket(3300);
  System.out.println("½{‰å¾…˜qžæŽ¥....");
 //½{‰å¾…客户机接å…?br />   clt=svr.accept();
    i++;
    ta1.setText(i+"");
 //获得客户IP地址
  System.out.println("˜qžæŽ¥è¯äh±‚来自:"+clt.getInetAddress());
  jl1.setText("˜qžæŽ¥è¯äh±‚来自:"+clt.getInetAddress());
  //建立I/O‹¹?br />  */

   }
  
 }
 
 

 class jb1Listener implements ActionListener
 {
  public void actionPerformed(ActionEvent e)
  {
   if(e.getSource()==ycserver.jb2)
   {
    ycserver.ta1.setText("");
   }
   
   else
   {
     try
    {
          
    PrintWriter out=new PrintWriter(ycserver.clt.getOutputStream());
    out.println(ycserver.ta2.getText());
    out.flush();
     ycserver.ta1.append("[自己]�\n"+ycserver.ta2.getText()+"\n");
     ycserver.ta2.setText("");
 
   
    }
     catch(Exception ee)
     {
      
     }
   }
  
  }
 }

 

class target implements Runnable
{
 public void run()
 {
   
    while(true)
    {
     
   try
   {    
    BufferedReader in=new BufferedReader(new InputStreamReader(ycserver.clt.getInputStream()));
      String str=in.readLine();
       str="[客户端在"+ycserver.clt.getInetAddress()+"]�\n"+str;
       ycserver.ta1.append(str+"\n");
   }
   
   catch(Exception ee)
   {
    ;
   } 
     
     
     
     }
 }
}

 

class wait implements Runnable
{
 public void run()
 {
   
    while(true)
    {
     
   try
   {    
    //建立服务器套节字
  ycserver.svr=new ServerSocket(3300);
  System.out.println("½{‰å¾…˜qžæŽ¥....");
 //½{‰å¾…客户机接å…?br />   ycserver.clt=ycserver.svr.accept();
    ycserver.i+=2;
    ycserver.ta1.setText(ycserver.i+"");
 //获得客户IP地址
  System.out.println("˜qžæŽ¥è¯äh±‚来自:"+ycserver.clt.getInetAddress());
  ycserver.jl1.setText("˜qžæŽ¥è¯äh±‚来自:"+ycserver.clt.getInetAddress());
  //建立I/O‹¹?br />   }
   
   catch(Exception ee)
   {
    ;
   } 
     
     
     
     }
 }
}

 

 

 

源码下蝲åQ?/div>

http://www.aygfsteel.com/Files/yangcai/qq.rar

杨彩 2006-12-08 07:28 发表评论

]]>