📄 frmbarrowers.java
字号:
/*
****************************************************************
****************************************************************
******* *****
******* PROGRAMMER: JUNALD ASTRONOMO LAGOD *****
******* CONTACT NUMBER: +639195671599 *****
******* E-MAIL ADDRESS: JUNALDLAGOD@YAHOO.COM *****
******* WEBSITE: HTTP://WWW.JUNALDLAGOD.CJB.NET *****
******* *****
******* MABUHAY ANG MGA PINOY *****
******* PLEASE DON'T FORGET TO VOTE" *****
******* *****
****************************************************************
****************************************************************
*/
import java.util.*;
import java.text.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.awt.PrintJob;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.border.*;
import javax.swing.table.*;
import javax.swing.plaf.metal.*;
public class frmBarrowers extends JInternalFrame implements ActionListener
{
public static JScrollPane BrrwrsTblJSP = new JScrollPane();
public static JPanel jpnlMain = new JPanel();
public static JTable JTBrrwrsTbl;
Connection cnBarrowers;
public static Statement stmtBarrowers;
public static ResultSet rsBarrowers; //Recordset
public static String sSQL;
public static String Content[][];
public static int rowNum = 0;
public static int total = 0;
boolean goEOF;
Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
//JButton Variables
JButton bttnAddNew = new JButton("Add New",new ImageIcon("@imgs/add new.gif"));
JButton bttnEdit = new JButton("Edit", new ImageIcon("@imgs/edit.gif"));
JButton bttnRemove = new JButton("Remove", new ImageIcon("@imgs/remove.gif"));
JButton bttnSearch = new JButton("Search", new ImageIcon("@imgs/search.gif"));
JButton bttnPreview = new JButton("Preview",new ImageIcon("@imgs/preview.gif"));
JButton bttnRefresh = new JButton("Refresh",new ImageIcon("@imgs/refresh.gif"));
JButton bttnExit = new JButton("Cancel", new ImageIcon("@imgs/cancel.gif"));
//JLabel Variables
JLabel lblHeader = new JLabel();
JLabel lblIcon = new JLabel();
JLabel lblCaption = new JLabel("NOTE: This form contains all information about the Book Barrowers.");
JFrame JFParentFrame;
mdlFunctions module_func = new mdlFunctions();
mdlSQLStatements module_sql = new mdlSQLStatements();
public frmBarrowers(Connection conn, JFrame getParentFrame) throws SQLException
{
super("Barrowers Records",false,true,false,true);
jpnlMain.setBackground(Color.WHITE);
jpnlMain.setLayout(null);
JFParentFrame = getParentFrame;
cnBarrowers = conn;
stmtBarrowers = cnBarrowers.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sSQL = "SELECT * FROM tblBarrowers ORDER BY BarrowersName ASC";
//-- Add the Table
JTBrrwrsTbl = CreateTable();
BrrwrsTblJSP.getViewport().add(JTBrrwrsTbl);
BrrwrsTblJSP.setBounds(5,55,708,323);
jpnlMain.add(BrrwrsTblJSP);
module_func.setJButton(bttnAddNew,5,390,105,25,"add","Add New");
bttnAddNew.setMnemonic(KeyEvent.VK_A);
bttnAddNew.addActionListener(JBActionListener);
module_func.setJButton(bttnEdit,112,390,99,25,"edit","Edit");
bttnEdit.setMnemonic(KeyEvent.VK_E);
bttnEdit.addActionListener(JBActionListener);
module_func.setJButton(bttnRemove,212,390,100,25,"remove","Removed");
bttnRemove.setMnemonic(KeyEvent.VK_R);
bttnRemove.addActionListener(JBActionListener);
module_func.setJButton(bttnSearch,313,390,99,25,"search","Search");
bttnSearch.setMnemonic(KeyEvent.VK_S);
bttnSearch.addActionListener(JBActionListener);
module_func.setJButton(bttnPreview,414,390,99,25,"preview","Preview");
bttnPreview.setMnemonic(KeyEvent.VK_P);
bttnPreview.addActionListener(JBActionListener);
module_func.setJButton(bttnRefresh,514,390,99,25,"refresh","Refresh");
bttnRefresh.setMnemonic(KeyEvent.VK_R);
bttnRefresh.addActionListener(JBActionListener);
module_func.setJButton(bttnExit,614,390,99,25,"exit","Unload Form");
bttnExit.setMnemonic(KeyEvent.VK_C);
bttnExit.addActionListener(JBActionListener);
lblHeader.setIcon(new ImageIcon("@imgs/Barrowers Records.gif"));
lblIcon.setIcon(new ImageIcon("@imgs/ListBarrowers.gif"));
module_func.setJLabel(lblHeader,0,0,750,40);
module_func.setJLabel(lblIcon,5,2,50,40);
module_func.setJLabel(lblCaption,60,2,500,40);
lblCaption.setFont(new Font("Dialog", Font.BOLD, 12));
lblCaption.setForeground(new Color(255,255,255));
//Add Labels
jpnlMain.add(lblCaption);
jpnlMain.add(lblIcon);
jpnlMain.add(lblHeader);
//Add Buttons
jpnlMain.add(bttnAddNew);
jpnlMain.add(bttnEdit);
jpnlMain.add(bttnRemove);
jpnlMain.add(bttnSearch);
jpnlMain.add(bttnPreview);
jpnlMain.add(bttnRefresh);
jpnlMain.add(bttnExit);
getContentPane().setLayout(new BorderLayout(0,0));
getContentPane().add(BorderLayout.CENTER, jpnlMain);
setFrameIcon(new ImageIcon("@imgs/barrowers.gif"));
setSize(728,450);
setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);
setLocation((screen.width - 728)/2,((screen.height-450)/2)-45);
}
public void rptPreview()
{
if(total != 0)
{
try
{
if(JTBrrwrsTbl.getValueAt(JTBrrwrsTbl.getSelectedRow(),JTBrrwrsTbl.getSelectedColumn()) != null)
{
mdlMethods PrintingClass = new mdlMethods();
ResultSet rsPrint = stmtBarrowers.executeQuery("SELECT * FROM tblBarrowers WHERE BarrowersID ='" + JTBrrwrsTbl.getValueAt(JTBrrwrsTbl.getSelectedRow(),0) + "'");
if(rsPrint.next()==true)
{
String RecordToPrint = "";
java.util.Date CurrentDate = new java.util.Date();
SimpleDateFormat SDFDateFormatter = new SimpleDateFormat("MMM. dd, yyyy",Locale.getDefault());
RecordToPrint += " B A R R O W E R S R E C O R D S\n";
RecordToPrint += " " + SDFDateFormatter.format(CurrentDate).toString() + "\n\n\n";
RecordToPrint += "-----------------------------------------------------------------------------------\n\n";
RecordToPrint += " Barrowers ID: " + rsPrint.getString("BarrowersID") + "\n\n";
RecordToPrint += " Barrowers Name: " + rsPrint.getString("BarrowersName") + "\n";
RecordToPrint += " Address: " + rsPrint.getString("Address") + "\n";
RecordToPrint += " Current Year: " + rsPrint.getString("CurrentYear") + "\n";
RecordToPrint += " Course: " + rsPrint.getString("Course") + "\n";
RecordToPrint += " Section: " + rsPrint.getString("Section") + "\n\n";;
RecordToPrint += "-----------------------------------------------------------------------------------\n\n\n";
PrintingClass.printRecord(RecordToPrint,JFParentFrame);
CurrentDate=null;
SDFDateFormatter=null;
RecordToPrint=null;
}
else
{
JOptionPane.showMessageDialog(null,"The selected record has been change since last modified. Please click the 'Reload' button and try again!","No record to print",JOptionPane.WARNING_MESSAGE);
}
//Dispose the variable
rsPrint=null;
}
}
catch(Exception sqlE)
{
if(sqlE.getMessage() != null){System.out.println(sqlE.getMessage()); }
else
{
JOptionPane.showMessageDialog(null,"Please select a record in the list to print.","No Record Selected",JOptionPane.INFORMATION_MESSAGE);
}
}
}
}
ActionListener JBActionListener = new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String srcObj = e.getActionCommand();
if(srcObj == "add")
{
JDialog JDAdd = new frmAddEditBarrowers(true,JFParentFrame,cnBarrowers,"");
JDAdd.show();
}
else if(srcObj == "edit")
{
if(total != 0){
try
{
if(JTBrrwrsTbl.getValueAt(JTBrrwrsTbl.getSelectedRow(),JTBrrwrsTbl.getSelectedColumn()) != null)
{
JDialog JDEdit = new frmAddEditBarrowers(false,JFParentFrame,cnBarrowers,"SELECT * FROM tblBarrowers WHERE BarrowersID ='" + JTBrrwrsTbl.getValueAt(JTBrrwrsTbl.getSelectedRow(),0) + "'");
JDEdit.show();
}
}
catch(Exception sqlE)
{
if(sqlE.getMessage() != null){System.out.println(sqlE.getMessage());}
else
{
JOptionPane.showMessageDialog(null,"Please select a record in the list to modify.","No Record Selected",JOptionPane.INFORMATION_MESSAGE);
}
}
}
}
else if(srcObj=="search")
{
JDialog JDSearch = new frmSearch(JFParentFrame, "Barrowers");
JDSearch.show();
}
else if(srcObj=="remove")
{
if(total != 0){
try
{
if(JTBrrwrsTbl.getValueAt(JTBrrwrsTbl.getSelectedRow(),JTBrrwrsTbl.getSelectedColumn()) != null)
{
String ObjButtons[] = {"Yes","No"};
int PromptResult = JOptionPane.showOptionDialog(null,"Are you sure you want to removed " + JTBrrwrsTbl.getValueAt(JTBrrwrsTbl.getSelectedRow(),1) + " in the record?","Delete Record",JOptionPane.DEFAULT_OPTION,JOptionPane.ERROR_MESSAGE,null,ObjButtons,ObjButtons[1]);
if(PromptResult==0)
{
module_sql.recREMOVE(true, stmtBarrowers,"tblBarrowers", "BarrowersID", JTBrrwrsTbl,0);
reloadRecord(sSQL);
JOptionPane.showMessageDialog(null,"Record has been successfully removed.","Comfirm Delete",JOptionPane.INFORMATION_MESSAGE);
}
}
}
catch(Exception sqlE)
{
if(sqlE.getMessage()!=null)
{
JOptionPane.showMessageDialog(null,"You cannot delete this barrower because it is being used by another user.\nIn order to delete this barrower, delete its data from another table.","Comfirm Delete",JOptionPane.WARNING_MESSAGE);
}
else
{
JOptionPane.showMessageDialog(null,"Please select a record in the list to deleted.","No Record Selected",JOptionPane.INFORMATION_MESSAGE);
}
}
}
}
else if(srcObj == "preview"){rptPreview();}
else if(srcObj == "refresh"){reloadRecord("SELECT * FROM tblBarrowers ORDER BY BarrowersName ASC");}
else if(srcObj == "exit"){dispose();}
}
};
public static JTable CreateTable(){
String ColumnHeaderName[] = {
"Barrowers ID","Barrowers Names","Address","Current Year","Course","Section"
};
try{
rsBarrowers = stmtBarrowers.executeQuery(sSQL);
total = 0;
//Move to the last record
rsBarrowers.afterLast();
//Get the current record position
if(rsBarrowers.previous())total = rsBarrowers.getRow();
//Move back to the first record;
rsBarrowers.beforeFirst();
if(total != 0)
{
Content = new String[total][8];
while(rsBarrowers.next())
{
Content[rowNum][0] = "" + rsBarrowers.getString("BarrowersID");
Content[rowNum][1] = "" + rsBarrowers.getString("BarrowersName");
Content[rowNum][2] = "" + rsBarrowers.getString("Address");
Content[rowNum][3] = "" + rsBarrowers.getString("CurrentYear");
Content[rowNum][4] = "" + rsBarrowers.getString("Course");
Content[rowNum][5] = "" + rsBarrowers.getString("Section");
rowNum++;
}
}
else
{
Content = new String[0][6];
Content[0][0] = " ";
Content[0][1] = " ";
Content[0][2] = " ";
Content[0][3] = " ";
Content[0][4] = " ";
Content[0][5] = " ";
}
}
catch(Exception eE){}
JTable NewTable = new JTable (Content,ColumnHeaderName)
{
public boolean isCellEditable (int iRows, int iCols)
{return false;}
};
NewTable.setPreferredScrollableViewportSize(new Dimension(708, 323));
NewTable.setBackground(Color.white);
//Start resize the table column
NewTable.getColumnModel().getColumn(0).setMinWidth(0);
NewTable.getColumnModel().getColumn(0).setPreferredWidth(100);
NewTable.getColumnModel().getColumn(1).setPreferredWidth(200);
NewTable.getColumnModel().getColumn(2).setPreferredWidth(100);
NewTable.getColumnModel().getColumn(3).setPreferredWidth(100);
//End resize the table column
//Disposed variables
ColumnHeaderName=null;
Content=null;
rowNum = 0;
return NewTable;
}
public static void reloadRecord(String srcSQL)
{
sSQL = srcSQL;
BrrwrsTblJSP.getViewport().remove(JTBrrwrsTbl);
JTBrrwrsTbl=CreateTable();
BrrwrsTblJSP.getViewport().add(JTBrrwrsTbl);
jpnlMain.repaint();
}
public void actionPerformed(ActionEvent event)
{
setVisible(false);
dispose();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -