package product1;
import java.sql.*;
import java.io.*;
import java.util.Date;

public class product

{
	private String id;
	private String name;
	private String date;
	private String address;
	private String keep;
	private float price;
	private int mount;
	Connection con;
	
	public String getId()
	{
		return id;
	}
	
	public void setname(String name)
	{
		this.name=name;
	}
	public void setdate(String date)
	{
		this.date=date;
	}
	public void setaddress(String address)
	{
		this.address=address;
	}
	public void setkeep(String keep)
	{
		this.keep=keep;
	}
	public void setprice(float price)
	{
		this.price=price;
	}
	public void setmount(int mount)
	{
		this.mount=mount;
	}
	
	public String getname()
	{
		return name;
	}
	public String getdate()
	{
		return date;
	}
	public String getaddress()
	{
		return address;
	}
	public String getkeep()
	{
		return keep;
	}
	public float getprice()
	{
		return price;
	}
	public int getmount()
	{
		return mount;
	}
	
	public void addproduct()throws Exception        //增加數據
	{
		PreparedStatement pstmt=con.prepareStatement("insert into product values(?,?,?,?,?,?)");
		pstmt.setString(1,name);
		pstmt.setString(2,date);
		pstmt.setString(3,address);
		pstmt.setString(4,keep);
		pstmt.setFloat(5,price);
		pstmt.setInt(6,mount);
		pstmt.execute();
		pstmt.close();
	}
	
	public ResultSet find()throws Exception         //查找數據
	{
		try
		{
	       Statement stm=con.createStatement();
	       ResultSet result=stm.executeQuery("select * from product");
	       
	       return result;
	    }catch(Exception e)
	    {
	 	  return null;
	    }
	}
	public product()
	{
		String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String servanddb="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=product";
		String user="sa";
		String pwd="sa";
		try
		{
			Class.forName(classforname);
			con=DriverManager.getConnection(servanddb,user,pwd);
		}catch(Exception e)
		{}
	}
	
	public ResultSet findnum1(String name1)throws Exception
	{
		try
		{
			Statement stm=con.createStatement();
			ResultSet rest=stm.executeQuery("select * from product where name='"+name1+"'");
			return rest;
		}catch(Exception e)
		{
			return null;
			}
		
	}
	
	public void update(String name,String date,String address,String keep,String price,String mount,String shi)
	{
		try
		{
			Statement stm=con.createStatement();
			int col=stm.executeUpdate("update product set name='"+name+"',date='"+date+"',address='"+address+"',keep='"+keep+"',price='"+price+"',mount='"+mount+"' where name='"+shi+"'");
			
		}catch(Exception e)
		{
			
		}
	}
	
	public void delete(String id)
	{			 
		try
		{
			Statement stm=con.createStatement();
			stm.execute("delete  from product where name='"+id+"'");
			stm.close();
			
			
			
		}catch(Exception e)
		{}
}		
}