package supercms;
import superdb.*;
import supershopmanager.*;

import java.sql.*;
import java.util.*;
/*
 * 完成對供貨商信息的插入
 * 修改
 * 刪除
 * 
 * 
 * 
 * 
 * */
public class FormInfoManager {
	private SuperDBConn sdb;
	private SuperInfoManager sim;
	private Statement stmt;
	
	public FormInfoManager()
	{
		sdb=new SuperDBConn();
		sim=new SuperInfoManager(sdb.getConn());
		stmt=sim.getStmt();
	}
	
/*---------------------完成對供貨商信息的插入--------------------*/
	public void addFormInfo(FormInfo formInfo)
	{
		String sql="insert into forminfo(formname," +
				"formshortname,linkman," +
				"duty,formaddress,telephone," +
				"postcode,fax,mailbox," +
				"remarks)values('"+formInfo.getFormname()+"'," +
				"'"+formInfo.getFormshortname()+"','"+formInfo.getLinkman()+"','"+formInfo.getDuty()+"'," +
				"'"+formInfo.getFormadress()+"','"+formInfo.getTelephone()+"','"+formInfo.getPostcode()+"'," +
				"'"+formInfo.getFax()+"','"+formInfo.getMailbox()+"'," +
				"'"+formInfo.getRemarks()+"')";
		try
		{
		stmt.executeUpdate(sql);
		System.out.println("供貨商信息插入-----成功！！！！！");
		}catch(Exception e)
		{
			e.printStackTrace();
			System.out.println("供貨商信息插入-----失敗！！！！！");
		}
		
		
	}
	/*----------完成對供貨商信息的修改----------*/
	public void updateFormInfo(FormInfo formInfo)
	{
		String sql="update forminfo set formname='"+formInfo.getFormname()+"'," +
				"formshortname='"+formInfo.getFormshortname()+"',linkman='"+formInfo.getLinkman()+"'," +
				"duty='"+formInfo.getDuty()+"',formaddress='"+formInfo.getFormadress()+"'," +
				"telephone='"+formInfo.getTelephone()+"'," +
				"postcode='"+formInfo.getPostcode()+"'," +
				"fax='"+formInfo.getFax()+"',mailbox='"+formInfo.getMailbox()+"'," +
				"remarks='"+formInfo.getRemarks()+"' where id="+formInfo.getId();
		try
		{
		stmt.executeUpdate(sql);
		System.out.println("供貨商信息修改-----成功！！！！！");
		
		}catch(Exception e)
		{
			System.out.println("供貨商信息修改-----失敗！！！！！");
		}
	}
	/*----------完成對供貨商信息的刪除----------*/
	public void deleteFormInfo(FormInfo formInfo)
	{
		String sql="delete from forminfo where id="+formInfo.getId();
		try
		{
		stmt.executeUpdate(sql);
		System.out.println("供貨商信息刪除-----成功！！！！！");
		}catch(Exception e)
		{
			System.out.println("供貨商信息刪除-----失敗！！！！！");
		}
	
	}
	 /*------查詢分頁-----*/
	  
	public List getAllInfo(int pagesize,int nowpage) throws Exception
	{List allinfo=new ArrayList();
	String sql="select * from forminfo order by id";	
	  ResultSet rs=stmt.executeQuery(sql);
	  rs.last();// 定位到最后一條記錄
	  int rows=rs.getRow();
	  int num=pagesize;
	  int pagecount=rows/pagesize;//總頁數(shù)
	  if(rows%pagesize>0){pagecount++;}
	  if(nowpage>0&&nowpage<=pagecount)
	  {
		if(nowpage==1){rs.beforeFirst();}
		if(nowpage>1){rs.absolute((nowpage-1)*pagesize);}
	  while(rs.next()&&num>0)
	  { 
		  FormInfo fi=new FormInfo();
		  fi.setId(rs.getInt("id"));
		  fi.setFormname(rs.getString("formname"));
		  fi.setFormshortname(rs.getString("formshortname"));
		  fi.setLinkman(rs.getString("linkman"));
		  fi.setDuty(rs.getString("duty"));
		  fi.setFormadress(rs.getString("formaddress"));
		  fi.setTelephone(rs.getString("telephone"));
		fi.setPostcode(rs.getString("postcode"));
		fi.setFax(rs.getString("fax"));
		fi.setMailbox(rs.getString("mailbox"));
		fi.setRemarks(rs.getString("remarks"));
		  
	    num--;
	    allinfo.add(fi);
	  }
	  return allinfo;
	 }
	  return null;
	}
  
	public int getcount()throws Exception
	{
		int count=0;
		String sql="select * from forminfo order by id";
		 ResultSet rs=stmt.executeQuery(sql);
		 rs.last();
		 count=rs.getRow();
		return count;
	}
	
}