usersdao.java

来自「一个平时上课练习」· Java 代码 · 共 45 行

package com.dao;

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


import javax.sql.DataSource;

import com.vo.Users;

public class UsersDAO {
	private DataSource ds;

	public void setDs(DataSource ds) {
		this.ds = ds;
	}

	public Users findUsers(Users u) {
		try {
			Connection cn = ds.getConnection();
			ResultSet rs;
			PreparedStatement ps = null;
			ps = cn
					.prepareStatement("select * from users where uname=? and upass=?");
			ps.setString(1, u.getUname());
			ps.setString(2, u.getUpass());
			rs = ps.executeQuery();
			if (rs.next()) {
				return u;
			} 
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;

	}

	public DataSource getDs() {
		return ds;
	}
}