Ê×Ò³ Ê«´Ê ×Öµä °å±¨ ¾ä×Ó ÃûÑÔ ÓÑ´ð ÀøÖ¾ ѧУ ÍøÕ¾µØÍ¼
µ±Ç°Î»ÖÃ: Ê×Ò³ > ½Ì³ÌƵµÀ > JAVA > J2SE¿ª·¢ >

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

2011-12-12 
Ϊʲôͬһ¸ö°üϵÄÀ಻ÄÜÒýÓ㬱àÒë´íÎó¡£Á½¸öÀàReadDBConfig.javaºÍCustomSQL.java£¬ReadDBConfig.java±àÒë

Ϊʲôͬһ¸ö°üϵÄÀ಻ÄÜÒýÓ㬱àÒë´íÎó¡£
Á½¸öÀà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½øÐбàÒ룬Ӧ¸ÃûÎÊÌâ

ÈȵãÅÅÐÐ