chatuserdb.java~24~

来自「1． 消息即时通信 2． 消息发送实现一对一、一对多等多种发送模式 3． 发」· JAVA~24~ 代码 · 共 64 行

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){
      e.printStackTrace();
    }
    try{
     con=DriverManager.getConnection("jdbc:odbc:chat","sa","") ;
     sql=con.createStatement();
    }catch(SQLException e){
     e.printStackTrace();
    }
  }

  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;
     }
     con.close();
     rs.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");
    }



  }
}