• Java项目：JSP二手自行车在线销售商城平台系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本系统分为前后台，分为普通用户和管理员两种角色；

    管理员角色包含以下功能：

    管理员登录,用户管理,自行车分类管理,商品管理,订单管理,留言和公告管理等功能。

    用户角色包含以下功能：
    浏览自行车,查看自行车,结算订单,用户登录注册,查看订单,在线留言等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

    5.数据库：MySql 5.7版本；

    6.是否Maven项目：否；

    技术栈

    JSP+CSS+JavaScript+java+servlet+mysql

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中src/com/hr/dao/Basedao.java配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入http://localhost:8080/ 登录
    管理员账号/密码：admin/admin 

    用户账号/密码：user/123456

    运行截图

    前台界面-用户角色

     

     

     

     

     

     

    后台界面

     

     

     

     

     

    相关代码 

    gmServlet

    1. package com.web.shopservlet;
    2.  
    3.  
    4. import java.io.IOException;
    5. import java.io.PrintWriter;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.http.HttpServlet;
    9. import javax.servlet.http.HttpServletRequest;
    10. import javax.servlet.http.HttpServletResponse;
    11. import javax.servlet.http.HttpSession;
    12.  
    13. import com.hr.dao.ESDao;
    14. import com.hr.entity.EASYBUY_ORDER_DETAIL;
    15. import com.hr.entity.EASYBUY_USER;
    16. import com.hr.util.EncodeUtil;
    17.  
    18.  
    19. public class gmServlet extends HttpServlet {
    20. @Override
    21. protected void service(HttpServletRequest arg0, HttpServletResponse arg1)
    22. 		throws ServletException, IOException {
    23. 	arg1.setContentType("text/html;charset=utf-8");
    24. 	PrintWriter out=arg1.getWriter();
    25. 	EncodeUtil.encode(arg0);
    26. 	HttpSession session=arg0.getSession();
    27. 	EASYBUY_USER list=(EASYBUY_USER)session.getAttribute("name");
    28. 	//用户id
    29. 	String id=list.getEU_USER_ID();
    30. 	//用户姓名
    31. 	String name=list.getEU_USER_NAME();
    32. 	//用户地址
    33. 	String address=list.getEU_ADDRESS();
    34. 	//总价钱
    35. 	String price=arg0.getParameter("jstext");
    36. 	
    37. 	//商品id
    38. 	String [] EP_ID=arg0.getParameterValues("spID");
    39. 	//购买数量
    40. 	String [] quantity=arg0.getParameterValues("number");
    41. 	//商品单价
    42. 	String [] sPPrice=arg0.getParameterValues("sPPrice");
    43. 	
    44. 	//购买后对商品表的库存进行修改
    45. 	for(int i=0;i
    46. 		int count5=ESDao.updateStock(Integer.parseInt(quantity[i]),Integer.parseInt(EP_ID[i]));
    47. 	}
    48. 	//商品单个总价
    49. 	int [] pprice=new int[EP_ID.length];
    50. 	for(int i=0;i
    51. 		pprice[i]=Integer.parseInt(quantity[i])*Integer.parseInt(sPPrice[i]);
    52. 	} 
    53. 	/得到序列
    54. 	//往订单表里添加数据
    55. 	int count=ESDao.insertDD(id, name, address,Integer.parseInt(price));
    56. 	int getSequenceId=ESDao.getSequenceId();
    57. 	//循环往订单详情添加
    58. 	for(int i=0;i
    59. 		EASYBUY_ORDER_DETAIL eod=new EASYBUY_ORDER_DETAIL(1,getSequenceId,Integer.parseInt(EP_ID[i]),Integer.parseInt(quantity[i]),pprice[i]);
    60. 		int count2=ESDao.eodInsert(eod);
    61. 	}
    62. 	
    63. 	
    64. 	
    65. 	// 开单后，修改购物车
    66. 	String [] esID=arg0.getParameterValues("esID");
    67. 	for(int i=0;i
    68. 		int count3 =ESDao.esdelete(Integer.parseInt(esID[i]));
    69. 	}
    70. 	/
    71. 	if(count>0){
    72. 			
    73. 		out.print("");
    74. 		out.close();
    75. 	}else{
    76. 		out.print("");
    77. 		out.close();
    78. 	}
    79. }
    80. }

    ShopSelect

    1. package com.web.shopservlet;
    2.  
    3.  
    4. //订单表数据的查询
    5.  
    6. import java.io.IOException;
    7. import java.io.PrintWriter;
    8. import java.util.ArrayList;
    9.  
    10.  
    11. import javax.servlet.ServletException;
    12. import javax.servlet.http.HttpServlet;
    13. import javax.servlet.http.HttpServletRequest;
    14. import javax.servlet.http.HttpServletResponse;
    15. import javax.servlet.http.HttpSession;
    16. import com.hr.dao.ESDao;
    17. import com.hr.entity.EASYBUY_USER;
    18. import com.hr.entity.eb_shop;
    19. import com.hr.util.EncodeUtil;
    20.  
    21. public class ShopSelect extends HttpServlet {
    22. 	@Override
    23. 	protected void service(HttpServletRequest arg0, HttpServletResponse arg1)
    24. 			throws ServletException, IOException {
    25. 		EncodeUtil.encode(arg0);
    26. 		arg1.setContentType("text/html;charset=utf-8");
    27. 		PrintWriter out = arg1.getWriter();
    28. 		HttpSession session=arg0.getSession();
    29. 		EASYBUY_USER userCZ=(EASYBUY_USER)session.getAttribute("name");
    30. 		if(userCZ!=null){
    31. //			System.out.println("登录好了");
    32. 			EASYBUY_USER eu=(EASYBUY_USER)session.getAttribute("name");
    33. 			String id=(String)eu.getEU_USER_ID();
    34. 			ArrayList list=ESDao.getShop(id);
    35. 			arg0.setAttribute("shoplist",list);
    36. 			arg0.getRequestDispatcher("shopping.jsp").forward(arg0, arg1);
    37. 		}else{
    38. 			out.print("");
    39. 			out.close();
    40. 			
    41. 		}
    42. 	}
    43. }

    ESDao

    1. package com.hr.dao;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8.  
    9. import com.hr.entity.EASYBUY_ORDER_DETAIL;
    10. import com.hr.entity.EASYBUY_PRODUCT_CATEGORY;
    11. import com.hr.entity.EASYBUY_USER;
    12. import com.hr.entity.eb_shop;
    13.  
    14. public class ESDao {
    15. 	/**
    16. 	 * 两张表联查做购物车
    17. 	 */
    18. 	public static ArrayList getShop(String id){
    19. 		ArrayList list=new ArrayList();
    20. 		Connection conn=Basedao.getconn();
    21. 		PreparedStatement ps=null;
    22. 		ResultSet rs=null;
    23. 			try {
    24. 				ps=conn.prepareStatement("select * from EASYBUY_SHOP where es_EU_USER_ID=? and ES_VALID=1 order by es_id desc");
    25. 				ps.setString(1,id);
    26. 				rs=ps.executeQuery();
    27. 				while(rs.next()){
    28. 					eb_shop es=new eb_shop(
    29. 							rs.getInt("es_id"),
    30. 							rs.getString("es_ep_file_name"),
    31. 							rs.getString("es_ep_name"),
    32. 							rs.getInt("es_ep_price"),
    33. 							rs.getInt("es_eod_quantity"),
    34. 							rs.getInt("es_ep_stock"),
    35. 							rs.getInt("es_ep_id"),
    36. 							rs.getString("es_EU_USER_ID"),
    37. 							rs.getInt("es_valid")
    38. 								);
    39. 					list.add(es);
    40. 				}
    41. 			} catch (SQLException e) {
    42. 				// TODO Auto-generated catch block
    43. 				e.printStackTrace();
    44. 			}finally{
    45. 				Basedao.closeall(rs, ps, conn);
    46. 				
    47. 			}
    48. 			return list;
    49. 	}
    50. 	/*
    51. 	 * 
    52. 	 *修改订单数量 加
    53. 	 */
    54. 	public static int updateJia(int id){
    55. 		String sql="update EASYBUY_SHOP set es_eod_quantity=es_eod_quantity+1 where es_id=?";
    56. 		Object [] params={id};
    57. 		return Basedao.exectuIUD(sql, params);
    58. 	}
    59. 	
    60. 	/*
    61. 	 * 
    62. 	 *修改订单数量 减
    63. 	 */
    64. 	public static int updateJian(int id){
    65. 		String sql="update EASYBUY_SHOP set es_eod_quantity=es_eod_quantity-1 where es_id=?";
    66. 		Object [] params={id};
    67. 		return Basedao.exectuIUD(sql, params);
    68. 	}
    69. 	/*
    70. 	 * 
    71. 	 * 修改订单数量，自己输入
    72. 	 */
    73. 	public static int updateClose(eb_shop es){
    74. 		String sql="update EASYBUY_SHOP set es_eod_quantity=? where es_id=?";
    75. 		Object [] params={es.es_eod_quantity,es.es_id};
    76. 		return Basedao.exectuIUD(sql, params);
    77. 	}
    78. 	/**
    79. 	 * 修改订单为2
    80. 	 * @param id
    81. 	 * @return
    82. 	 */
    83. 	public static int getDelete(int id){
    84. 		String sql="update EASYBUY_SHOP set es_vaild=2 where es_id=?";
    85. 		Object[] params={id};
    86. 		return Basedao.exectuIUD(sql, params);
    87. 	}
    88. 	/*
    89. 	 * 
    90. 	 * 订单表的添加
    91. 	 * 
    92. 	 */
    93. 	public static int insertDD(String id,String name,String address,int price){
    94. 		String sql="insert into EASYBUY_ORDER values(null,?,?,?,now(),?,1,1)";
    95. 		Object [] params={id,name,address,price};
    96. 		return Basedao.exectuIUD(sql, params);
    97. 	}
    98. 	/*
    99. 	 * 得到序列
    100. 	 */
    101. 	public static int getSequenceId(){
    102. 		int id = 0;
    103. 		Connection conn = Basedao.getconn();
    104. 		PreparedStatement ps = null; 
    105. 		ResultSet rs = null;
    106. 		try {
    107. 			ps = conn.prepareStatement("select EO_ID from easybuy_order order by EO_ID desc limit 0,1");
    108. 			rs = ps.executeQuery();
    109. 			if(rs.next()){
    110. 				id = rs.getInt(1);
    111. 			}
    112. 		} catch (SQLException e) {
    113. 			// TODO Auto-generated catch block
    114. 			e.printStackTrace();
    115. 		} finally {
    116. 			Basedao.closeall(rs, ps, conn);
    117. 		}
    118. 		return id;
    119. 	}
    120. 	/*
    121. 	 * 
    122. 	 * 订单详细表的添加
    123. 	 */
    124. 	public static int eodInsert(EASYBUY_ORDER_DETAIL eod){
    125. 		String sql="insert into EASYBUY_ORDER_DETAIL values(null,?,?,?,?)";
    126. 		Object [] params={eod.getEO_ID(),eod.getEP_ID(),eod.getEOD_QUANTITY(),eod.getEOD_COST()};
    127. 		return Basedao.exectuIUD(sql, params);
    128. 	}
    129. 	/*
    130. 	 * 
    131. 	 * 购物单的修改
    132. 	 */
    133. 	public static int esdelete(int id){
    134. 		String sql="update  EASYBUY_SHOP set es_valid=2 where es_id=?";
    135. 		Object [] params={id};
    136. 		return Basedao.exectuIUD(sql, params);
    137. 	}
    138. 	//kucun
    139. 	public static int updateStock(int stock,int id){
    140. 		String sql="update EASYBUY_PRODUCT set ep_stock=ep_stock-? where ep_id=?";
    141. 		Object [] params={stock,id};
    142. 		return Basedao.exectuIUD(sql, params);
    143. 	}
    144. 	
    145. 	public static int insert(eb_shop sp){
    146. 		String sql = "insert into easybuy_shop values(null,?,?,?,?,?,?,?,1)";
    147. 		Object[] params = {sp.getEs_ep_file_name(),
    148. 							sp.getEs_ep_name(),
    149. 							sp.getEs_ep_price(),
    150. 							sp.getEs_eod_quantity(),
    151. 							sp.getEs_ep_stock(),
    152. 							sp.getEs_ep_id(),
    153. 							sp.getEs_EU_USER_ID()};
    154. 		return Basedao.exectuIUD(sql, params);
    155. 	}
    156. 	
    157. 	public static  int getDeleteDD(int id){
    158. 		String sql="delete from easybuy_shop where es_id=?";
    159. 		Object [] params={id};
    160. 		return Basedao.exectuIUD(sql, params);
    161. 	}
    162. }

    EASYBUY_USERDao

    1. package com.hr.dao;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8.  
    9. import com.hr.entity.EASYBUY_USER;
    10.  
    11. public class EASYBUY_USERDao {
    12. 	/**
    13. 	 * 分页查询
    14. 	 */
    15. 	public static ArrayList selectAll(int cpage,int count){
    16. 		ArrayList list = new ArrayList();
    17. 		ResultSet rs = null;
    18. 		Connection conn = Basedao.getconn();
    19. 		PreparedStatement ps = null;
    20. 		try {
    21. 			ps = conn.prepareStatement("select * from EASYBUY_USER order by EU_BIRTHDAY desc"+
    22. 					" limit ?, ?");
    23. 			ps.setInt(1, count*(cpage-1));
    24. 			ps.setInt(2, count);
    25. 			rs = ps.executeQuery();
    26. 			while(rs.next()){
    27. 				EASYBUY_USER u = new EASYBUY_USER(rs.getString("EU_USER_ID"),
    28. 										rs.getString("EU_USER_NAME"), 
    29. 										rs.getString("EU_PASSWORD"),
    30. 										rs.getString("EU_SEX"),
    31. 										rs.getString("EU_BIRTHDAY"),
    32. 										rs.getString("EU_IDENTITY_CODE"),
    33. 										rs.getString("EU_EMAIL"),
    34. 										rs.getString("EU_MOBILE"),
    35. 										rs.getString("EU_ADDRESS"),
    36. 										rs.getInt("EU_STATUS"));
    37. 				list.add(u);
    38. 			}
    39. 		} catch (SQLException e) {
    40. 			// TODO Auto-generated catch block
    41. 			e.printStackTrace();
    42. 		}finally {
    43. 			Basedao.closeall(rs, ps, conn);
    44. 		}
    45. 		return list;
    46. 	}
    47. 	/**
    48. 	 * 查询所有
    49. 	 * @return
    50. 	 */
    51. 	public static ArrayList selectAll(){
    52. 		ArrayList list = new ArrayList();
    53. 		ResultSet rs = null;
    54. 		Connection conn = Basedao.getconn();
    55. 		PreparedStatement ps = null;
    56. 		try {
    57. 			ps = conn.prepareStatement("select * from EASYBUY_USER");
    58. 			rs = ps.executeQuery();
    59. 			while(rs.next()){
    60. 				EASYBUY_USER u = new EASYBUY_USER(rs.getString("EU_USER_ID"),
    61. 										rs.getString("EU_USER_NAME"), 
    62. 										rs.getString("EU_PASSWORD"),
    63. 										rs.getString("EU_SEX"),
    64. 										rs.getString("EU_BIRTHDAY"),
    65. 										rs.getString("EU_IDENTITY_CODE"),
    66. 										rs.getString("EU_EMAIL"),
    67. 										rs.getString("EU_MOBILE"),
    68. 										rs.getString("EU_ADDRESS"),
    69. 										rs.getInt("EU_STATUS"));
    70. 				list.add(u);
    71. 			}
    72. 		} catch (SQLException e) {
    73. 			// TODO Auto-generated catch block
    74. 			e.printStackTrace();
    75. 		}finally {
    76. 			Basedao.closeall(rs, ps, conn);
    77. 		}
    78. 		return list;
    79. 	}
    80. 	
    81. 	/**
    82. 	 * 根据id查询单个
    83. 	 * @param id
    84. 	 * @return
    85. 	 */
    86. 	public static EASYBUY_USER selectById(String id){
    87. 		EASYBUY_USER u = null;
    88. 		ResultSet rs = null;
    89. 		Connection conn = Basedao.getconn();
    90. 		PreparedStatement ps = null;
    91. 		try {
    92. 			ps = conn.prepareStatement("select m.*,DATE_FORMAT(m.eu_birthday,'%Y-%m-%d')birthday from EASYBUY_USER m where EU_USER_ID=?");
    93. 			ps.setString(1, id);
    94. 			rs = ps.executeQuery();
    95. 			while(rs.next()){
    96. 				u = new EASYBUY_USER(rs.getString("EU_USER_ID"),
    97. 						rs.getString("EU_USER_NAME"), 
    98. 						rs.getString("EU_PASSWORD"),
    99. 						rs.getString("EU_SEX"),
    100. 						rs.getString("birthday"),
    101. 						rs.getString("EU_IDENTITY_CODE"),
    102. 						rs.getString("EU_EMAIL"),
    103. 						rs.getString("EU_MOBILE"),
    104. 						rs.getString("EU_ADDRESS"),
    105. 						rs.getInt("EU_STATUS"));
    106. 			}
    107. 		} catch (SQLException e) {
    108. 			// TODO Auto-generated catch block
    109. 			e.printStackTrace();
    110. 		}finally {
    111. 			Basedao.closeall(rs, ps, conn);
    112. 		}
    113. 		return u;
    114. 	}
    115. 	/**
    116. 	 * 查看是否有此人
    117. 	 * @param id
    118. 	 * @return
    119. 	 */
    120. 	public static int selectByName(String id){
    121. 		int count=0;
    122. 		ResultSet rs = null;
    123. 		Connection conn = Basedao.getconn();
    124. 		PreparedStatement ps = null;
    125. 		try {
    126. 			ps = conn.prepareStatement("select count(*) from EASYBUY_USER where EU_USER_ID=?");
    127. 			ps.setString(1, id);
    128. 			rs = ps.executeQuery();
    129. 			while(rs.next()){
    130. 				count=rs.getInt(1);
    131. 			}
    132. 		} catch (SQLException e) {
    133. 			e.printStackTrace();
    134. 		}finally {
    135. 			Basedao.closeall(rs, ps, conn);
    136. 		}
    137. 		return count;
    138. 	}
    139. 	/**
    140. 	 * 看用户名和密码对不对
    141. 	 */
    142. 	public static int selectByNM(String name,String pwd){
    143. 		int count=0;
    144. 		ResultSet rs = null;
    145. 		Connection conn = Basedao.getconn();
    146. 		PreparedStatement ps = null;
    147. 		try {
    148. 			ps = conn.prepareStatement("select count(*) from EASYBUY_USER where EU_USER_ID=? and EU_PASSWORD=?");
    149. 			ps.setString(1, name);
    150. 			ps.setString(2, pwd);
    151. 			rs = ps.executeQuery();
    152. 			while(rs.next()){
    153. 				count=rs.getInt(1);
    154. 			}
    155. 		} catch (SQLException e) {
    156. 			e.printStackTrace();
    157. 		}finally {
    158. 			Basedao.closeall(rs, ps, conn);
    159. 		}
    160. 		return count;
    161. 	}
    162. 	/**
    163. 	 * 判断是普通用户还是管理员
    164. 	 * @param name
    165. 	 * @param pwd
    166. 	 * @return
    167. 	 */
    168. 	public static EASYBUY_USER selectAdmin(String name,String pwd){
    169. 		EASYBUY_USER user=null;
    170. 		ResultSet rs = null;
    171. 		Connection conn = Basedao.getconn();
    172. 		PreparedStatement ps = null;
    173. 		try {
    174. 			ps = conn.prepareStatement("select * from EASYBUY_USER where EU_USER_ID=? and EU_PASSWORD=?");
    175. 			ps.setString(1, name);
    176. 			ps.setString(2, pwd);
    177. 			rs = ps.executeQuery();
    178. 			while(rs.next()){
    179. 				user = new EASYBUY_USER(rs.getString("EU_USER_ID"),
    180. 						rs.getString("EU_USER_NAME"), 
    181. 						rs.getString("EU_PASSWORD"),
    182. 						rs.getString("EU_SEX"),
    183. 						rs.getString("EU_BIRTHDAY"),
    184. 						rs.getString("EU_IDENTITY_CODE"),
    185. 						rs.getString("EU_EMAIL"),
    186. 						rs.getString("EU_MOBILE"),
    187. 						rs.getString("EU_ADDRESS"),
    188. 						rs.getInt("EU_STATUS"));
    189. 			}
    190. 		} catch (SQLException e) {
    191. 			e.printStackTrace();
    192. 		}finally {
    193. 			Basedao.closeall(rs, ps, conn);
    194. 		}
    195. 		return user;
    196. 	}
    197. 	/**
    198. 	 * 分页管理
    199. 	 * @param u
    200. 	 * @return
    201. 	 */
    202. 	public static int totalPage(int count){
    203. 		int tpage=1;
    204. 		Connection conn=Basedao.getconn();
    205. 		PreparedStatement ps=null;
    206. 		ResultSet rs=null;
    207. 		try {
    208. 			ps=conn.prepareStatement("select count(*) from EASYBUY_USER");
    209. 			rs=ps.executeQuery();
    210. 			while(rs.next()){
    211. 				int sum=rs.getInt(1);
    212. 				if(sum%count==0){
    213. 					tpage=sum/count;
    214. 				}else{
    215. 					tpage=sum/count+1;
    216. 				}
    217. 			}
    218. 		} catch (SQLException e) {
    219. 			e.printStackTrace();
    220. 		}finally{
    221. 			Basedao.closeall(rs, ps, conn);
    222. 		}
    223. 		return tpage;
    224. 	}
    225. 	public static int insert(EASYBUY_USER u){
    226. 		String sql = "insert into EASYBUY_USER values(?,?,?,?,DATE_FORMAT(?,'%Y-%m-%d'),?,?,?,?,?)";
    227. 		Object[] params = {u.getEU_USER_ID(),
    228. 							u.getEU_USER_NAME(),
    229. 							u.getEU_PASSWORD(),
    230. 							u.getEU_SEX(),
    231. 							u.getEU_BIRTHDAY(),
    232. 							u.getEU_IDENTITY_CODE(),
    233. 							u.getEU_EMAIL(),
    234. 							u.getEU_MOBILE(),
    235. 							u.getEU_ADDRESS(),
    236. 							u.getEU_STATUS()};
    237. 		return Basedao.exectuIUD(sql, params);
    238. 	}
    239. 	
    240. 	public static int update(EASYBUY_USER u){
    241. 		String sql = "update EASYBUY_USER set EU_USER_NAME=?," +
    242. 											"EU_PASSWORD=?," +
    243. 											"EU_SEX=?," +
    244. 											"EU_BIRTHDAY=DATE_FORMAT(?,'%Y-%m-%d')," +
    245. 											"EU_IDENTITY_CODE=?," +
    246. 											"EU_EMAIL=?," +
    247. 											"EU_MOBILE=?," +
    248. 											"EU_ADDRESS=?," +
    249. 											"EU_STATUS=? " +
    250. 											"where EU_USER_ID=?";
    251. 		Object[] params = {u.getEU_USER_NAME(),
    252. 							u.getEU_PASSWORD(),
    253. 							u.getEU_SEX(),
    254. 							u.getEU_BIRTHDAY(),
    255. 							u.getEU_IDENTITY_CODE(),
    256. 							u.getEU_EMAIL(),
    257. 							u.getEU_MOBILE(),
    258. 							u.getEU_ADDRESS(),
    259. 							u.getEU_STATUS(),
    260. 							u.getEU_USER_ID()};
    261. 		return Basedao.exectuIUD(sql, params);
    262. 	}
    263. 	
    264. 	public static int del(String id){
    265. 		String sql = "delete from EASYBUY_USER where EU_USER_ID=? and EU_USER_ID!='admin'";
    266. 		Object[] params = {id};
    267. 		return Basedao.exectuIUD(sql, params);
    268. 	}
    269. }

    如果也想学习本系统，下面领取。关注并回复：093jsp

  • 相关阅读:
    【大数据入门核心技术-Hadoop】（一）Hadoop简介
    开源地图库OpenLayers的简单使用
    IDEA创建完Maven工程后，右下角一直显示正在下载Maven插件
    50个常用的Java代码示例
    连接数据库
    简单聊聊ThreadLocal吧
    GCC - 基于win10平台搭建Cmake + MinGW + gcc-arm-none 开源开发环境
    C++ Reference: Standard C++ Library reference: C Library: cwctype: wctype
    安全计算环境（设备和技术注解）
    window小技巧---------电脑自动开关机/电脑自动开机后打开应用/打开浏览器后自动响应某个页面并且f12
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126965143