public void put(String name, String value, String readPerm, String writePerm) {
SysConfig cfg;
if (prefix != null) name = prefix + name;
try {
boolean autoCommit = false;
Transaction tx = db.session().getTransaction();
if (tx == null || tx.getStatus().isNotOneOf(TransactionStatus.ACTIVE)) {
tx = db.session().beginTransaction();
autoCommit = true;
}
cfg = (SysConfig) db.session().get(SysConfig.class, name);
boolean saveIt = false;
if (cfg == null) {
cfg = new SysConfig();
cfg.setId(name);
saveIt = true;
}
cfg.setReadPerm(readPerm);
cfg.setWritePerm(writePerm);
cfg.setValue(value);
if (saveIt) db.session().save(cfg);
if (autoCommit) tx.commit();
} catch (HibernateException e) {
db.getLog().warn(e);
}
}
private void LogMasuk() {
SysConfig sc = new SysConfig();
String pass = "";
char chrPass[] = txtPass.getPassword();
for (int i = 0; i < chrPass.length; i++) {
pass = pass + chrPass[i];
chrPass[i] = '0';
}
// KasirCon conn = new KasirCon("jdbc:postgresql://"+sc.getServerLoc()+":5432/"+sc.getDBName(),
// txtKasir.getText(), pass, this);
iCount++;
if (iCount == 3) {
System.exit(1);
}
try {
Statement st =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
// ResultSet rs = st.executeQuery("select usename,usesysid,usesuper from pg_user where
// usename='"+ txtKasir.getText().trim() +"'");
String sQry =
"select user_id, pwd, username, coalesce(profile, -1) as profile "
+ "from m_user "
+ "where username='******' "
+ "and pwd=md5('"
+ pass
+ "') ";
ResultSet rs = st.executeQuery(sQry);
// System.out.println(sQry);
if (rs.next()) {
sName = rs.getString("username").trim();
authority = rs.getInt("profile");
// sKota=lstModel.getElementAt(cmbGudang.getSelectedIndex()).toString();
timer.cancel();
setVisible(false);
fMain = new MainForm();
fMain.setConn(con);
fMain.setUserProfile(rs.getInt("profile"));
fMain.setUserName(sName);
fMain.setServerLocation(sc.getServerLoc());
fMain.udfSetUserMenu();
fMain.setVisible(true);
} else {
JOptionPane.showMessageDialog(this, "Silakan masukkan nama user & passwod dengan benar!");
txtKasir.requestFocus();
txtKasir.setSelectionStart(0);
txtKasir.setSelectionEnd(txtKasir.getText().length());
}
} catch (SQLException se) {
JOptionPane.showMessageDialog(this, se.getMessage());
}
}
private void formWindowOpened(
java.awt.event.WindowEvent evt) { // GEN-FIRST:event_formWindowOpened
// image/Login.jpg
// String fileImage="image/Login.jpg";
// LabelIcon(fileImage,jLabel8);
// try {
// UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
// } catch (Exception e) {}
// SystemConfig sc=new SystemConfig();
conn =
new KasirCon(
"jdbc:postgresql://" + sc.getServerLoc() + ":5432/" + sc.getDBName(),
"postgres",
"bismillah",
this);
// conn = new KasirCon("jdbc:postgresql://"+sc.getServerLoc()+":5432/"+sc.getDBName(), "joss",
// "123", this);
if (conn.gettErrLog() == true) {
con = conn.getCon();
}
txtKasir.addFocusListener(txtFoculListener);
txtPass.addFocusListener(txtFoculListener);
i = pBar.getX();
timer = new Timer();
timer.schedule(new DoTick(), 0, 5);
java.text.SimpleDateFormat fdate2 = new java.text.SimpleDateFormat("HH:mm");
Date jamNow = Calendar.getInstance().getTime();
System.out.println("JAM: " + fdate2.format(jamNow.getTime()));
// this.getRootPane().setWindowDecorationStyle(JRootPane.FRAME);
// this.setExtendedState(MAXIMIZED_BOTH);
// try{
// Statement st=con.createStatement();
// ResultSet rs=st.executeQuery("select kode_resort, coalesce(nama_resort, '') as
// nama_resort from m_Resort");
//
// lstModel.removeAllElements();
//
// int idx=0;
// lstModel.add(idx, "");
// cmbGudang.addItem("<Semua Resort>");
// idx++;
//
// while(rs.next()){
// cmbGudang.addItem(rs.getString("nama_resort"));
// lstModel.add(idx, rs.getString("kode_resort"));
//
// idx++;
// }
//
// }catch(SQLException se){
// JOptionPane.showMessageDialog(this, se.getMessage());
// }
} // GEN-LAST:event_formWindowOpened
/**
* @param name property name
* @param defaultValue default value
* @return if property exists, return its value, otherwise defaultValue.
*/
public String get(String name, String defaultValue) {
try {
if (prefix != null) name = prefix + name;
SysConfig cfg = (SysConfig) db.session().get(SysConfig.class, name);
if (cfg != null) return cfg.getValue();
} catch (HibernateException e) {
db.getLog().warn(e);
}
return defaultValue;
}
@Test
public void testLoad() {
InputStream is = getClass().getResourceAsStream("/qqstatus.properties");
SysConfig conf = new SysConfig();
conf.load(is);
// # fetch qq status images per minute
assertEquals("fetcher.run", false, conf.isRunFetcher());
assertEquals("fetcher.period", 300000, 300000);
// #image size
assertEquals("image.height", 15000, conf.getImageHeight());
assertEquals("image.width", 200, conf.getImageWidth());
assertEquals("image.url.begin", "http://wpa.qq.com/pa?p=2:", conf.getImageUrlBegin());
assertEquals("image.url.end", ":41", conf.getImageUrlEnd());
assertEquals("image.size", 1243, conf.getImageSize());
// tracker
assertEquals("tracker.run", true, conf.isRunTracker());
assertEquals("tracker.period", 60000, conf.getTrackerPeriod());
// mail
assertEquals("mail.notify.period", 86400000, conf.getMailPeriod());
assertEquals("mail.notify.delay", 5000, conf.getMailDelay());
assertEquals("mail.username", "", "");
assertEquals("mail.password", "", "");
assertEquals("mail.pop3", "", "");
assertEquals("mail.type", "", "");
}
