systemmemberdaoimpl.java

JavaEE订餐项目的功能：用户登录、用户注册、添加订餐信息、查询订餐、结算、权限验证

package com.amaker.dao.impl;

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

import com.amaker.bean.SystemMember;
import com.amaker.dao.SystemMemberDao;
import com.amaker.util.ConnectionUtil;

public class SystemMemberDaoImpl implements SystemMemberDao {

	public boolean check(String name) {

		Connection conn = new ConnectionUtil().getConnection();
		String sql = " select * from SystemMemberTbl  where name=? ";

		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, name);

			ResultSet rs = pstmt.executeQuery();

			if (rs.next()) {
				return true;
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		return false;
	}

	public SystemMember login(String username, String password) {
		Connection conn = new ConnectionUtil().getConnection();
		String sql = " select id,name,fullName,password,privillege from SystemMemberTbl  where name=? and password = ?";

		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			
			

			ResultSet rs = pstmt.executeQuery();

			if (rs.next()) {
				int id = rs.getInt(1);
				// String name = rs.getString(2);
				String fullName = rs.getString("fullName");
				// String password = rs.getString(4);
				String privillege = rs.getString(5);

				SystemMember m = new SystemMember();

				m.setId(id);
				m.setFullName(fullName);
				m.setName(username);
				m.setPassword(password);
				m.setPrivillege(privillege);

				return m;
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		return null;
	}

	public void register(SystemMember m) {
		
		
		Connection conn = new ConnectionUtil().getConnection();
		String sql = " insert into SystemMemberTbl(name,fullname,password) values(?,?,?) ";

		
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, m.getName());
			pstmt.setString(2, m.getFullName());
			pstmt.setString(3, m.getPassword());
			
			pstmt.executeUpdate();
			
		} catch (SQLException e) {

			e.printStackTrace();
		}

		
	}

}