loginimpl.java

很多学校

package com.tarena.dao.ipml;

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

import com.tarena.dao.LoginDao;
import com.tarena.entity.User;
import com.tarena.util.*;

public class LoginImpl implements LoginDao{
	/*
	 * 登录用户,根据用户名和密码返回一个User类对象
	 * */
	public User login(String username, String password) {
		Connection con=null;
		Statement st=null;
		ResultSet rs=null;
		con=JdbcUtil.getConnection();
		try {
			st=con.createStatement();
			String sql="select * from user_bo where name='"+username+"' and password='"+password+"'";
			rs=st.executeQuery(sql);
			User user=new User();
			if(rs.next()){
				user.setOid(rs.getLong(1));
				user.setName(rs.getString(2));
				user.setPassword(rs.getString(3));
				user.setAddress(rs.getString(4));
				user.setPostCode(rs.getString(5));
				user.setEmail(rs.getString(6));
				user.setPhone(rs.getString(7));
				return user;
			}
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}finally{
			JdbcUtil.release(rs, st, con);
		}
		return null;
	}

}