程序里有一个DBconnectinfo.java 还有一个DBconnect_java_nopool.class文件是改这两个吗?下面是那个.java文件 import java.sql.*;public class DBConnectInfo { public DBConnectInfo() { } public String getsqlserverDriver() { return sqlserverDriver; } public String getsqlserverUrl() { return sqlserverUrl; } public String getsqlserverUsername() { return sqlserverUsername; } public String getsqlserverPassword() { return sqlserverPassword; } public String getEmailIfConnectionFailed() { return emailIfConnectionFailed; } //-- driver is your database driver. Default:com.mysql.jdbc.Driver private String sqlserverDriver="com.microsoft.jdbc.sqlserver.sqlserverDriver"; //--url is DB connection URL. You can change IP and database name to fit your config private String sqlserverUrl="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=lybbs"; //-- username is your username connected to database. Default:lybbs private String sqlserverUsername="panlei"; //-- password is your password connected to database. Default:lybbs private String sqlserverPassword="light119"; //-- emailIfConnectionFailed will be viewed on web for contact when DB connection failed. private String emailIfConnectionFailed="[email protected]";
再把相应的sql语句改下就行了
这些都应该是在javabean中封装好的
很简单的!
修改需要修改的Sql语句
import java.sql.*;public class DBConnectInfo {
public DBConnectInfo() {
} public String getsqlserverDriver() {
return sqlserverDriver;
} public String getsqlserverUrl() {
return sqlserverUrl;
} public String getsqlserverUsername() {
return sqlserverUsername;
} public String getsqlserverPassword() {
return sqlserverPassword;
} public String getEmailIfConnectionFailed() {
return emailIfConnectionFailed;
} //-- driver is your database driver. Default:com.mysql.jdbc.Driver
private String sqlserverDriver="com.microsoft.jdbc.sqlserver.sqlserverDriver"; //--url is DB connection URL. You can change IP and database name to fit your config
private String sqlserverUrl="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=lybbs"; //-- username is your username connected to database. Default:lybbs
private String sqlserverUsername="panlei"; //-- password is your password connected to database. Default:lybbs
private String sqlserverPassword="light119"; //-- emailIfConnectionFailed will be viewed on web for contact when DB connection failed.
private String emailIfConnectionFailed="[email protected]";