chatuserdb.java~20~

1． 消息即时通信 2． 消息发送实现一对一、一对多等多种发送模式 3． 发送的消息实现多彩文本编辑

import java.sql.*;
public class ChatUserDB {
  static Connection con=null;
  static Statement sql=null;
  static ResultSet rs=null;
  String name=null;
  String pd=null;
  public ChatUserDB(){
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(ClassNotFoundException e){

    }
    try{
     con=DriverManager.getConnection("jdbc:odbc:chat","sa","") ;
     sql=con.createStatement();
     /*rs=sql.executeQuery("select * from usertable where username ="
                         +"'"+name+"'"+"and userkey="+"'"+pd+"'");
     System.out.println("ooo");
     while(rs.next()){
       System.out.println(rs.getString(1));
       System.out.println(rs.getString(2));
     }*/

    }catch(SQLException e){

    }

  }
  public boolean checkUser(String name,String key){
    this.name=name;
    this.pd=key;
    boolean b=false;
    try{
    rs=sql.executeQuery("select * from usertable where username ="
                         +"'"+name+"'"+"and userkey="+"'"+pd+"'");
     System.out.println("ooo");
     if(rs.next()){
       b=true;
       //System.out.println(rs.getString(1));
       //System.out.println(rs.getString(2));
     }
     con.close();

    }catch(SQLException e){
      e.printStackTrace();
    }

    return b;
  }
  public static void main(String[] args) {
    ChatUserDB db=new ChatUserDB();
    if(db.checkUser("user2","2")){
      System.out.println("ok");
    }



  }
}