Java JDBC - 如何設(shè)置JDBC MS Access工作組(MDW)中現(xiàn)有的密碼
我們想知道如何設(shè)置JDBC MS Access工作組(MDW)中現(xiàn)有的密碼。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class Main {
public static void main(String args[]) throws Exception {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager
.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};"
+ "DBQ=C:\\Users\\Public\\uls\\ulsTest.mdb;"
+ "SystemDB=C:\\Users\\Public\\uls\\Security.mdw;" + "Uid=Gord;"
+ "Pwd=obfuscated;" + "ExtendedAnsiSQL=1;");
String UID = "Tim";
String oldPWD = "oldpassword";
String newPWD = "I like Java";
Statement s = conn.createStatement();
s.execute("ALTER USER " + UID + " PASSWORD \"" + newPWD + "\" \"" + oldPWD
+ "\"");
s.close();
conn.close();
}
}