📄 dbconnect.java
字号:
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;
public class DBConnect
{
private Connection con;
private String driverUrl;
public Connection getConnection(String dbPath)
{
File f = new File(dbPath);
if(f.exists())
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
driverUrl = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + dbPath;
con = DriverManager.getConnection(driverUrl,"管理员","123456");
if(!con.isClosed())
System.out.println("DataBase connected!");
}
catch (ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
catch (SQLException e)
{
System.out.println(e.getMessage());
}
return con;
}
else
{
JOptionPane.showMessageDialog(null,"config.bin文件缺失");
System.exit(0);
return null;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -