checkuser.java

一个很好的BBS论坛项目

package com.ibm.common;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class CheckUser {
	private boolean flag = false;
	private ResultSet rs;

	public boolean check(String username)
	{
		String sql = "select * from users where username='"+username+"'";
		Connection conn = DBConnection.getInstance().getConnection();
		try {
			PreparedStatement ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			flag = rs.next();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
}