Jsp/Servlet

开发平台：

Java

ConnDB.java~7~：源码内容

							package core;
import java.sql.*;
import java.util.Properties;
public class ConnDB {
    public Connection conn=null;
    public ResultSet rs=null;
    public Statement stmt=null;
    private static String propFileName="connDB.properties";
    private static Properties prop=new Properties();
    private static String dbClassName =
    "com.mysql.jdbc.Driver";
    private static String dbUrl =
    "jdbc:mysql://127.0.0.1:3306/db_libraryManage";
    private static String dbUser = "admin";
    private static String dbPwd = "111";
    private static void loadProperty() {
        try {
            prop.load(new FileInputStream(propFileName)); //通过文件输入流对象加载Properties文件
            dbClassName = prop.getProperty("DB_CLASS_NAME");
            dbUrl = prop.getProperty("DB_URL",
                                     "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop");
            dbUser = prop.getProperty("DB_USER", "admin");
            dbPwd = prop.getProperty("DB_PWD", "111");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

						