基于java+mysql的swing+java+mysql餐厅在线点餐系统(管理员、用户)

该博客介绍了基于Java和MySQL的餐厅在线点餐系统,含管理员和用户端。运行环境要求Java≥8、MySQL≥5.7,开发工具可选eclipse等。适用于课程设计等,还说明了后台管理和前台点餐的账号密码。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

基于java+mysql的swing+java+mysql餐厅在线点餐系统(管理员、用户)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

后台管理

admin/123456

前台点餐

user1/123456

基于java+mysql的Swing+Java+MySQL餐厅在线点餐系统(管理员、用户)

		jPanel1.setLayout(jPanel1Layout);
		jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(
				javax.swing.GroupLayout.Alignment.LEADING).addGroup(
				javax.swing.GroupLayout.Alignment.TRAILING,
				jPanel1Layout.createSequentialGroup().addContainerGap(23,
						Short.MAX_VALUE).addComponent(iamgeLb,
						javax.swing.GroupLayout.PREFERRED_SIZE, 60,
						javax.swing.GroupLayout.PREFERRED_SIZE).addGap(21, 21,
						21)));
		jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(
				javax.swing.GroupLayout.Alignment.LEADING).addGroup(
				jPanel1Layout.createSequentialGroup().addContainerGap()
						.addComponent(iamgeLb,
								javax.swing.GroupLayout.PREFERRED_SIZE, 60,
								javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(26, Short.MAX_VALUE)));

		imageLinkTxt.setEditable(false);

		jLabel5.setText("\u5957\u9910\u56fe\u7247\uff1a");

		goodsDescTxt.setColumns(20);
		goodsDescTxt.setRows(5);
		jScrollPane1.setViewportView(goodsDescTxt);

		jb_add.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/add.png"))); // NOI18N
		jb_add.setText("\u6dfb\u52a0");
		jb_add.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_addActionPerformed(evt);
			}
		});

		jb_reset.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/reset.png"))); // NOI18N
		jb_reset.setText("\u91cd\u7f6e");
		jb_reset.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_resetActionPerformed(evt);
		//在表单中写入选中的数据
		this.goodsIdTxt.setText((String) goodsTable.getValueAt(row, 0));
		this.goodsNameTxt.setText((String) goodsTable.getValueAt(row, 1));
		this.goodsDescTxt.setText((String) goodsTable.getValueAt(row, 2));
		this.priceTxt.setText((String) goodsTable.getValueAt(row, 3));
		this.imageLinkTxt.setText((String) goodsTable.getValueAt(row, 4));
		String picturePath = (String) goodsTable.getValueAt(row, 4);
		if (StringUtil.isNotEmpty(picturePath)) {
			Icon icon = new ImageIcon(picturePath);
			this.iamgeLb.setIcon(icon);
		} else {
			this.iamgeLb.setIcon(null);
		}
	}

	//搜索操作
	private void jb_searchActionPerformed(java.awt.event.ActionEvent evt) {
		Goods goods = new Goods();
		String s_goodsName = this.s_goodsName.getText();
		String s_price1 = this.s_price_1.getText();
		String s_price2 = this.s_price_2.getText();
		if (StringUtil.isNotEmpty(s_price1)) {//price_1低价格非空
			if(!StringUtil.isNum(s_price1)){
				JOptionPane.showMessageDialog(null, "请重新输入套餐价格范围");
				return;
			}else{
				goods.setPrice1(Float.parseFloat(s_price1));
			}
		}
		if (StringUtil.isNotEmpty(s_price2)) {//price_2高价格非空
			if(!StringUtil.isNum(s_price2)){
				JOptionPane.showMessageDialog(null, "请重新输入套餐价格范围");
				return;
			}else{
				goods.setPrice(Float.parseFloat(s_price2));
			}
		}	 
		 if (StringUtil.isNotEmpty(s_price1) && StringUtil.isNotEmpty(s_price2)) {//若都为非空
			if(goods.getPrice()<goods.getPrice1()){
				JOptionPane.showMessageDialog(null, "请重新输入套餐价格范围");
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(jLabel3)
														.addComponent(
																passwordTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addPreferredGap(
												javax.swing.LayoutStyle.ComponentPlacement.RELATED,
												javax.swing.GroupLayout.DEFAULT_SIZE,
												Short.MAX_VALUE)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(jLabel4)
														.addComponent(
																passwordConfirmTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addPreferredGap(
												javax.swing.LayoutStyle.ComponentPlacement.RELATED)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(
																emailTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE)
														.addComponent(jLabel5))
										.addGap(28, 28, 28)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(
																jb_register)
														.addComponent(jb_reset))
										.addGap(55, 55, 55)));

		pack();
		this.totalMoneyTxt.setText("");
		this.userNameTxt.setText("");
		this.orderStatusTxt.setText("");
		this.iamgeLb.setIcon(null);
		DefaultTableModel dtm = (DefaultTableModel) cartTable.getModel();
		dtm.setRowCount(0);

	}

	//订单处理操作
	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
		//获取选中的行
		int row = orderTable.getSelectedRow();
		if (row < 0) {
			JOptionPane.showMessageDialog(null, "请选择一个订单");
			return;
		}
		//获取订单编号
		String orderId = (String) orderTable.getValueAt(row, 0);
		Order order = new Order();
		order.setOrderId(orderId);
		//
		String orderStatus = this.orderStatusTxt.getText();
		int statusNum = 0;//是否为删除订单或者处理订单的标志位
		if (this.jrb_1.isSelected()) {//确定订单
			orderStatus = "烹饪中";
			order.setOrderStatus(1);
		} else if (this.jrb_2.isSelected()) {//去送餐
			orderStatus = "已送达";
			order.setOrderStatus(2);
		} else if (this.jrb_3.isSelected()) {//已付款
			orderStatus = "已付款";
			order.setOrderStatus(3);
		} else if (this.jrb_4.isSelected()) {//删除订单
			orderStatus = "";
			statusNum = 1;
		} else {
			return;
		}

		if (statusNum != 1) {
			try {
				Connection con = dbUtil.getCon();
																																javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																														.addComponent(
																																jLabel2)
																														.addPreferredGap(
																																javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																														.addComponent(
																																totalNumTxt,
																																javax.swing.GroupLayout.PREFERRED_SIZE,
																																76,
																																javax.swing.GroupLayout.PREFERRED_SIZE))
																										.addGroup(
																												layout
																														.createSequentialGroup()
																														.addGroup(
																																layout
																																		.createParallelGroup(
																																				javax.swing.GroupLayout.Alignment.LEADING)
																																		.addComponent(
																																				jrb_1)
																																		.addComponent(
																																				jrb_3))
																														.addGap(
																																12,
																																12,
																																12)
																														.addGroup(
																																layout
																																		.createParallelGroup(
																																				javax.swing.GroupLayout.Alignment.LEADING)
																																		.addComponent(
																																				jrb_2)
																																		.addComponent(
																																				jrb_4))
																														.addPreferredGap(
																																javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																														.addComponent(
																																jButton1))
																										.addComponent(
																												jb_status))
																						.addPreferredGap(
																								javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																						.addGroup(
																								layout
																										.createParallelGroup(
																												javax.swing.GroupLayout.Alignment.TRAILING)
																										.addGroup(
																												layout
																														.createSequentialGroup()
																														.addComponent(
																																jLabel1)
																														.addPreferredGap(
				switch (status) {
				case 0:
					v.add("未处理");
					break;
				case 1:
					v.add("烹饪中");
					break;
				case 2:
					v.add("已送达");
					break;
				case 3:
					v.add("已付款");
					break;
				case 4:
					v.add("已取消");
				}

				dtm.addRow(v);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				dbUtil.closeCon(con);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

	//重置carttable
	private void resetCartTable() {

		this.totalNumTxt.setText("");
		this.totalMoneyTxt.setText("");
		this.userNameTxt.setText("");
		this.orderStatusTxt.setText("");
		this.iamgeLb.setIcon(null);
		DefaultTableModel dtm = (DefaultTableModel) cartTable.getModel();
		dtm.setRowCount(0);

	}

	//订单处理操作
	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
		//获取选中的行
										.addGroup(
												jPanel1Layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.LEADING)
														.addGroup(
																jPanel1Layout
																		.createSequentialGroup()
																		.addGroup(
																				jPanel1Layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.LEADING)
																						.addComponent(
																								jLabel5)
																						.addComponent(
																								jb_chooser))
																		.addPreferredGap(
																				javax.swing.LayoutStyle.ComponentPlacement.RELATED,
																				96,
																				Short.MAX_VALUE)
																		.addGroup(
																				jPanel1Layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.BASELINE)
																						.addComponent(
																								jb_delete)
																						.addComponent(
																								jb_modify)))
														.addComponent(
																jScrollPane2,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE)
														.addComponent(
																jPanel2,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																87,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addContainerGap()));

		jLabel8.setText("\u2014\u2014");

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(
				getContentPane());
		getContentPane().setLayout(layout);
		layout
				.setHorizontalGroup(layout
						.createParallelGroup(
								javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(
								layout
										.createSequentialGroup()
										.addGroup(
																								jPanel2,
																								javax.swing.GroupLayout.PREFERRED_SIZE,
																								85,
																								javax.swing.GroupLayout.PREFERRED_SIZE)
																						.addComponent(
																								jb_modify))
																		.addGroup(
																				jPanel1Layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.LEADING)
																						.addComponent(
																								jb_delete,
																								javax.swing.GroupLayout.Alignment.TRAILING)
																						.addGroup(
																								jPanel1Layout
																										.createSequentialGroup()
																										.addGap(
																												30,
																												30,
																												30)
																										.addComponent(
																												jb_chooser))))
														.addComponent(
																imageLinkTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																214,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addContainerGap()));
		jPanel1Layout
				.setVerticalGroup(jPanel1Layout
						.createParallelGroup(
								javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(
								jPanel1Layout
										.createSequentialGroup()
										.addGap(20, 20, 20)
										.addGroup(
												jPanel1Layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.LEADING)
														.addComponent(jLabel3)
														.addGroup(
																jPanel1Layout
																		.createParallelGroup(
	// End of variables declaration//GEN-END:variables

}
/*
 * RegisterFrm.java
 *
 * Created on __DATE__, __TIME__
 */

/**
 *
 */
public class RegisterFrm extends javax.swing.JFrame {
	DbUtil dbUtil = new DbUtil();
	UserDao userDao = new UserDao();

	/** Creates new form RegisterFrm */
	public RegisterFrm() {
		initComponents();
		//设置frame居中显示
		this.setLocationRelativeTo(null);
	}

	/** This method is called from within the constructor to
	 * initialize the form.
	 * WARNING: Do NOT modify this code. The content of this method is
	 * always regenerated by the Form Editor.
	 */
	//GEN-BEGIN:initComponents
	// <editor-fold defaultstate="collapsed" desc="Generated Code">
	private void initComponents() {

		this.userName = userName;
	}
	public Order(String orderId, float goodsTotalPrice, int goodsId,
			float goodsPrice, int goodsNum, String goodsName) {
		super();
		this.orderId = orderId;
		this.goodsTotalPrice = goodsTotalPrice;
		this.goodsId = goodsId;
		this.goodsPrice = goodsPrice;
		this.goodsNum = goodsNum;
		this.goodsName = goodsName;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getOrderId() {
		return orderId;
	}
	public void setOrderId(String orderId) {
		this.orderId = orderId;
	}
	public float getGoodsTotalPrice() {
		return goodsTotalPrice;
	}
	public void setGoodsTotalPrice(float goodsTotalPrice) {
		this.goodsTotalPrice = goodsTotalPrice;
	}
	public int getGoodsId() {
		return goodsId;
	}
	public void setGoodsId(int goodsId) {
		this.goodsId = goodsId;
	}
	public float getGoodsPrice() {
		return goodsPrice;
	}
	public void setGoodsPrice(float goodsPrice) {
		this.goodsPrice = goodsPrice;
	}
	public int getGoodsNum() {
		return goodsNum;
	}
	public void setGoodsNum(int goodsNum) {
		this.goodsNum = goodsNum;
	}
	public String getGoodsName() {
		return goodsName;
	}
				"/images/password_config.png"))); // NOI18N
		jLabel4.setText("\u786e\u8ba4\u5bc6\u7801\uff1a");

		jLabel5.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/email.png"))); // NOI18N
		jLabel5.setText("\u90ae\u7bb1\uff1a");

		jb_register.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/register.png"))); // NOI18N
		jb_register.setText("\u6ce8\u518c");
		jb_register.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_registerActionPerformed(evt);
			}
		});

		jb_reset.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/reset.png"))); // NOI18N
		jb_reset.setText("\u91cd\u7f6e");
		jb_reset.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_resetActionPerformed(evt);
			}
		});

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(
				getContentPane());
		getContentPane().setLayout(layout);
		layout
				.setHorizontalGroup(layout
						.createParallelGroup(
								javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(
								layout
										.createSequentialGroup()
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.LEADING)
														.addGroup(
																layout
																		.createSequentialGroup()
																		.addGap(
		setTitle("\u70b9\u9910\u7cfb\u7edf\u7ba1\u7406\u4e3b\u754c\u9762");

		jMenu1.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/base.png"))); // NOI18N
		jMenu1.setText("\u5957\u9910\u4fe1\u606f\u7ba1\u7406");

		jmiGoodsAdd.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/add.png"))); // NOI18N
		jmiGoodsAdd.setText("\u65b0\u589e\u5957\u9910");
		jmiGoodsAdd.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jmiGoodsAddActionPerformed(evt);
			}
		});
		jMenu1.add(jmiGoodsAdd);

		jmiGoodsManage.setIcon(new javax.swing.ImageIcon(getClass()
				.getResource("/images/edit.png"))); // NOI18N
		jmiGoodsManage.setText("\u5957\u9910\u7ef4\u62a4");
		jmiGoodsManage.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jmiGoodsManageActionPerformed(evt);
			}
		});
		jMenu1.add(jmiGoodsManage);

		jMenuBar1.add(jMenu1);

		jMenu3.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/bookManager.png"))); // NOI18N
		jMenu3.setText("\u8ba2\u5355\u7ba1\u7406");

		jmiDealOrder.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/order2.png"))); // NOI18N
		jmiDealOrder.setText("\u8ba2\u5355\u5904\u7406");
		jmiDealOrder.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jmiDealOrderActionPerformed(evt);
			}
		});
		jMenu3.add(jmiDealOrder);

		jMenuBar1.add(jMenu3);

		jMenu4.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/about.png"))); // NOI18N
		jMenu4.setText("\u5176\u4ed6");

		jmiModify.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/modify.png"))); // NOI18N
		jmiModify.setText("\u4fee\u6539\u5bc6\u7801");
		jmiModify.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jmiModifyActionPerformed(evt);
																		.addComponent(
																				imageLinkTxt,
																				javax.swing.GroupLayout.PREFERRED_SIZE,
																				javax.swing.GroupLayout.DEFAULT_SIZE,
																				javax.swing.GroupLayout.PREFERRED_SIZE)
																		.addComponent(
																				goodsIdTxt,
																				javax.swing.GroupLayout.PREFERRED_SIZE,
																				javax.swing.GroupLayout.DEFAULT_SIZE,
																				javax.swing.GroupLayout.PREFERRED_SIZE)))
										.addGap(33, 33, 33)
										.addGroup(
												jPanel1Layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.LEADING)
														.addGroup(
																jPanel1Layout
																		.createSequentialGroup()
																		.addGroup(
																				jPanel1Layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.LEADING)
																						.addComponent(
																								jLabel5)
																						.addComponent(
																								jb_chooser))
																		.addPreferredGap(
																				javax.swing.LayoutStyle.ComponentPlacement.RELATED,
																				96,
																				Short.MAX_VALUE)
																		.addGroup(
																				jPanel1Layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.BASELINE)
																						.addComponent(
																								jb_delete)
																						.addComponent(
																								jb_modify)))
														.addComponent(
																jScrollPane2,
																javax.swing.GroupLayout.PREFERRED_SIZE,
										.addGap(18, 18, 18)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(jLabel2)
														.addComponent(
																oldPasswordTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addGap(18, 18, 18)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(jLabel3)
														.addComponent(
																newPasswordTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addGap(12, 12, 12)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(jLabel4)
														.addComponent(
																newPasswordConfirmTxt,
																javax.swing.GroupLayout.PREFERRED_SIZE,
																javax.swing.GroupLayout.DEFAULT_SIZE,
																javax.swing.GroupLayout.PREFERRED_SIZE))
										.addGap(30, 30, 30)
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.BASELINE)
														.addComponent(jb_modify)
														.addComponent(jb_reset))
										.addGap(40, 40, 40)));

		pack();
																						.addComponent(
																								jLabel2)
																						.addComponent(
																								jLabel3)
																						.addComponent(
																								jLabel4))
																		.addGap(
																				35,
																				35,
																				35)
																		.addGroup(
																				layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.TRAILING,
																								false)
																						.addComponent(
																								newPasswordConfirmTxt,
																								javax.swing.GroupLayout.Alignment.LEADING)
																						.addComponent(
																								newPasswordTxt,
																								javax.swing.GroupLayout.Alignment.LEADING)
																						.addComponent(
																								oldPasswordTxt,
																								javax.swing.GroupLayout.Alignment.LEADING)
																						.addComponent(
																								userNameTxt,
																								javax.swing.GroupLayout.Alignment.LEADING,
																								javax.swing.GroupLayout.DEFAULT_SIZE,
																								127,
																								Short.MAX_VALUE)))
														.addGroup(
																layout
																		.createSequentialGroup()
																		.addGap(
																				47,
																				47,
																				47)
																		.addComponent(
																				jb_modify)
																		.addGap(
																				18,
																				18,
																				18)
																		.addComponent(
																				jb_reset,
																				javax.swing.GroupLayout.DEFAULT_SIZE,
																				javax.swing.GroupLayout.DEFAULT_SIZE,
		if(rs.next()){
			resultUser = new User();
			resultUser.setUserName(rs.getString("userName"));
			resultUser.setPassword(rs.getString("password"));
			resultUser.setRank(rs.getInt("rank"));
			resultUser.setId(rs.getInt("id"));
		}
		return resultUser;
	}
	public int userAdd(Connection con,User user) throws Exception{
		String sql="insert into `user` values(null,?,?,?,?)";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		pstmt.setString(2, user.getPassword());
		pstmt.setString(3, user.getEmail());
		pstmt.setInt(4, user.getRank());
		return pstmt.executeUpdate();
	}
	public boolean isUserExist(Connection con,User user) throws Exception{
		String sql="select *from user where userName=?";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		ResultSet rs =pstmt.executeQuery();
		return rs.next();
	}
	
	public int userModify(Connection con,User user) throws Exception{
		String sql="update `user` set userName=?,password=?,email=? where id=?";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		pstmt.setString(2, user.getPassword());
		pstmt.setString(3, user.getEmail());
		pstmt.setInt(4, user.getId());;
		return pstmt.executeUpdate();
	}
}

public class StringUtil {
	public static boolean isEmpty(String str){
		if("".equals(str)||str==null){
			return true;
		}else{
			return false;
		}
	}
																														.addPreferredGap(
																																javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																														.addComponent(
																																totalMoneyTxt,
																																javax.swing.GroupLayout.PREFERRED_SIZE,
																																81,
																																javax.swing.GroupLayout.PREFERRED_SIZE))
																										.addComponent(
																												jPanel2,
																												javax.swing.GroupLayout.PREFERRED_SIZE,
																												javax.swing.GroupLayout.DEFAULT_SIZE,
																												javax.swing.GroupLayout.PREFERRED_SIZE))))
														.addGroup(
																layout
																		.createSequentialGroup()
																		.addPreferredGap(
																				javax.swing.LayoutStyle.ComponentPlacement.RELATED)
																		.addComponent(
																				jScrollPane2,
																				javax.swing.GroupLayout.PREFERRED_SIZE,
																				510,
																				javax.swing.GroupLayout.PREFERRED_SIZE)))
										.addContainerGap()));
		layout
				.setVerticalGroup(layout
						.createParallelGroup(
								javax.swing.GroupLayout.Alignment.LEADING)
						.addGroup(
								layout
										.createSequentialGroup()
										.addGroup(
												layout
														.createParallelGroup(
																javax.swing.GroupLayout.Alignment.LEADING)
														.addGroup(
																layout
																		.createSequentialGroup()
																		.addGap(
																				18,
																				18,
																				18)
																		.addGroup(
																				layout
																						.createParallelGroup(
																								javax.swing.GroupLayout.Alignment.BASELINE)
																						.addComponent(
																								orderIdTxt,
																								javax.swing.GroupLayout.PREFERRED_SIZE,
																								javax.swing.GroupLayout.DEFAULT_SIZE,

		jLabel1 = new javax.swing.JLabel();
		jLabel2 = new javax.swing.JLabel();
		jLabel3 = new javax.swing.JLabel();
		jb_logon = new javax.swing.JButton();
		jb_register = new javax.swing.JButton();
		userNameTxt = new javax.swing.JTextField();
		passwordTxt = new javax.swing.JPasswordField();
		jb_reset = new javax.swing.JButton();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
		setTitle("\u9910\u5385\u70b9\u9910\u7cfb\u7edf");
		setResizable(false);

		jLabel1.setFont(new java.awt.Font("宋体", 1, 24));
		jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/OrderMeal.png"))); // NOI18N
		jLabel1
				.setText("\u9910\u5385\u70b9\u9910\u7cfb\u7edf\u6b22\u8fce\u60a8");

		jLabel2.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/userName.png"))); // NOI18N
		jLabel2.setText("\u7528\u6237\u540d\uff1a");

		jLabel3.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/password.png"))); // NOI18N
		jLabel3.setText("\u5bc6  \u7801\uff1a");

		jb_logon.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/login.png"))); // NOI18N
		jb_logon.setText("\u767b\u9646");
		jb_logon.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_logonActionPerformed(evt);
			}
		});

		jb_register.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/register.png"))); // NOI18N
		jb_register.setText("\u6ce8\u518c\u7528\u6237");
		jb_register.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_registerActionPerformed(evt);
			}
		});

		jb_reset.setIcon(new javax.swing.ImageIcon(getClass().getResource(
				"/images/reset.png"))); // NOI18N
		jb_reset.setText("\u91cd\u7f6e");
		jb_reset.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jb_resetActionPerformed(evt);
			}
		});

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值