1、连接SQLite数据库
public Connection connectSQLite(String databasePath){
Connection con = null;
String url = null;
try {
//加载数据库驱动
Class.forName("org.sqlite.JDBC");
try {
//连接到数据库
url = "jdbc:sqlite:" + databasePath;
con = DriverManager.getConnection(url);
return con;
}catch (Exception e){
out.println(e + "\nSQLite数据库连接失败!");
return null;
}
}catch (Exception e){
out.println(e + "\nSQLite数据库驱动加载失败!");
return null;
}
}
注:SQLite数据库十分轻巧,不需任何安装,只需下载Navicat for SQLite即可创建及打开*.db文件(数据库
文件)。
2、连接MySQL
数据库
public Connection connectMySQL(String databaseName, final String user, final String pwd){ Connection con = null; String url = null; try { //加载驱动 Class.forName("com.mysql.jdbc.Driver"); try { //连接数据库 url = "jdbc:mysql://localhost:3306/" + databaseName; con = DriverManager.getConnection(url, user, pwd); return con; }catch (Exception e){ out.println(e + "\nMySQL数据库连接失败!"); return null; } }catch (Exception e){ out.println(e + "\nMySQL数据库驱动加载失败!"); return null; } } 注:有时候(如在JSP开发中)需要对字符进行转码,就还得加上编码方式,不然汉字在数据库中就为乱码。 即:url =
"jdbc:mysql://localhost:3306/" + databaseName + "?userUnicode=true&characterEncoding=utf8";
3、连接Sql Server数据库注:SQLite、MySQL、Sql Server均有相应的Navicat软件。public Connection connectSqlServer(String databaseName, final String user, final String pwd) { Connection con = null; String url = null; try { //加载数据库驱动 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); try { //连接数据库 url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=" + databaseName; con = DriverManager.getConnection(url, user, pwd); return con; }catch (Exception e){ out.println(e + "\nSqlServer数据库连接失败!"); return null; } }catch (Exception e){ out.println(e + "\nSqlServer数据库驱动加载失败!"); return null; } }