Á½¸öÀàReadDBConfig.java ºÍ CustomSQL.java£¬ReadDBConfig.java ±àÒëͨ¹ý£¬ÔÚJSPÖÐÒýÓÃÒ²¿ÉÒÔÓ㬵«CustomSQL.java¾ÍÊDZàÒë³öÁ½¸ö´íÎó¡£
package qzjz;
import java.sql.*;
import java.io.*;
import java.util.Properties;
public class ReadDBConfig {
//Êý¾Ý¿âÇý¶¯
private String driver;
//Êý¾Ý¿âURL
private String url;
//Êý¾Ý¿âÓû§Ãû
private String user;
//Êý¾Ý¿âÓû§ÃÜÂë
private String password;
private Properties props = new Properties();
public ReadDBConfig() {
try{
//¶ÁÈ¡ÅäÖÃÎļþ
InputStream in = new FileInputStream( "dbConfig.properties ");
props.load(in);
//¶ÁÈ¡ÊôÐÔÎļþµÄÖµ
driver = props.getProperty( "driver ");
url = props.getProperty( "url ");
user = props.getProperty( "user ");
password = props.getProperty( "password ");
//¹Ø±ÕÊäÈëÁ÷
in.close();
if(driver == null||null == url||null == user||null == password)
System.out.println( "¶ÁÈ¡ÊôÐÔÎļþµÄ×ÊÁϲ»È«¡£ ");
} catch(Exception e) {
System.out.println( "¶ÁÈ¡Êý¾Ý¿âÅäÖÃʧ°Ü ");
e.printStackTrace();
}
}
//ÊôÐÔ²Ù×÷
public void setDriver(String driver) {
this.driver = driver;
}
public void setURL(String url) {
this.url = url;
}
public void setUser(String user) {
this.user = user;
}
public void setPassword(String password) {
this.password = password;
}
public String getDriver() {
return driver;
}
public String getURL() {
return url;
}
public String getUser() {
return user;
}
public String getPassword() {
return password;
}
//дÈëÊý¾Ý¿âÅäÖÃÎļþ
public void writeDBConfig() {
props.setProperty( "driver ",driver);
props.setProperty( "url ",url);
props.setProperty( "user ",user);
props.setProperty( "password ",password);
try {
OutputStream ops = new FileOutputStream( "dbConfig.properties ");
props.store(ops,null);
ops.close();
} catch(IOException ioe) {
System.out.println( "±£´æÊý¾Ý¿âÅäÖÃʧ°Ü£¡ ");
ioe.printStackTrace();
}
}
}
package qzjz;
import java.sql.*;
public class CustomSQL {
private String sqlyuju;
private String driver;
private String url;
private String user;
private String password;
private Connection con;
private Statement smt;
private ResultSet rst;
private int i;
public void CustomSQL() {
ReadDBConfig readdbconfig = new ReadDBConfig();//¾ÍÊÇÕâ¾ä±àÒë³ö´í
driver = readdbconfig.getDriver();
url = readdbconfig.getURL();
user = readdbconfig.getUser();