SpringMvc002

创建一个UserService类对方法进行定义

package com.user.service;

import java.util.Date;
import java.util.List;

import com.oupeng.pojo.User;

public interface UserService {
	public User findUser(String userCode,String password);
	
	//查询所有的用户列表
		public List<User> findUserList(String userName,int roleId);
		
		//查看某个人的信息
		public User findUserById(String id);
		
		//修改某个人的信息
		public int updateByUserId(String id,String userName,String userPassword,int gender,Date birthday,String phone,String address);
		
		//添加用户
		public int save(User user);
		
		//删除
		public int deleteById(String id);
}

创建UserService的实现类UserServiceImpl

package com.user.service.impl;

import java.util.Date;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.oupeng.pojo.User;
import com.oupeng.user.dao.UserDao;
import com.user.service.UserService;

@Service
public class UserServiceImpl implements UserService {

	@Resource
	private UserDao userdao;

	public UserDao getUserdao() {
		return userdao;
	}

	public void setUserdao(UserDao userdao) {
		this.userdao = userdao;
	}

	@Override
	public User findUser(String userCode, String password) {
		User user = null;
		try {
			user = userdao.getLoginUser(userCode, password);
		} catch (Exception e) {
			e.printStackTrace();
		}

		return user;
	}

	@Override
	public List<User> findUserList(String userName, int roleId) {
		return userdao.getUserList(userName, roleId);
	}

	@Override
	public User findUserById(String id) {
		return userdao.getUserById(id);
	}

	@Override
	public int updateByUserId(String id, String userName, String userPassword,
			int gender, Date birthday, String phone, String address) {
		return userdao.updateByUserId(id, userName, userPassword, gender, birthday, phone, address);
	}

	@Override
	public int save(User user) {
		return userdao.add(user);
	}

	@Override
	public int deleteById(String id) {
		return userdao.deleteById(id);
	}

}

创建实现类

package com.oupeng.user.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.springframework.stereotype.Repository;

import com.jdbc.utils.DbConn;
import com.oupeng.pojo.Role;
import com.oupeng.pojo.User;

@Repository
public class UserDaoImpl implements UserDao {

	Connection conn=null;
	Statement st=null;
	ResultSet rs=null;
	
	@Override
	public User getLoginUser(String userCode, String password)throws Exception {
		User user=null;
		conn=DbConn.getConnection();
		String sql="select * from smbms_user where userCode='"+userCode+"' and userPassword='"+password+"'";
		System.out.println(sql);
		try {
			st=conn.createStatement();
			rs=st.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if(rs!=null){
			while (rs.next()){
				user=new User();
				user.setUserName(rs.getString("userName"));
			}
		}
		
		DbConn.close(rs, st, conn);
		return user;
	}
//查询所有的用户列表
	@Override
	public List<User> getUserList(String userName, int roleId) {
		Connection conn=DbConn.getConnection();
		Statement st=null;
		
		User user=null;
		StringBuffer sql=new StringBuffer("select u.*,r.roleName from smbms_user u,smbms_role r where 1=1");
		if(userName!=null &&userName!=""){
			sql.append(" and u.userName like '%"+userName+"%'");
		}
		
		if(new Integer(roleId)!=null){
			if(roleId>0){
				sql.append(" and u.userRole="+roleId);
			}
		}
		
		sql.append(" and u.userRole=r.id order by creationDate desc");
		System.out.println(sql);
		List<User> list=new ArrayList();
		
		try {
			st=conn.createStatement();
			ResultSet rs=st.executeQuery(sql.toString());
			while(rs.next()){
				user=new User();
				user.setId(rs.getInt("id"));
				user.setUserCode(rs.getString("userCode"));
				user.setUserName(rs.getString("userName"));
				user.setGender(rs.getInt("gender"));
				user.setBirthday(rs.getDate("birthday"));
				user.setPhone(rs.getString("phone"));
				user.setAddress(rs.getString("address"));
				user.setRoleName(rs.getString("roleName"));
				list.add(user);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		DbConn.close(rs, st, conn);
		return list;
	}
//查看某个人的信息
	@Override
	public User getUserById(String id) {
		Connection conn=DbConn.getConnection();
		Statement st=null;
		ResultSet rs=null;
		User user=null;
		String sbf=new String("select u.* from smbms_user u where u.id="+id);
		
		
		try {
			st=conn.createStatement();
			rs=st.executeQuery(sbf);
			while(rs.next()){
				user=new User();
				user.setId(rs.getInt("id"));
				user.setUserCode(rs.getString("userCode"));
				user.setUserPassword(rs.getString("userPassword"));
				user.setUserName(rs.getString("userName"));
				user.setGender(rs.getInt("gender"));
				user.setBirthday(rs.getDate("birthday"));
				user.setPhone(rs.getString("phone"));
				user.setAddress(rs.getString("address"));
				
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		DbConn.close(rs, st, conn);
		return user;
	}
//修改某个人的信息
	@Override
	public int updateByUserId(String id, String userName, String userPassword,
			int gender, Date birthday, String phone, String address) {
		Connection conn=DbConn.getConnection();
		PreparedStatement pst=null;
		ResultSet rs=null;
	
		String sql=new String("update  smbms_user u set userName=?,userPassword=?,gender=?,birthday=?,phone=?,address=? where u.id=?");
		int result=0;
		
		try {
			pst=conn.prepareStatement(sql);
			pst.setString(1, userName);
			pst.setString(2, userPassword);
			pst.setInt(3, gender);
			pst.setDate(4, new java.sql.Date(birthday.getTime()));
			pst.setString(5, phone);
			pst.setString(6, address);
			pst.setInt(7, Integer.parseInt(id));
			result=pst.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		DbConn.close(rs, st, conn);
		return result;
	}
//添加用户
	@Override
	public int add(User user) {
		return 0;
	}
//删除
	@Override
	public int deleteById(String id) {
		Connection conn=DbConn.getConnection();
		Statement st=null;
		int result=0;
		String sbf=new String("delete  from smbms_user u where u.id="+id);
		
		
		try {
			st=conn.createStatement();
			result=st.executeUpdate(sbf);
		
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		DbConn.close(rs, st, conn);
		return result;
	}

	
}