package com.pegasus.db;{0}//happylipublic class S_MySQL {/** * @param args */public static void main(String[] args) {} {1}}
S_MySQL.java
import java.io.File;import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Properties;
public static Properties loadPropertiesFile(String fileName) { Properties prop = new Properties(); InputStream is = null; try { System.out.println(new File(fileName).getAbsolutePath()); File file = new File(fileName); if (!file.exists()) { is = S_MySQL.class.getResourceAsStream(fileName); } else { is = new FileInputStream(file); } if (is != null) { prop.load(is); } } catch (IOException ex){ //HomeLogger.error("[HomeUtil,Joshua]loadPropertiesFile,load properties error.Msg:" + ex.getMessage()); } finally { if (is != null) { try { is.close(); } catch (IOException ex) { //HomeLogger.error("[HomeUtil,Joshua]loadPropertiesFile,close input stream error.Msg:" + ex.getMessage()); } } } //HomeLogger.debug("[HomeUtil,Joshua]loadPropertiesFile,end. result:" + prop); return prop; }
public static Connection getConnect() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{Properties p=loadPropertiesFile("/DB.properties");String strConnectString=(String)p.get("ConnectString");String strUser=(String)p.get("User");String strPassword=(String)p.get("Password");Class.forName("com.mysql.jdbc.Driver").newInstance();//建立到MySQL的连接Connection conn = DriverManager.getConnection(strConnectString,strUser,strPassword);return conn;}
E:\Data\AntProject\WebPegasus\src\java\com\pegasus\db\