src/com/fhd/dao/UserDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.fhd.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.fhd.conn.DBConnection;
import com.fhd.bean.UserBean;

public class UserDao {
	
	/**
	 * @author FHD
	 * @param int userId
	 * @return boolean
	 * 根据userId删除用户
	 */
	public static boolean delete(int userId) {
		boolean flag=false;
		Connection conn = DBConnection.getConnection();
		PreparedStatement ptmt= null;
		String sqls = "delete from [User] where userId = ?";
		try {
			ptmt = conn.prepareStatement(sqls);
			ptmt.setInt(1, userId);
			flag=ptmt.executeUpdate()>0;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
	
	/**
	 * @author FHD
	 * @param int userId
	 * @return boolean
	 * 根据userId得到用户名
	 */
	public static String getUserNameById(int userId) {
		String name = "";
		Connection conn = DBConnection.getConnection();
		PreparedStatement ptmt= null;
		String sqls = "select userTrueName from [User] where userId = ?";
		try {
			ptmt = conn.prepareStatement(sqls);
			ptmt.setInt(1, userId);
			ResultSet rs=ptmt.executeQuery();
			if(rs.next()){
				name = rs.getString("userTrueName");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return name;
	}