 |
|
อันนี้โค้ด
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
import java.text.SimpleDateFormat;
import com.toedter.calendar.JDateChooser;
public class rental extends JFrame implements ActionListener{
JButton clear;
JButton show;
JTextField pay;
JInternalFrame jInternalFrame1;
JScrollPane jScrollPane1;
JTable jTable1;
JLabel lb1;
JLabel lb2;
JLabel lb3;
JLabel lb4;
JLabel lb5;
JTextField memid;
JTextField name;
JTextField total;
JLabel start;
JLabel end;
JButton save;
JButton ok;
JComboBox<String> jComboBox1;
Connection connect = null;
Statement s = null;
com.toedter.calendar.JDateChooser jDateChooser1;
com.toedter.calendar.JDateChooser jDateChooser2;
/**
* Creates new form rental
*/
public rental() {
initComponents();
}
private void initComponents() {
jInternalFrame1 = new JInternalFrame();
lb1 = new JLabel();
memid = new JTextField();
ok = new JButton();
name = new JTextField();
lb2 = new JLabel();
lb3 = new JLabel();
jComboBox1 = new JComboBox<>();
pay = new JTextField();
lb4 = new JLabel();
total = new JTextField();
lb5 = new JLabel();
save = new JButton();
jScrollPane1 = new JScrollPane();
jTable1 = new JTable();
clear = new JButton();
show = new JButton();
start = new javax.swing.JLabel();
end = new javax.swing.JLabel();
JDateChooser jDateChooser1 = new JDateChooser ( );
JDateChooser jDateChooser2 = new JDateChooser ( );
jInternalFrame1.setVisible(true);
GroupLayout jInternalFrame1Layout = new GroupLayout(jInternalFrame1.getContentPane());
jInternalFrame1.getContentPane().setLayout(jInternalFrame1Layout);
jInternalFrame1Layout.setHorizontalGroup(
jInternalFrame1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGap(0, 0, Short.MAX_VALUE)
);
jInternalFrame1Layout.setVerticalGroup(
jInternalFrame1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGap(0, 0, Short.MAX_VALUE)
);
save.addActionListener(this);
ok.addActionListener(this);
clear.addActionListener(this);
show.addActionListener(this);
setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
lb1.setText("Member ID");
lb1.setToolTipText("");
lb2.setText("Member Name");
lb2.setToolTipText("");
lb3.setText("Book ID");
lb4.setText("TOTAL");
lb4.setToolTipText("");
lb5.setText("PAY");
lb5.setToolTipText("");
save.setText("SAVE");
ok.setText("OK");
try {
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/projava?user=root&password=&characterEncoding=utf8");
s = connect.createStatement();
String sql = "SELECT * FROM book ORDER BY book_id ASC";
ResultSet rec = s.executeQuery(sql);
while(rec.next())
{
String name = rec.getString("book_id");
jComboBox1.addItem(name);
}
rec.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
// Model for Table
DefaultTableModel model = (DefaultTableModel) jTable1.getModel ();
model.addColumn("BOOK ID");
model.addColumn("Name");
model.addColumn("PRICE");
model.addColumn("TOTAL");
try {
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/projava?user=root&password=&characterEncoding=utf8");
s = connect.createStatement();
String sql = "SELECT * FROM book ORDER BY book_id ASC";
ResultSet rec = s.executeQuery(sql);
int row = 0;
while((rec!=null) && (rec.next()))
{
model.addRow(new Object[0]);
model.setValueAt(rec.getString("book_id"), row, 0);
model.setValueAt(rec.getString("book_name"), row, 1);
model.setValueAt(rec.getString("price"), row, 2);
model.setValueAt(rec.getString("total"), row, 3);
row++;
}
rec.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
jScrollPane1.setViewportView(jTable1);
clear.setText("CLEAR");
show.setText("SHOW");
start.setText("Start");
end.setText("End");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(layout.createSequentialGroup()
.addGap(71, 71, 71)
.addComponent(save, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(clear, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 14, Short.MAX_VALUE)
.addComponent(show))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(lb3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(lb1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(lb2, javax.swing.GroupLayout.PREFERRED_SIZE, 63, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(lb4)
.addComponent(lb5)
.addComponent(start)
.addComponent(end))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(name)
.addComponent(memid)
.addComponent(total)
.addComponent(pay, javax.swing.GroupLayout.DEFAULT_SIZE, 223, Short.MAX_VALUE)
.addComponent(jComboBox1, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jDateChooser1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jDateChooser2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ok, javax.swing.GroupLayout.DEFAULT_SIZE, 69, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 434, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(37, 37, 37))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(lb1)
.addComponent(memid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ok))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(lb2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(lb3)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(lb4)
.addComponent(total, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(pay, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(lb5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(start)
.addComponent(jDateChooser1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(end)
.addComponent(jDateChooser2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(34, 34, 34)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(save)
.addComponent(clear)
.addComponent(show)))
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 266, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(21, Short.MAX_VALUE))
);
lb1.getAccessibleContext().setAccessibleName("memid");
setBounds(0, 0, 888, 347);
}// </editor-fold>//GEN-END:initComponents
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Create and display the form */
EventQueue.invokeLater(new Runnable() {
public void run() {
new rental().setVisible(true);
}
});
}
public void actionPerformed(ActionEvent a){
if (a.getSource() == clear){
memid.setText("");
name.setText("");
total.setText("");
pay.setText("");
} // close clear
if (a.getSource() == ok)
{
String t1= memid.getText();
projava obj = new projava();
String name1 =obj.getName(t1);
name.setText(name1);
}
if (a.getSource() == save){
String t1 = memid.getText();
String value = jComboBox1.getSelectedItem().toString();
String t3 = ((JTextField)jDateChooser1.getDateEditor().getUiComponent()).getText();
String t4 = ((JTextField)jDateChooser2.getDateEditor().getUiComponent()).getText();
projava obj = new projava();
String insertr = obj.insertr(t1,value,t3,t4);
}
if (a.getSource() == show){
reportrental s = new reportrental();
s.setVisible(true);
}
}
}
Tag : Java, JAVA
|
ประวัติการแก้ไข
2019-02-17 15:13:25
|
 |
 |
 |
 |
| Date :
2019-02-17 15:04:57 |
By :
phikanatekung |
View :
2402 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
