package bookmanager;
import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.awt.BorderLayout;
import java.sql.*;

public class BookReturn extends JFrame implements ActionListener
{
	public BookReturn()
	{
		setTitle("書籍還入");
		setSize(200,200);
		gl=new GridLayout(4,2,20,20);
		gl2=new GridLayout(1,3,20,20);
		JPanel panel=new JPanel();
		JPanel panel2=new JPanel();
		panel.setLayout(gl);
		panel2.setLayout(gl2);
		namelbl=new JLabel("還書人編號");
		nametex=new JTextField("");
		booknamelbl=new JLabel("書編號");
		booknametex=new JTextField("");
		datelbl=new JLabel("日期");
		datetex=new JTextField("");
		detaillbl=new JLabel("備注");
		detailtex=new JTextField("");
		cleanbtn=new JButton("清除");
		surebtn=new JButton("確定");
		cancelbtn=new JButton("退出");
		panel.add(namelbl);
		panel.add(nametex);
		panel.add(booknamelbl);
		panel.add(booknametex);
		panel.add(datelbl);
		panel.add(datetex);
		panel.add(detaillbl);
		panel.add(detailtex);
		panel2.add(cleanbtn);
		panel2.add(surebtn);
		panel2.add(cancelbtn);
		cleanbtn.addActionListener(this);
		surebtn.addActionListener(this);
		cancelbtn.addActionListener(this);
		getContentPane().add(panel,BorderLayout.CENTER);
		getContentPane().add(panel2,BorderLayout.SOUTH);
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==cleanbtn)
		{
			nametex.setText("");
			booknametex.setText("");
			detailtex.setText("");
			datetex.setText("");
		}
		if(source==cancelbtn)
		{
			this.dispose();
		}
		if(source==surebtn)
		{
			String bookid=booknametex.getText().trim();
			
			String userid=nametex.getText().trim();
			
			String returndate=datetex.getText().trim();
			String detail=detailtex.getText().trim();
			//判斷條件是否齊全
			if((bookid.equals(""))||(userid.equals(""))||(returndate.equals("")))
			{
				JOptionPane.showMessageDialog(null,"前三項不能為空");
				return;
			}
			Long intbookid=new Long(bookid);
			Long intuserid=new Long(userid);
			//判斷輸入信息是否有效
			String sql;
			sql=("select * from borrow where userid="+intuserid+" and bookid="+intbookid );
			rs=db.getResult(sql);
			boolean isexist=false;
			try
			{
			//把游標指向結果集的第一行，如果沒有數據則返回false
			isexist=rs.first();		
			}
			catch(SQLException w)
			{
				System.out.println(w);
			}
				//判斷結果是否正確
				if(!isexist)
				{
					JOptionPane.showMessageDialog(null,"沒有相關資料");
					nametex.setText("");
					booknametex.setText("");
					return;
				}
				try
				{
					namelbl.setText("用戶名");
					booknamelbl.setText("書名");
					borrowid=Long.valueOf(rs.getString(1));
					booknametex.setText(rs.getString(3));
					nametex.setText(rs.getString(2));
					detailtex.setText(rs.getString(6));
				}
				catch(SQLException e2)
				{
					System.out.println(e2);
				}		
			int confirm=JOptionPane.showConfirmDialog(null,"確認信息,如果備注有信息請處理好相干工作","還書確認",JOptionPane.YES_NO_OPTION);
			if(confirm==JOptionPane.YES_OPTION)
			{
				sql=("update borrow set returndate='"+returndate+ "',comment='"+detail+" 'where id="+borrowid);
				System.out.println(sql);
				boolean success=db.executeSql(sql);
				if(!success)
				{
					JOptionPane.showMessageDialog(null,"不成功，請重試");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"成功");
					this.dispose();
				}
				
			}
			else
			{
				this.dispose();
				return;
			}
	}
	}
	private JLabel namelbl;
	private JLabel booknamelbl;
	private JLabel datelbl;
	private JLabel detaillbl;
	private JTextField nametex;
	private JTextField booknametex;
	private JTextField datetex;
	private JTextField detailtex;
	private JButton cleanbtn;
	private JButton surebtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private GridLayout gl2;
	private DBManager db=new DBManager();
	private ResultSet rs;
	//借閱表的ID
	private Long borrowid=new Long(0);
}