![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package identsql;
import java.sql.*;
import java.util.Map;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.awt.*;
import java.awt.event.*;
/**
*
* @author skennedy
*/
public class identSQL implements Runnable {
// TODO code application logic here
Statement stmt = null;
ResultSet rs = null;
Connection con = null;
int sleepTime = 1000 * 60 * 5; // 5 minutes between username/computername refresh
String dbUsername = null;
String dbPassword = null;
String dbDatabase = null;
String dbServer = null;
Thread t;
public identSQL() {
t = new Thread(this);
t.start();
dbUsername = "username";
dbPassword = "password";
dbDatabase = "database";
dbServer = "server";
//System.out.println("Hi there!");
final TrayIcon trayIcon;
if (SystemTray.isSupported()) {
SystemTray tray = SystemTray.getSystemTray();
Image image = Toolkit.getDefaultToolkit().getImage("displays.ico");
MouseListener mouseListener = new MouseListener() {
public void mouseClicked(MouseEvent e) {
}
public void mouseEntered(MouseEvent e) {
}
public void mouseExited(MouseEvent e) {
}
public void mousePressed(MouseEvent e) {
}
public void mouseReleased(MouseEvent e) {
}
};
ActionListener exitListener = new ActionListener() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
};
PopupMenu popup = new PopupMenu();
MenuItem defaultItem = new MenuItem("Exit");
defaultItem.addActionListener(exitListener);
popup.add(defaultItem);
trayIcon = new TrayIcon(image, "IdentSQL", popup);
ActionListener actionListener = new ActionListener() {
public void actionPerformed(ActionEvent e) {
trayIcon.displayMessage("Action Event",
"An Action Event Has Been Performed!",
TrayIcon.MessageType.INFO);
}
};
trayIcon.setImageAutoSize(true);
trayIcon.addActionListener(actionListener);
trayIcon.addMouseListener(mouseListener);
try {
tray.add(trayIcon);
} catch (AWTException e) {
System.err.println("TrayIcon could not be added.");
}
} else {
// System Tray is not supported
}
}
public void run() {
try {
Class.forName("com.mysql.jdbc.Driver");
String connectionUrl = "jdbc:mysql://" + dbServer +"/"+ dbDatabase +"?"+
"user="+ dbUsername +"&password="+dbPassword;
con = DriverManager.getConnection(connectionUrl);
} catch (SQLException e) {
System.out.println("SQL Exception: " + e.toString() );
} catch (ClassNotFoundException e) {
System.out.println("Class Not Found Exception: " + e.toString() );
}
try {
stmt = con.createStatement();
} catch (SQLException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
Map<String,String> env = System.getenv();
String computername = env.get("COMPUTERNAME");
String username = env.get("USERNAME");
String userSQL = null;
do{
String checkUserSQL = String.format( "SELECT count(*) FROM ident WHERE username='%s' AND computername='%s'", username, computername );
try {
rs = stmt.executeQuery(checkUserSQL);
rs.next();
int recordExist = rs.getInt("count(*)" );
if( recordExist == 1 ) {
// Record exists, update
userSQL = String.format( "Update ident SET ts=CURRENT_TIMESTAMP() WHERE username='%s' AND computername='%s'", username, computername );
} else {
userSQL = String.format( "INSERT into ident ( computername, username ) VALUES ( '%s', '%s' )", computername, username );
}
// System.out.println( userSQL );
stmt.executeUpdate(userSQL);
} catch (SQLException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
try {
Thread.sleep( sleepTime );
} catch (InterruptedException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
} while(true);
}
}Ah...I think we might be talking about two different kinds of users. This is how that would play out,
Yes and no. Yes, it's out of the question to change the user's background. But no, bginfo isn't out of the question entirely. It seems it can be used to log information to a remote server, which would be ideal, without any graphic notification to the user.
