Java网络编程技术-10.ppt

10.2 界面与业务逻辑 普通用户聊天-公聊，私聊 管理员用户聊天 -公聊，私聊，踢用户 注册新用户 管理-删除用户 10.3系统用例图普通用户 管理员用户 import java.sql.*; import java.util.*; public class DBHandler { private static Connection con = getConn(); private static Statement smt = null; exeQuery()方法 private static ResultSet exeQuery(String query) throws SQLException { if (con == null) { con = getConn(); } if (smt == null) { smt = con.createStatement(); } return smt.executeQuery(query); } exeUpdateQuery(String query)方法 private static void exeUpdateQuery(String query) throws SQLException { if (smt == null) { smt = con.createStatement(); } smt.executeUpdate(query); } Connection getConn()方法 private static Connection getConn() { String url = (jdbc:odbc:chatroom); try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String name = sa; String pw = admin; return (DriverManager.getConnection(url, name, pw)); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } return null; } isAuthorized(String name, String pw)方法 public static boolean isAuthorized(String name, String pw) { String query = select * from userInfo where name= + name+ and password= + pw + ; try { ResultSet rs = exeQuery(query); return rs.next(); } catch (SQLException e) { e.printStackTrace(); return false; } } deleteUser(String name)方法 public static boolean deleteUser(String name) { String query = delete from userInfo where name= + name + ; try { exeUpdateQuery(query); return true; } catch (SQLException e) { e.printStackTrace(); return false; } } getPrio(String name, String password)方法 public static int getPrio(String name, String password) { String query = select role from userInfo where name= + name+ and password= + password + ; ResultSet rs; try { rs = exeQuery(query); rs.next(); return rs.getInt(1); } catch (SQLException e) {