logindata.java

来自「Java+Web+会话+聊天室希望对兄弟们有点儿帮助」· Java 代码 · 共 56 行

package pchat;

import java.sql.*;

public class LoginData {
    public LoginData() {
    }

    //判断用户名是否存在
    public boolean Ishave(String name) {
        Connection con = SQLData.sqlData();
        Statement st = null;
        ResultSet rs = null;
        boolean avaiable = false;
        try {
            st = con.createStatement();
            rs = st.executeQuery("select * from Login");
            while (rs.next()) {
                if (rs.getString(1).equals(name)) {
                    avaiable = true;
                    break;
                }
            }
        } catch (SQLException ee) {
        } finally {
            try {
                rs.close();
                st.close();
                con.close();
            } catch (Exception ee) {}
        }

        return avaiable;
    }

    //记录数据存储到数据库中
    public boolean noteData(String name, String pass) {
        boolean avaiable=false;
        Connection con = SQLData.sqlData();
        Statement st = null;
        try {
            st = con.createStatement();
            st.executeUpdate("insert into Login values('" + name + "','" + pass + "')");
           // System.out.println("我已经注册了");
        } catch (SQLException ee) {
            avaiable=true;
        } finally {
            try {
                st.close();
                con.close();
            } catch (Exception ee) {}
        }
       return avaiable;
    }
}