原代码是连接Mysql数据库的,现在连接Access数据库怎么修改啊??
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class Functions { /**
* 系统初始化,完成数据库连接
* @param driver
* @param mysqlUrl
* @param user
* @param password
* @return 数据库连接对象
*/
public Connection init(String driver, String mysqlUrl, String user,
String password) {
Connection conn = null;
try {
Class.forName(driver);
String dburl = mysqlUrl + "?user=" + user + "&password=" + password
+ "&useUnicode=true&characterEncoding=GBK";
conn = DriverManager.getConnection(dburl);
return conn;
} catch (Exception exception) {
exception.printStackTrace();
return null;
}
} public void closeDB(Connection conn){
if(conn !=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 字符串编码转换成GBK
* @param s 需要转码的字符串
* @return 转码后的字符串
*/
public String getStr(String s) {
String s2;
String s1 = s; try {
byte abyte0[] = s1.getBytes("GBK");
s2 = new String(abyte0);
return s2;
} catch (Exception exception) {
exception.printStackTrace();
}
return null;
} /**
* 处理HTML中的特殊字符
* @param s
* @return
*/
public String HtmlSpecialChars(String s) {
if (s == null || s.equals(""))
return s;
StringBuffer stringbuffer = new StringBuffer();
for (int i = 0; i < s.length(); i++)
if (s.charAt(i) == '\n')
stringbuffer = stringbuffer.append("<br>");
else if (s.charAt(i) == ' ')
stringbuffer = stringbuffer.append(" ");
else if (s.charAt(i) == '<')
stringbuffer = stringbuffer.append("<");
else if (s.charAt(i) == '>')
stringbuffer = stringbuffer.append(">");
else
stringbuffer = stringbuffer.append(s.substring(i, i + 1)); String s1 = stringbuffer.toString();
return s1;
}
public static void main(String[] args) {
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class Functions { /**
* 系统初始化,完成数据库连接
* @param driver
* @param mysqlUrl
* @param user
* @param password
* @return 数据库连接对象
*/
public Connection init(String driver, String mysqlUrl, String user,
String password) {
Connection conn = null;
try {
Class.forName(driver);
String dburl = mysqlUrl + "?user=" + user + "&password=" + password
+ "&useUnicode=true&characterEncoding=GBK";
conn = DriverManager.getConnection(dburl);
return conn;
} catch (Exception exception) {
exception.printStackTrace();
return null;
}
} public void closeDB(Connection conn){
if(conn !=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 字符串编码转换成GBK
* @param s 需要转码的字符串
* @return 转码后的字符串
*/
public String getStr(String s) {
String s2;
String s1 = s; try {
byte abyte0[] = s1.getBytes("GBK");
s2 = new String(abyte0);
return s2;
} catch (Exception exception) {
exception.printStackTrace();
}
return null;
} /**
* 处理HTML中的特殊字符
* @param s
* @return
*/
public String HtmlSpecialChars(String s) {
if (s == null || s.equals(""))
return s;
StringBuffer stringbuffer = new StringBuffer();
for (int i = 0; i < s.length(); i++)
if (s.charAt(i) == '\n')
stringbuffer = stringbuffer.append("<br>");
else if (s.charAt(i) == ' ')
stringbuffer = stringbuffer.append(" ");
else if (s.charAt(i) == '<')
stringbuffer = stringbuffer.append("<");
else if (s.charAt(i) == '>')
stringbuffer = stringbuffer.append(">");
else
stringbuffer = stringbuffer.append(s.substring(i, i + 1)); String s1 = stringbuffer.toString();
return s1;
}
public static void main(String[] args) {
}
}
driver="sun.jdbc.odbc.JdbcOdbcDriver";
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class Functions { /**
* 系统初始化,完成数据库连接
* @param driver
* @param mysqlUrl
* @param user
* @param password
* @return 数据库连接对象
*/
public Connection init(String driver, String mysqlUrl, String user,
String password) {
Connection conn = null;
try {
Class.forName(driver);
//String dburl = mysqlUrl + "?user=" + user + "&password=" + password
+ "&useUnicode=true&characterEncoding=GBK";
String dbrurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\SQL\\db.mdb";//你的ACCESS文件位置
conn = DriverManager.getConnection(dburl);
return conn;
} catch (Exception exception) {
exception.printStackTrace();
return null;
}
} public void closeDB(Connection conn){
if(conn !=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 字符串编码转换成GBK
* @param s 需要转码的字符串
* @return 转码后的字符串
*/
public String getStr(String s) {
String s2;
String s1 = s; try {
byte abyte0[] = s1.getBytes("GBK");
s2 = new String(abyte0);
return s2;
} catch (Exception exception) {
exception.printStackTrace();
}
return null;
} /**
* 处理HTML中的特殊字符
* @param s
* @return
*/
public String HtmlSpecialChars(String s) {
if (s == null || s.equals(""))
return s;
StringBuffer stringbuffer = new StringBuffer();
for (int i = 0; i < s.length(); i++)
if (s.charAt(i) == '\n')
stringbuffer = stringbuffer.append("<br>");
else if (s.charAt(i) == ' ')
stringbuffer = stringbuffer.append(" ");
else if (s.charAt(i) == '<')
stringbuffer = stringbuffer.append("<");
else if (s.charAt(i) == '>')
stringbuffer = stringbuffer.append(">");
else
stringbuffer = stringbuffer.append(s.substring(i, i + 1)); String s1 = stringbuffer.toString();
return s1;
}
public static void main(String[] args) {
}
}
其他都不用变