packageNetBarManagerSystem;importjava.sql.*;importjavax.swing.JDialog;importjava.awt.Toolkit;importjava.awt.Dimension;importjavax.swing.JFrame;/****
Title:数据库连接类<...>
package NetBarManagerSystem;
import java.sql.*;
import javax.swing.JDialog;
import java.awt.Toolkit;
import java.awt.Dimension;
import javax.swing.JFrame;
/**
*
*
Title: 数据库连接类
*
*
Description:用于执行对数据库的操作
*
*
Copyright: Copyright (c) 2011
*
*
Company:
*
* @author not attributable
* @version 1.0
*/
public class ConnDB {
static final String DRIVER_Class = "sun.jdbc.odbc.JdbcOdbcDriver";
static final String DATESOURCE = "jdbc:odbc:netbardbc";
Statement stmt;
Connection con;
ResultSet rs;
PreparedStatement pstmt;
public void GetConnection() {
/*加载数据库驱动*/
try {
Class.forName(DRIVER_Class);
} catch (ClassNotFoundException ex) {
System.out.println("数据库驱动加载失败" + ex);
}
/*加载数据库连接*/
try {
con = DriverManager.getConnection(DATESOURCE);
} catch (SQLException ex) {
System.out.println("数据库连接失败" + ex);
}
}
/*关闭数据库ResultSet对象*/
public void CloseResultSet() {
if (rs != null) {
try {
rs.close();
} catch (SQLException ex) {
System.out.println("数据库结果集关闭失败" + ex);
}
}
}
/*关闭数据库PreparedStatement对象*/
public void ClosePreparedStatement() {
if (pstmt != null) {
try {
pstmt.close();
} catch (Exception ex) {
System.out.println("数据库关闭失败" + ex);
}
}
}
/*关闭数据库Statement对象*/
public void CloseStatement() {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException ex) {
System.out.println("数据库关闭失败" + ex);
}
}
}
/*关闭数据库Connection对象*/
public void CloseConnection() {
if (con != null) {
try {
con.close();
} catch (SQLException ex) {
System.out.println("数据库连接关闭失败" + ex);
}
}
}
/*设置JFrame界面居中*/
public static void JFrame_center(JFrame jFrame) {
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = jFrame.getSize();
if (frameSize.height > screenSize.height) {
frameSize.height = screenSize.height;
}
if (frameSize.width > screenSize.width) {
frameSize.width = screenSize.width;
}
jFrame.setLocation((screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
jFrame.setVisible(true);
}
}
展开