usersdao.java

java连接数据库的一个实例

/*
 * Created on Mar 20, 2005
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.test.jdbc;

import java.sql.*;

/**
 * @author jackie
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class UsersDAO {

public boolean checkUser(String userName, String password){
		DBConnection dbConn = new DBConnection();
		try {
			Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement(
				"SELECT * FROM users where userName=? AND password=?");
		checkUser.setString(1,userName);
		checkUser.setString(2,password);
		ResultSet rs = checkUser.executeQuery();
		if(rs.next())
			return true;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return false;
		
	}}