loginservice.java

用ExtJS做的一个网页聊天工具

package com.shyhao.qq.service;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.shyhao.qq.jobo.UserBean;

public class LoginService {

	// 数据库连接参数
	private String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private String URL = "jdbc:sqlserver://localhost:1433;   DatabaseName=shyhao";
	private String NAME = "songyinghao";
	private String PASSWORD = "159";

	public LoginService() {
		try {
			Class.forName(DRIVER);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public void increaseUser(UserBean usb) {
		Connection conn = null;
		Statement stmt = null;
		String sql = "";
		try {
			conn = DriverManager.getConnection(URL, NAME, PASSWORD);
			stmt = conn.createStatement();
			sql = "insert into QQUser (UserName,Password,Email,Introduction,OnLine,ParentId) values ('"
					+ usb.getUserName()
					+ "','"
					+ usb.getPassword()
					+ "','"
					+ usb.getEmail()
					+ "','"
					+ usb.getIntroduction()
					+ "','0','1')";
			stmt.execute(sql);
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public boolean checkUser(String userName) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "";
		boolean exist=false;
		try {
			conn = DriverManager.getConnection(URL, NAME, PASSWORD);
			stmt = conn.createStatement();
			sql = "select * from QQUser where UserName='" + userName + "'";
			rs = stmt.executeQuery(sql);
			if (rs.next()) {
				exist=true;
			}else{
				exist=false;
			}
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return exist;
	}
	public boolean checkLogin(String userName,String passWord){
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "";
		boolean exist=false;
		try {
			conn = DriverManager.getConnection(URL, NAME, PASSWORD);
			stmt = conn.createStatement();
			sql="select * from QQUser where UserName='"
				+userName+"' and Password='"+passWord+"'";
			rs=stmt.executeQuery(sql);
			if(rs.next()){
				sql="update QQUser set OnLine='1' where userName='"+userName+"'";
				stmt.execute(sql);
				exist=true;
			}else{
				exist=false;
			}
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return exist;
	}
}