Ϊʲôͬһ¸ö°üϵÄÀ಻ÄÜÒýÓ㬱àÒë´íÎó¡£
Á½¸öÀà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();
password = readdbconfig.password();
}
public void setSQLyuju(String sqlyuju) {
this.sqlyuju = sqlyuju;
}
public String getSQLyuju() {
return sqlyuju;
}
public ResultSet getResultSet() {
try {
Class.forName(driver);
} catch(Exception e) {
System.out.println( "ÎÞ·¨¼ÓÔØÇý¶¯³ÌÐò£¡ " + driver);
e.printStackTrace();
}
/********Êý¾Ý¿â²éѯ*********/
try {
con = DriverManager.getConnection(url,user,password);
smt = con.createStatement();
rst = smt.executeQuery(sqlyuju);
} catch(SQLException ex) {
System.out.println( "Êý¾Ý¿âÁ¬½Ó²éѯ´íÎó " + ex);
ex.printStackTrace();
}
}
public int getUpdate() {
try {
Class.forName(driver);
} catch(Exception e) {
System.out.println( "ÎÞ·¨¼ÓÔØÇý¶¯³ÌÐò£¡ " + driver);
e.printStackTrace();
}
/********Êý¾Ý¿â²Ù×÷*********/
try {
con = DriverManager.getConnection(url,user,password);
smt = con.createStatement();
i = smt.executeUpdate(sqlyuju);
} catch(SQLException ex) {
System.out.println( "Êý¾Ý¿âÁ¬½Ó²éѯ´íÎó£¡ " + ex);
ex.printStackTrace();
}
return i;
}
public void closeAll() {
try {
con.close();
smt.close();
rst.close();
} catch(SQLException ex) {
System.out.println( "Êý¾Ý¿âÁ¬½ÓÎÞ·¨¹Ø±Õ " + ex);
ex.printStackTrace();
}
}
}
[½â¾ö°ì·¨]
ÎÒÔÚeclipseÏÂ×öµÄ£¬±àÒëͨ¹ý
ÄãÔÚcommand´°¿ÚϱàÒëÊÇ»áÓÐÕâÑùµÄÎÊÌâ
°ÑÕâÁ½¸öÎļþ·ÅÔÚqzjzÎļþ¼ÐÏ£¬±àÒëÊǵ½qzjzµÄÉϲãĿ¼£¬ÊäÈë
javac qzjz/ReadDBConfig.java½øÐбàÒ룬Ӧ¸ÃûÎÊÌâ