?? chatuserdb.java~21~
字號:
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(); /*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"); } }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -