updatedata.java

用java编写的人事管理系统,很好的 学习下吧

/**
 * 源文件：UpdateData.java
 * 作用：更新
 */
package mypro;

import java.sql.*;

public class UpdateData
{
	private Connection con=DatabaseConnection.getConnection();
	
	public boolean suppliersUpdate(SuppliersData sd,String strtable)
	{
		try
		{
			String strsupp="Update [suppliers] set 供货商代码=?,公司名称=?,公司电话=?,传真号码=?,联系人姓名=?,联系人电话=?,公司地址=? where 供货商代码=?";
			PreparedStatement ps=con.prepareStatement(strsupp);
			ps.setString(1,sd.getSupplierBrief());
			ps.setString(2,sd.getCompany());
			ps.setString(3,sd.getTel());
			ps.setString(4,sd.getFax());
			ps.setString(5,sd.getContactName());
			ps.setString(6,sd.getContactTel());
			ps.setString(7,sd.getAddr());
			ps.setString(8,strtable);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	public boolean passwordUpdate(String strcode,String strOldPwd,String strNewPwd)
	{
		try
		{
			String strPwd="update [users] set 用户密码=? where 工号=? and 用户密码=?";
			PreparedStatement ps=con.prepareStatement(strPwd);
			ps.setString(1,strNewPwd);
			ps.setString(2,strcode);
			ps.setString(3,strOldPwd);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	public boolean usersUpdate(UsersData ud,String strtable)
	{
		try
		{
			String struser="Update [users] set 工号=?,员工姓名=?,用户密码=?,性别=?,联系电话=?,身份证号码=?,家庭住址=?,加入公司日期=? where 工号=?";
			PreparedStatement ps=con.prepareStatement(struser);
			ps.setString(1,ud.getUserCode());
			ps.setString(2,ud.getUserName());
			ps.setString(3,ud.getPwd());
			ps.setString(4,ud.getSex());
			ps.setString(5,ud.getTel());
			ps.setString(6,ud.getUserCode());
			ps.setString(7,ud.getAddr());
			ps.setString(8,ud.getJoinDate());
			ps.setString(9,strtable);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	public boolean customersUpdate(CustomersData cd,int strtable)
	{
		try
		{
			String strcust="Update [customers] set 顾客编号=?,顾客姓名=?,性别=?,联系电话=?,身份证号码=?,电子邮箱=?,家庭住址=?,邮政编码=? where 顾客编号=?";
			PreparedStatement ps=con.prepareStatement(strcust);
			ps.setInt(1,cd.getCustomerCode());
			ps.setString(2,cd.getCustomerName());
			ps.setString(3,cd.getSex());
			ps.setString(4,cd.getTel());
			ps.setString(5,cd.getCustomerID());
			ps.setString(6,cd.getEmail());
			ps.setString(7,cd.getAddr());
			ps.setString(8,cd.getPostalCode());
			ps.setInt(9,strtable);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	public boolean productstelUpdate(ProductsTelData pd,String strtable)
	{
		try
		{
			String strcust="Update [productsTel] set 手机串号=?,品牌=?,颜色=?,型号=?,状态=?,供货商代码=? where 手机串号=?";
			PreparedStatement ps=con.prepareStatement(strcust);
			ps.setString(1,pd.getImei());
			ps.setString(2,pd.getMsn());
			ps.setString(3,pd.getColor());
			ps.setString(4,pd.getmModel());
			ps.setString(5,pd.getState());
			ps.setString(6,pd.getSupplierBrief());
			ps.setString(7,strtable);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	public boolean stockTelUpdate(StockTelData std,String strtable)
	{
		try
		{
			String strstock="Update [stockTel] set 进货单号=?,手机串号=?,单价=?,进货日期=?,工号=?,供货商代码=?,备注信息=? where 手机串号=?";
			PreparedStatement ps=con.prepareStatement(strstock);
			ps.setInt(1,std.getStockInvoice());
			ps.setString(2,std.getImei());
			ps.setDouble(3,std.getUnitPrice());
			ps.setString(4,std.getStockDate());
			ps.setString(5,std.getUserCode());
			ps.setString(6,std.getSupplierBrief());
			ps.setString(7,std.getContents());
			ps.setString(8,strtable);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	public boolean sellTelUpdate(SellTelData sed,String strtable)
	{
		try
		{
			String strstock="Update [sellTel] set 销售单号=?,手机串号=?,单价=?,销售日期=?,工号=?,顾客编号=?,备注信息=? where 手机串号=?";
			PreparedStatement ps=con.prepareStatement(strstock);
			ps.setInt(1,sed.getSellInvoice());
			ps.setString(2,sed.getImei());
			ps.setDouble(3,sed.getSellPrice());
			ps.setString(4,sed.getSellDate());
			ps.setString(5,sed.getUserCode());
			ps.setInt(6,sed.getCustomerCode());
			ps.setString(7,sed.getContents());
			ps.setString(8,strtable);
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
}