µ±Ç°Î»Ö㺠´úÂëÃÔ >> J2SE >> Ϊʲôͬһ¸ö°üϵÄÀ಻ÄÜÒýÓ㬱àÒëÒì³£
  Ïêϸ½â¾ö·½°¸

Ϊʲôͬһ¸ö°üϵÄÀ಻ÄÜÒýÓ㬱àÒëÒì³£

Èȶȣº375   ·¢²¼Ê±¼ä£º2016-04-24 15:38:46.0
Ϊʲôͬһ¸ö°üϵÄÀ಻ÄÜÒýÓ㬱àÒë´íÎó¡£
Á½¸öÀà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();
  Ïà¹Ø½â¾ö·½°¸