checkloginname.java

实现统一的人员日志管理系统管理后台

package com.tb.log.dwr;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.tb.log.factory.*;





public class CheckLoginName {
	Connection coon = null;
	PreparedStatement psm = null;
	ResultSet rs = null;
	
	public String checkLogin(String loginname) {
		String outPut = "";
		coon = OracleDAOFactory.getConnection();
		try {
			coon.setAutoCommit(false);
			psm = coon.prepareStatement("select loginname from t_user where loginname=?");
			psm.setString(1, loginname);
			ResultSet rs = psm.executeQuery();
			if(rs.next()){
				outPut = "<font color='#ff0000'>该用户名已被使用，请重新输入</font>";
			}else{
				outPut = "<font color='#ff0000'>用户名可以使用</font>";
			}
			coon.commit();
			coon.setAutoCommit(true);
		} catch (SQLException e) {
			try {
				coon.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			try {
				if(rs != null) rs.close();
				if(psm != null ) psm.close();
				if(coon != null) coon.close();
			} catch (Exception e) {
				System.out.println(" 登陆数据库验证异常 ！");
				e.printStackTrace();
			}
		}
		return outPut;
	}
	
	public String checkEmail(String email) {
		String outPut = "";
		coon = OracleDAOFactory.getConnection();
		try {
			coon.setAutoCommit(false);
			psm = coon.prepareStatement("select email from t_user where email=?");
			psm.setString(1, email);
			ResultSet rs = psm.executeQuery();
			if(rs.next()){
				outPut = "<font color='#ff0000'>该Email已被使用，请重新输入</font>";
			}else{
				outPut = "<font color='#ff0000'>Email地址可以使用</font>";
			}
			coon.commit();
			coon.setAutoCommit(true);
		} catch (SQLException e) {
			try {
				coon.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			try {
				if(rs != null) rs.close();
				if(psm != null ) psm.close();
				if(coon != null) coon.close();
			} catch (Exception e) {
				System.out.println(" 登陆数据库验证异常 ！");
				e.printStackTrace();
			}
		}
		return outPut;
	}

	public static void main(String[] args) {
		CheckLoginName login = new CheckLoginName();
		System.out.println(login.checkLogin("admi"));
	}
}