public Class getColumnClass(int c) {
try {
Class cl = lookup.get(0, c).getClass();
for (int i = 0; i < getRowCount(); i++) {
if (!cl.equals(lookup.get(i, c).getClass())) return Object.class;
}
return cl;
} catch (NullPointerException e) {
return Object.class;
}
}
private void Simpan() {
if (btnSave.getText().equals("Edit")) {
try {
Class.forName(KoneksiDatabase.driver);
java.sql.Connection c =
DriverManager.getConnection(
KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass);
Statement s = c.createStatement();
String sql;
sql = "update absensi_lembur set tipehari = '";
sql += cmbJenisHari.getSelectedItem() + "', tot_waktu_lembur='";
sql += txtTotalLembur.getText() + "'";
sql += "where kd_absen = '" + txtKodeAbsen.getText() + "'";
s.executeQuery(sql);
JOptionPane.showMessageDialog(
null, "Data Berhasil Disimpan!!!", "Informasi", JOptionPane.INFORMATION_MESSAGE);
} catch (Exception e) {
JOptionPane.showMessageDialog(
null,
"Gagal Disimpan, Data Harus Lengkap !!!",
"Peringatan",
JOptionPane.WARNING_MESSAGE);
}
}
Baru();
}
private void btnDeleteActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnDeleteActionPerformed
// TODO add your handling code here:
if (txtKodeAbsen.getText().equals("")) {
JOptionPane.showMessageDialog(
null, "Isi Kode Absen yang Akan dihapus !!!", "Peringatan", JOptionPane.ERROR_MESSAGE);
txtKodeAbsen.requestFocus();
} else {
try {
Class.forName(KoneksiDatabase.driver);
java.sql.Connection c =
DriverManager.getConnection(
KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass);
Statement s = c.createStatement();
String sql = "DELETE FROM absensi_lembur where kd_absen ='" + txtKodeAbsen.getText() + "'";
s.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Berhasil Dihapus !");
Baru();
} catch (Exception e) {
JOptionPane.showMessageDialog(
null, "Kemungkinan terjadi kegagalan koneksi", "Warning", JOptionPane.ERROR_MESSAGE);
}
}
} // GEN-LAST:event_btnDeleteActionPerformed
private void Baru() {
btnSave.setText("Save");
txtNip.requestFocus();
txtNip.setText("");
try {
Class.forName(KoneksiDatabase.driver);
java.sql.Connection c =
DriverManager.getConnection(
KoneksiDatabase.database, KoneksiDatabase.user, KoneksiDatabase.pass);
Statement s = c.createStatement();
String sql = "select * from absensi_lembur";
ResultSet rs = s.executeQuery(sql);
final String[] headers = {
"Kd Absen",
"NIP",
"Tgl Absen",
"Masuk",
"Pulang",
"Hari",
"Tipe Hari",
"Terlambat",
"Lembur",
"Tipe Lembur",
"Tot Lembur",
"Tunj Makan",
"Tunj Transport"
};
rs.last();
int n = rs.getRow();
Object[][] data = new Object[n][13];
int p = 0;
rs.beforeFirst();
while (rs.next()) {
data[p][0] = rs.getString(1);
data[p][1] = rs.getString(2);
data[p][2] = rs.getString(3);
data[p][3] = rs.getString(4);
data[p][4] = rs.getString(5);
data[p][5] = rs.getString(6);
data[p][6] = rs.getString(7);
data[p][7] = rs.getString(8);
data[p][8] = rs.getString(9);
data[p][9] = rs.getString(10);
data[p][10] = rs.getString(11);
data[p][11] = rs.getString(12);
data[p][12] = rs.getString(13);
p++;
}
tblLembur.setModel(new DefaultTableModel(data, headers));
tblLembur.setAlignmentX(CENTER_ALIGNMENT);
} catch (Exception e) {
JOptionPane.showMessageDialog(
null, "Gagal Koneksi, Ada Kesalahan.", "Warning", JOptionPane.WARNING_MESSAGE);
}
}
static {
try {
// registra els drivers de MySQL
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public QueryTableModel() {
cache = new Vector();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
} catch (java.lang.Exception e) {
System.err.println("Class not found exception : ");
System.err.println(e.getMessage());
}
} // konstr. sonu
protected void loadAirspacesFromPath(String path, Collection<Airspace> airspaces) {
File file = ExampleUtil.saveResourceToTempFile(path, ".zip");
if (file == null) return;
try {
ZipFile zipFile = new ZipFile(file);
ZipEntry entry = null;
for (Enumeration<? extends ZipEntry> e = zipFile.entries();
e.hasMoreElements();
entry = e.nextElement()) {
if (entry == null) continue;
String name = WWIO.getFilename(entry.getName());
if (!(name.startsWith("gov.nasa.worldwind.render.airspaces") && name.endsWith(".xml")))
continue;
String[] tokens = name.split("-");
try {
Class c = Class.forName(tokens[0]);
Airspace airspace = (Airspace) c.newInstance();
BufferedReader input =
new BufferedReader(new InputStreamReader(zipFile.getInputStream(entry)));
String s = input.readLine();
airspace.restoreState(s);
airspaces.add(airspace);
if (tokens.length >= 2) {
airspace.setValue(AVKey.DISPLAY_NAME, tokens[1]);
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
} catch (IOException e) {
e.printStackTrace();
}
}
static {
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql:///hospital", "root", "root");
pa = con.prepareStatement("insert into patient values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ");
pd = con.prepareStatement("delete from patient where pid=? ");
pl = con.prepareStatement("select * from patient order by pid");
pps = con.prepareStatement("select * from patient where pid=? ");
pps1 = con.prepareStatement("select * from patient where plnm= ?");
} catch (Exception e) {
System.out.println(e);
}
}
/** Reaction to buttons and combo boxes. */
public void actionPerformed(ActionEvent e) {
String cmd = e.getActionCommand();
if (cmdCtrlProp.equals(cmd)) {
try {
Class c =
Class.forName("aurora.hwc.control.Panel" + myController.getClass().getSimpleName());
AbstractPanelController cp = (AbstractPanelController) c.newInstance();
cp.initialize(myController, null);
} catch (Exception ex) {
}
}
if (cmdCtrlList.equals(cmd)) {
JComboBox cb = (JComboBox) e.getSource();
if (cb.getSelectedIndex() > 0) {
myController = (AbstractControllerComplex) listCControllers.getSelectedItem();
buttonProp.setEnabled(true);
} else {
buttonProp.setEnabled(false);
myController = null;
}
myMonitor.setMyController(myController);
}
return;
}
@Override
public TableCellEditor getCellEditor(int row, int column) {
MyTableModel model = (MyTableModel) getModel();
if (column == 0) {
return null;
}
// code repetition with getCellRenderer because of TableCell{Renderer, Editor}
// non-inheritance
Class<?> klass = model.getClassAt(row, column);
PropertyEditorTableAdapter javaBeansEditor = PropertyEditorTableAdapter.forClass(klass);
if (javaBeansEditor != null) {
return javaBeansEditor;
}
TableCellEditor defaultEditor = getDefaultEditor(klass);
if (defaultEditor == null) {
log.warning("No TableCellEditor for " + klass.getName());
}
if (defaultEditor instanceof DefaultCellEditor) {
// default double-click is bad user interaction
((DefaultCellEditor) defaultEditor).setClickCountToStart(0);
}
return defaultEditor;
}
// 采用静态初始化块来初始化Connection、Statement对象
static {
try {
Properties props = new Properties();
props.load(new FileInputStream("mysql.ini"));
String drivers = props.getProperty("driver");
String url = props.getProperty("url");
String username = props.getProperty("user");
String password = props.getProperty("pass");
// 加载数据库驱动
Class.forName(drivers);
// 取得数据库连接
conn = DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* @param methodName getter method
* @param clazz value object class
* @return attribute name related to the specified getter method
*/
private String getAttributeName(String methodName, Class classType) {
String attributeName = null;
if (methodName.startsWith("is"))
attributeName =
methodName.substring(2, 3).toLowerCase()
+ (methodName.length() > 3 ? methodName.substring(3) : "");
else
attributeName =
methodName.substring(3, 4).toLowerCase()
+ (methodName.length() > 4 ? methodName.substring(4) : "");
// an attribute name "Xxxx" becomes "xxxx" and this is not correct!
try {
Class c = classType;
boolean attributeFound = false;
while (!c.equals(Object.class)) {
try {
c.getDeclaredField(attributeName);
attributeFound = true;
break;
} catch (Throwable ex2) {
c = c.getSuperclass();
}
}
if (!attributeFound) {
// now trying to find an attribute having the first character in upper case (e.g. "Xxxx")
String name = attributeName.substring(0, 1).toUpperCase() + attributeName.substring(1);
c = classType;
while (!c.equals(Object.class)) {
try {
c.getDeclaredField(name);
attributeFound = true;
break;
} catch (Throwable ex2) {
c = c.getSuperclass();
}
}
if (attributeFound) attributeName = name;
}
} catch (Throwable ex1) {
}
return attributeName;
}
/**
* @param obj ValueObject where updating the value for the specified attribute (identified by
* colunm index)
* @param attributeName attribute name
* @param value new Object to set onto ValueObject
*/
public final void setField(ValueObject obj, String attributeName, Object value) {
try {
Method[] getter = ((Method[]) voGetterMethods.get(attributeName));
Method[] setter = ((Method[]) voSetterMethods.get(attributeName));
if (getter == null)
Logger.error(
this.getClass().getName(),
"setField",
"No getter method for attribute name '" + attributeName + "'.",
null);
if (setter == null)
Logger.error(
this.getClass().getName(),
"setField",
"No setter method for attribute name '" + attributeName + "'.",
null);
if (value != null
&& (value instanceof Number || !value.equals("") && value instanceof String)) {
if (!getter[getter.length - 1].getReturnType().equals(value.getClass())) {
Class attrType = getter[getter.length - 1].getReturnType();
if (attrType.equals(Integer.class) || attrType.equals(Integer.TYPE))
value = new Integer(Double.valueOf(value.toString()).intValue());
else if (attrType.equals(Double.class) || attrType.equals(Double.TYPE))
value = new Double(value.toString());
else if (attrType.equals(BigDecimal.class)) value = new BigDecimal(value.toString());
else if (attrType.equals(Long.class) || attrType.equals(Long.TYPE))
value = new Long(Double.valueOf(value.toString()).longValue());
else if (attrType.equals(Short.class) || attrType.equals(Short.TYPE))
value = new Short(Double.valueOf(value.toString()).shortValue());
else if (attrType.equals(Float.class) || attrType.equals(Float.TYPE))
value = new Float(Double.valueOf(value.toString()).floatValue());
}
} else if (value != null && value.equals("")) {
if (!getter[getter.length - 1].getReturnType().equals(value.getClass())) value = null;
}
// test date compatibility...
if (value != null && value.getClass().equals(java.util.Date.class)) {
if (setter[setter.length - 1].getParameterTypes()[0].equals(java.sql.Date.class))
value = new java.sql.Date(((java.util.Date) value).getTime());
else if (setter[setter.length - 1].getParameterTypes()[0].equals(java.sql.Timestamp.class))
value = new java.sql.Timestamp(((java.util.Date) value).getTime());
}
// retrieve inner v.o.: if not present then maybe create it, according to "createInnerVO"
// property...
Method[] m = (Method[]) voGetterMethods.get(attributeName);
if (m == null)
Logger.error(
this.getClass().getName(),
"setField",
"No getter method for attribute name '" + attributeName + "'.",
null);
Object oldObj = obj;
String auxAttr;
for (int i = 0; i < m.length - 1; i++) {
oldObj = obj;
obj = (ValueObject) m[i].invoke(oldObj, new Object[0]);
if (obj == null) {
if (grids.getGridControl() == null || !grids.getGridControl().isCreateInnerVO()) return;
else {
obj = (ValueObject) m[i].getReturnType().newInstance();
String[] attrs = attributeName.split("\\.");
auxAttr = "";
for (int k = 0; k <= i; k++) auxAttr += attrs[k] + ".";
auxAttr = auxAttr.substring(0, auxAttr.length() - 1);
Method aux = ((Method[]) voSetterMethods.get(auxAttr))[i];
aux.invoke(oldObj, new Object[] {obj});
}
}
}
// avoid to set null for primitive types!
if (value == null && setter[setter.length - 1].getParameterTypes()[0].equals(Long.TYPE))
setter[setter.length - 1].invoke(obj, new Object[] {new Long(0)});
if (value == null && setter[setter.length - 1].getParameterTypes()[0].equals(Integer.TYPE))
setter[setter.length - 1].invoke(obj, new Object[] {new Integer(0)});
if (value == null && setter[setter.length - 1].getParameterTypes()[0].equals(Short.TYPE))
setter[setter.length - 1].invoke(obj, new Object[] {new Short((short) 0)});
if (value == null && setter[setter.length - 1].getParameterTypes()[0].equals(Float.TYPE))
setter[setter.length - 1].invoke(obj, new Object[] {new Float(0)});
if (value == null && setter[setter.length - 1].getParameterTypes()[0].equals(Double.TYPE))
setter[setter.length - 1].invoke(obj, new Object[] {new Double(0)});
if (value == null && setter[setter.length - 1].getParameterTypes()[0].equals(Boolean.TYPE))
setter[setter.length - 1].invoke(obj, new Object[] {Boolean.FALSE});
else setter[setter.length - 1].invoke(obj, new Object[] {value});
} catch (Exception ex) {
ex.printStackTrace();
}
}
/**
* Analyze class fields and fill in "voSetterMethods","voGetterMethods","indexes",reverseIndexes"
* attributes.
*
* @param prefix e.g. "attrx.attry."
* @param parentMethods getter methods of parent v.o.
* @param classType class to analyze
*/
private void analyzeClassFields(
Hashtable vosAlreadyProcessed, String prefix, Method[] parentMethods, Class classType) {
try {
Integer num = (Integer) vosAlreadyProcessed.get(classType);
if (num == null) num = new Integer(0);
num = new Integer(num.intValue() + 1);
if (num.intValue() > 10) return;
vosAlreadyProcessed.put(classType, num);
// retrieve all getter and setter methods defined in the specified value object...
String attributeName = null;
Method[] methods = classType.getMethods();
String aName = null;
for (int i = 0; i < methods.length; i++) {
attributeName = methods[i].getName();
if (attributeName.startsWith("get")
&& methods[i].getParameterTypes().length == 0
&& ValueObject.class.isAssignableFrom(methods[i].getReturnType())) {
aName = getAttributeName(attributeName, classType);
Method[] newparentMethods = new Method[parentMethods.length + 1];
System.arraycopy(parentMethods, 0, newparentMethods, 0, parentMethods.length);
newparentMethods[parentMethods.length] = methods[i];
analyzeClassFields(
vosAlreadyProcessed,
prefix + aName + ".",
newparentMethods,
methods[i].getReturnType());
}
if (attributeName.startsWith("get")
&& methods[i].getParameterTypes().length == 0
&& (methods[i].getReturnType().equals(String.class)
|| methods[i].getReturnType().equals(Long.class)
|| methods[i].getReturnType().equals(Long.TYPE)
|| methods[i].getReturnType().equals(Float.class)
|| methods[i].getReturnType().equals(Float.TYPE)
|| methods[i].getReturnType().equals(Short.class)
|| methods[i].getReturnType().equals(Short.TYPE)
|| methods[i].getReturnType().equals(Double.class)
|| methods[i].getReturnType().equals(Double.TYPE)
|| methods[i].getReturnType().equals(BigDecimal.class)
|| methods[i].getReturnType().equals(java.util.Date.class)
|| methods[i].getReturnType().equals(java.sql.Date.class)
|| methods[i].getReturnType().equals(java.sql.Timestamp.class)
|| methods[i].getReturnType().equals(Integer.class)
|| methods[i].getReturnType().equals(Integer.TYPE)
|| methods[i].getReturnType().equals(Character.class)
|| methods[i].getReturnType().equals(Boolean.class)
|| methods[i].getReturnType().equals(boolean.class)
|| methods[i].getReturnType().equals(ImageIcon.class)
|| methods[i].getReturnType().equals(Icon.class)
|| methods[i].getReturnType().equals(byte[].class)
|| methods[i].getReturnType().equals(Object.class)
|| ValueObject.class.isAssignableFrom(methods[i].getReturnType()))) {
attributeName = getAttributeName(attributeName, classType);
// try {
// if
// (classType.getMethod("set"+attributeName.substring(0,1).toUpperCase()+attributeName.substring(1),new Class[]{methods[i].getReturnType()})!=null)
Method[] newparentMethods = new Method[parentMethods.length + 1];
System.arraycopy(parentMethods, 0, newparentMethods, 0, parentMethods.length);
newparentMethods[parentMethods.length] = methods[i];
voGetterMethods.put(prefix + attributeName, newparentMethods);
// } catch (NoSuchMethodException ex) {
// }
} else if (attributeName.startsWith("is")
&& methods[i].getParameterTypes().length == 0
&& (methods[i].getReturnType().equals(Boolean.class)
|| methods[i].getReturnType().equals(boolean.class))) {
attributeName = getAttributeName(attributeName, classType);
Method[] newparentMethods = new Method[parentMethods.length + 1];
System.arraycopy(parentMethods, 0, newparentMethods, 0, parentMethods.length);
newparentMethods[parentMethods.length] = methods[i];
voGetterMethods.put(prefix + attributeName, newparentMethods);
} else if (attributeName.startsWith("set") && methods[i].getParameterTypes().length == 1) {
attributeName = getAttributeName(attributeName, classType);
try {
if (classType.getMethod(
"get"
+ attributeName.substring(0, 1).toUpperCase()
+ attributeName.substring(1),
new Class[0])
!= null) {
Method[] newparentMethods = new Method[parentMethods.length + 1];
System.arraycopy(parentMethods, 0, newparentMethods, 0, parentMethods.length);
newparentMethods[parentMethods.length] = methods[i];
voSetterMethods.put(prefix + attributeName, newparentMethods);
}
} catch (NoSuchMethodException ex) {
try {
if (classType.getMethod(
"is"
+ attributeName.substring(0, 1).toUpperCase()
+ attributeName.substring(1),
new Class[0])
!= null) {
Method[] newparentMethods = new Method[parentMethods.length + 1];
System.arraycopy(parentMethods, 0, newparentMethods, 0, parentMethods.length);
newparentMethods[parentMethods.length] = methods[i];
voSetterMethods.put(prefix + attributeName, newparentMethods);
}
} catch (NoSuchMethodException exx) {
}
}
}
}
// fill in indexes with the colProperties indexes first; after them, it will be added the
// other indexes (of attributes not mapped with grid column...)
HashSet alreadyAdded = new HashSet();
int i = 0;
for (i = 0; i < attributeNames.length; i++) {
reverseIndexes.put(attributeNames[i], new Integer(i));
alreadyAdded.add(attributeNames[i]);
}
Enumeration en = voGetterMethods.keys();
while (en.hasMoreElements()) {
attributeName = en.nextElement().toString();
if (!alreadyAdded.contains(attributeName)) {
reverseIndexes.put(attributeName, new Integer(i));
i++;
}
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public TableModelDemo() {
try {
// Load the JDBC driver
Class.forName("com.mysql.jdbc.Driver");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("Driver loaded");
// Create a row set
rowSet = new CachedRowSetImpl();
// Set RowSet properties
// rowSet.setUrl("jdbc:mysql://localhost/javabook");
rowSet.setUrl("jdbc:oracle:thin:@liang.armstrong.edu:1521:orcl");
rowSet.setUsername("scott");
rowSet.setPassword("tiger");
rowSet.setCommand("select * from StateCapital");
rowSet.setConcurrency(ResultSet.CONCUR_UPDATABLE);
rowSet.execute();
tableModel.setRowSet(rowSet);
rowSet.addRowSetListener(tableModel);
} catch (Exception ex) {
ex.printStackTrace();
}
JPanel panel1 = new JPanel();
panel1.setLayout(new GridLayout(2, 2));
panel1.add(jbtAddRow);
panel1.add(jbtAddColumn);
panel1.add(jbtDeleteRow);
panel1.add(jbtDeleteColumn);
JPanel panel2 = new JPanel();
panel2.add(jbtSave);
panel2.add(jbtClear);
panel2.add(jbtRestore);
JPanel panel3 = new JPanel();
panel3.setLayout(new BorderLayout(5, 0));
panel3.add(new JLabel("Selection Mode"), BorderLayout.WEST);
panel3.add(jcboSelectionMode, BorderLayout.CENTER);
JPanel panel4 = new JPanel();
panel4.setLayout(new FlowLayout(FlowLayout.LEFT));
panel4.add(jchkRowSelectionAllowed);
panel4.add(jchkColumnSelectionAllowed);
JPanel panel5 = new JPanel();
panel5.setLayout(new GridLayout(2, 1));
panel5.add(panel3);
panel5.add(panel4);
JPanel panel6 = new JPanel();
panel6.setLayout(new BorderLayout());
panel6.add(panel1, BorderLayout.SOUTH);
panel6.add(panel2, BorderLayout.CENTER);
add(panel5, BorderLayout.NORTH);
add(new JScrollPane(jTable1), BorderLayout.CENTER);
add(panel6, BorderLayout.SOUTH);
// Initialize table selection mode
jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jbtAddRow.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
rowSet.absolute(2);
rowSet.moveToInsertRow();
rowSet.updateString("state", "Georia");
rowSet.updateString("capital", "Atlanta");
rowSet.insertRow();
((CachedRowSetImpl) rowSet).acceptChanges();
rowSet.moveToCurrentRow();
} catch (Exception ex) {
ex.printStackTrace();
}
// if (jTable1.getSelectedRow() >= 0)
// tableModel.insertRow(jTable1.getSelectedRow(),
// new java.util.Vector());
// else
// tableModel.addRow(new java.util.Vector());
}
});
jbtAddColumn.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// String name = JOptionPane.showInputDialog("New Column Name");
// tableModel.addColumn(name, new java.util.Vector());
}
});
jbtDeleteRow.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
if (jTable1.getSelectedRow() >= 0) {
try {
rowSet.absolute(jTable1.getSelectedRow() + 1);
rowSet.deleteRow();
((CachedRowSetImpl) rowSet).acceptChanges();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
});
jbtDeleteColumn.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
if (jTable1.getSelectedColumn() >= 0) {
TableColumnModel columnModel = jTable1.getColumnModel();
TableColumn tableColumn = columnModel.getColumn(jTable1.getSelectedColumn());
columnModel.removeColumn(tableColumn);
}
}
});
jbtSave.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
ObjectOutputStream out =
new ObjectOutputStream(new FileOutputStream("tablemodel.dat"));
// out.writeObject(tableModel.getDataVector());
out.writeObject(getColumnNames());
out.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
jbtClear.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// tableModel.setRowCount(0);
}
});
jbtRestore.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
ObjectInputStream in = new ObjectInputStream(new FileInputStream("tablemodel.dat"));
Vector rowData = (Vector) in.readObject();
Vector columnNames = (Vector) in.readObject();
// tableModel.setDataVector(rowData, columnNames);
in.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
jchkRowSelectionAllowed.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
jTable1.setRowSelectionAllowed(jchkRowSelectionAllowed.isSelected());
}
});
jchkColumnSelectionAllowed.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
jTable1.setColumnSelectionAllowed(jchkColumnSelectionAllowed.isSelected());
}
});
jcboSelectionMode.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
String selectedItem = (String) jcboSelectionMode.getSelectedItem();
if (selectedItem.equals("SINGLE_SELECTION"))
jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
else if (selectedItem.equals("SINGLE_INTERVAL_SELECTION"))
jTable1.setSelectionMode(ListSelectionModel.SINGLE_INTERVAL_SELECTION);
else if (selectedItem.equals("MULTIPLE_INTERVAL_SELECTION"))
jTable1.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
}
});
}
/** Generates Configuration tab. */
private void fillConfigurationPanel() {
JPanel desc = new JPanel(new GridLayout(2, 0));
desc.setBorder(BorderFactory.createTitledBorder("Description"));
desc.add(
new JLabel("<html><font color=\"blue\">" + myMonitor.getDescription() + "</font></html>"));
desc.add(cbEnabled);
cbEnabled.setSelected(enabled);
cbEnabled.addChangeListener(this);
confPanel.add(desc);
JPanel mlpanel = new JPanel(new GridLayout(1, 0));
mlpanel.setBorder(BorderFactory.createTitledBorder("Monitored Network Elements"));
montable = new JTable(montablemodel);
montable.setPreferredScrollableViewportSize(new Dimension(200, 100));
montable.getColumnModel().getColumn(0).setPreferredWidth(140);
montable.getColumnModel().getColumn(1).setPreferredWidth(60);
montable.addMouseListener(
new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
if (e.getClickCount() == 2) {
int row = montable.rowAtPoint(new Point(e.getX(), e.getY()));
AbstractNetworkElement ne = null;
if ((row >= 0) && (row < myMonitor.getPredecessors().size()))
ne = myMonitor.getPredecessors().get(row);
else return;
treePane.actionSelected(ne, true);
}
return;
}
});
mlpanel.add(new JScrollPane(montable));
confPanel.add(mlpanel);
JPanel cpanel = new JPanel(new GridLayout(1, 0));
cpanel.setBorder(BorderFactory.createTitledBorder("Controlleded Network Elements"));
ctrltable = new JTable(ctrltablemodel);
ctrltable.setPreferredScrollableViewportSize(new Dimension(200, 100));
ctrltable.getColumnModel().getColumn(0).setPreferredWidth(140);
ctrltable.getColumnModel().getColumn(1).setPreferredWidth(60);
ctrltable.addMouseListener(
new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
if (e.getClickCount() == 2) {
int row = ctrltable.rowAtPoint(new Point(e.getX(), e.getY()));
AbstractNetworkElement ne = null;
if ((row >= 0) && (row < myMonitor.getSuccessors().size()))
ne = myMonitor.getSuccessors().get(row);
else return;
treePane.actionSelected(ne, true);
}
return;
}
});
cpanel.add(new JScrollPane(ctrltable));
confPanel.add(cpanel);
JPanel pcl = new JPanel(new FlowLayout());
// controller list
buttonProp.setEnabled(false);
buttonProp.setActionCommand(cmdCtrlProp);
buttonProp.addActionListener(this);
pcl.setBorder(BorderFactory.createTitledBorder("Complex Controller"));
buttonProp.setEnabled(false);
listCControllers = new JComboBox();
listCControllers.addItem("None");
String[] ctrlClasses = myMonitor.getComplexControllerClasses();
for (int i = 0; i < ctrlClasses.length; i++) {
if ((myController != null)
&& (myController.getClass().getName().compareTo(ctrlClasses[i]) == 0)) {
listCControllers.addItem(myController);
listCControllers.setSelectedIndex(i + 1);
buttonProp.setEnabled(true);
} else {
try {
Class cl = Class.forName(ctrlClasses[i]);
AbstractControllerComplex cc = (AbstractControllerComplex) cl.newInstance();
cc.setMyMonitor(myMonitor);
cc.initialize();
listCControllers.addItem(cc);
} catch (Exception e) {
}
}
}
listCControllers.setActionCommand(cmdCtrlList);
listCControllers.addActionListener(this);
pcl.add(listCControllers);
pcl.add(buttonProp);
confPanel.add(pcl);
return;
}
public ItensVendidos() {
super("Itens Vendidos");
JButton imprimir;
final DefaultTableModel modelo = new DefaultTableModel();
// constrói a tabela
JTable tabela = new JTable(modelo);
// Cria duas colunas
modelo.addColumn("Código");
modelo.addColumn("Vendedor");
modelo.addColumn("Produto");
modelo.addColumn("Quantidade");
imprimir = new JButton("Imprimir");
imprimir.setBounds(100, 450, 30, 24);
// exibe os dados da tabela MySQL
// Conexao banco = new Conexao();
String retorno = "erro";
try {
// Connection ExConn = (Connection) banco.abrirBDconn();
Class.forName("com.mysql.jdbc.Driver");
Connection conexao = DriverManager.getConnection("jdbc:mysql://localhost/banco", "root", "");
Statement stmt = conexao.createStatement();
// procedimentos para obter os dados de uma tabela
String query = "SELECT * FROM venda2";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
int id = rs.getInt("idVendedor");
String nome = rs.getString("nomeVendedor");
String produto = rs.getString("produto");
int qtd = rs.getInt("qtd");
modelo.addRow(new Object[] {new Integer(id), nome, produto, new Integer(qtd)});
}
// fim procedimento para obter os dados
} catch (SQLException ex) {
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} catch (Exception e) {
System.out.println("Problemas ao tentar conectar com o banco de dados");
}
// fim MySQL
tabela.setPreferredScrollableViewportSize(new Dimension(350, 50));
Container c = getContentPane();
c.setLayout(new FlowLayout());
JScrollPane scrollPane = new JScrollPane(tabela);
c.add(scrollPane);
c.add(imprimir);
setSize(400, 300);
setVisible(true);
}
public static <T extends Enum<T>> String getPropertyID(T algo) {
Class<T> clazz = algo.getDeclaringClass();
return "net.java.sip.communicator." + clazz.getName().replace('$', '_');
}
