userjdbcdao.java

贯穿案例JSP+JavaBean+Servlet网上订餐系统.希望大家下载下来研究

package com.restrant.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.ResultSet;
import com.restrant.entity.Userinfo;
import com.restrant.dao.ConnectionManager;

public class UserJdbcDao extends UserDao {
	private Connection con = null;

	public boolean save(Userinfo userinfo) {
		String sql = "select * from userInfo where loginName=? and loginPass=?";
		ResultSet rs = null;
		boolean flag=false;
		try {
			con = ConnectionManager.getConnection();
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setString(1, userinfo.getLoginname());
			ps.setString(2, userinfo.getPassword());
			rs = ps.executeQuery();
			if(rs.next()){
				flag=true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return flag;
	}
}