insertdata.java

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

/**
 * 源文件：InsertData.java
 * 作用：插入信息
 */
package mypro;

import java.sql.*;

public class InsertData
{
	private Connection con=DatabaseConnection.getConnection();
	/*插入供货商信息*/
	public boolean SuppliersInsert(SuppliersData sd)
	{
		try
		{
			String strsupp="insert [suppliers] values(?,?,?,?,?,?,?)";
			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());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入员工信息*/
	public boolean UsersInsert(UsersData ud)
	{
		try
		{
			String struser="insert [users] values(?,?,?,?,?,?,?,?)";
			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.getUserID());
			ps.setString(7,ud.getAddr());
			ps.setString(8,ud.getJoinDate());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入顾客信息*/
	public boolean CustomersInsert(CustomersData cd)
	{
		try
		{
			String strcus="insert [customers] values(?,?,?,?,?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(strcus);
			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());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入手机信息*/
	public boolean ProductsTelInsert(ProductsTelData pd)
	{
		try
		{
			String strpt="insert [productsTel] values(?,?,?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(strpt);
			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());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入进货信息*/
	public boolean StockTelInsert(StockTelData std)
	{
		try
		{
			String strsto="insert [stockTel] values(?,?,?,?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(strsto);
			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());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入销售信息*/
	public boolean SellTelInsert(SellTelData sed)
	{
		try
		{
			String strse="insert [sellTel] values(?,?,?,?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(strse);
			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());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入退货信息*/
	public boolean BackTelInsert(BackTelData bd)
	{
		try
		{
			String strba="insert [backTel] values(?,?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(strba);
			ps.setInt(1,bd.getBackInvoice());
			ps.setString(2,bd.getImei());
			ps.setString(3,bd.getBackDate());
			ps.setString(4,bd.getUserCode());
			ps.setString(5,bd.getReason());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
	/*插入调换信息*/
	public boolean ChangeTelInsert(ChangeTelData chd)
	{
		try
		{
			String strch="insert [changeTel] values(?,?,?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(strch);
			ps.setInt(1,chd.getChangeInvoice());
			ps.setString(2,chd.getOldImei());
			ps.setString(3,chd.getNewImei());
			ps.setString(4,chd.getChangeDate());
			ps.setString(5,chd.getUserCode());
			ps.setString(6,chd.getReason());
			int count=ps.executeUpdate();
			ps.close();
			if(count<1)
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		catch(SQLException sqle)
		{
			return false;
		}
	}
}