/** 利用属性文件中的信息连接数据库 * */
public static Connection getConnection() throws SQLException, IOException {
Properties props = new Properties();
String fileName = "QueryDB.properties";
FileInputStream in = new FileInputStream(fileName);
props.load(in);
String drivers = props.getProperty("jdbc.drivers");
if (drivers != null) System.setProperty("jdbc.drivers", drivers);
String url = props.getProperty("jdbc.url");
String username = props.getProperty("jdbc.username");
String password = props.getProperty("jdbc.password");
return DriverManager.getConnection(url, username, password);
}
/**
* Creates a new Outline object.
*
* @param djvuBean the DjVuBean to navigate.
* @throws ArrayIndexOutOfBoundsException if the document has less than 2 pages.
*/
public Outline(final DjVuBean djvuBean) {
this.djvuBean = djvuBean;
if (djvuBean.getDocument().size() < 2) {
throw new ArrayIndexOutOfBoundsException("Can not navigate documents with only one page.");
}
final MouseListener mouseListener =
new MouseAdapter() {
public void mouseClicked(final MouseEvent e) {
try {
clickLocation(e.getX(), e.getY());
} catch (final Throwable exp) {
exp.printStackTrace(DjVuOptions.err);
System.gc();
}
}
};
addMouseListener(mouseListener);
final Document document = djvuBean.getDocument();
final Bookmark bookmark = (Bookmark) document.getBookmark();
bookmark.setDjVmDir(document.getDjVmDir());
setFirstBookmark(bookmark);
final Properties properties = djvuBean.properties;
properties.put("addOn.NavPane", "Outline," + properties.getProperty("addOn.NavPane", "None"));
djvuBean.addPropertyChangeListener(this);
}
// 采用静态初始化块来初始化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();
}
}
public void actionPerformed(java.awt.event.ActionEvent arg0) {
JPanel4.showCard("router"); // No Internationalisation
Properties prop = (Properties) routerobject.elementAt(0);
((com.adventnet.nms.examples.routermap.RouterDetails) JPanel4.getCard("router"))
.setValues((Properties) routerobject.elementAt(0)); // No Internationalisation
JLabel1.setText(
NmsClientUtil.GetString("Router details : ")
+ prop.getProperty("name")); // No Internationalisation
}
private void laden(Path saveName) throws IOException {
Properties prop = new Properties();
FileInputStream in = new FileInputStream(saveName.toString());
prop.load(in);
for (int i = 0; prop.containsKey(String.format("quellMenu%d", i)); i++)
quellListModel.addElement(
new ListItem(
Paths.get(prop.getProperty(String.format("quellMenu%d", i))),
Paths.get(prop.getProperty(String.format("quellMenu%d", i)))));
for (int i = 0; prop.containsKey(String.format("zielMenu%d", i)); i++)
zielListModel.addElement(
new ListItem(
Paths.get(prop.getProperty(String.format("zielMenu%d", i))),
Paths.get(prop.getProperty(String.format("zielMenu%d", i)))));
in.close();
}
private String replace(String string, Properties table) {
try {
Pattern pattern = Pattern.compile("\\$\\{\\w+\\}");
Matcher matcher = pattern.matcher(string);
StringBuffer sb = new StringBuffer();
while (matcher.find()) {
String group = matcher.group();
String key = group.substring(2, group.length() - 1).trim();
String repl = table.getProperty(key);
if (repl == null) repl = matcher.quoteReplacement(group);
matcher.appendReplacement(sb, repl);
}
matcher.appendTail(sb);
return sb.toString();
} catch (Exception ex) {
return string;
}
}
protected static boolean vnmrjPassword(String strUser, char[] password) {
boolean blogin = false;
try {
PasswordService objPassword = PasswordService.getInstance();
String encrPassword = objPassword.encrypt(new String(password));
if (pwprops == null) {
String strPath = FileUtil.openPath(WUserUtil.PASSWORD);
if (strPath == null) return blogin;
pwprops = new Properties();
FileInputStream fis = new FileInputStream(strPath);
pwprops.load(fis);
fis.close();
}
String stoPassword = pwprops.getProperty(strUser);
if (encrPassword.equals(stoPassword)) blogin = true;
} catch (Exception e) {
// e.printStackTrace();
Messages.writeStackTrace(e);
}
return blogin;
}
void refresh() {
JPanel4.showCard("router"); // No Internationalisation
if (routerobject != null) {
((com.adventnet.nms.examples.routermap.RouterDetails) JPanel4.getCard("router"))
.setValues((Properties) routerobject.elementAt(0)); // No Internationalisation
Properties prop = (Properties) routerobject.elementAt(0);
RouterBtn.setBackground(
SeverityInfo.getInstance()
.getColor(Integer.parseInt(prop.getProperty("status")))); // No Internationalisation
RouterBtn.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
JLabel1.setText(
NmsClientUtil.GetString("Router details : ")
+ prop.getProperty("name")); // No Internationalisation
}
if (routerobject.size() >= 2) {
one.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(1);
one.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
one.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 3) {
two.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(2);
two.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
two.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 4) {
three.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(3);
three.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
three.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 5) {
four.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(4);
four.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
four.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 6) {
five.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(5);
five.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
five.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 7) {
six.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(6);
six.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
six.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 8) {
seven.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(7);
seven.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
seven.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 9) {
eight.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(8);
eight.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
eight.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 10) {
nine.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(9);
nine.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
nine.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
if (routerobject.size() >= 11) {
ten.setVisible(true);
Properties prop = (Properties) routerobject.elementAt(10);
ten.setValues(
SeverityInfo.getInstance().getColor(Integer.parseInt(prop.getProperty("status"))),
prop.getProperty("ipAddress")); // No Internationalisation
ten.setToolTipText(prop.getProperty("ipAddress")); // No Internationalisation
}
}
protected String getProperty(String key) {
return properties.getProperty(key);
}
