conndb.java~6~

是一个用jsp做前台

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.microsoft.jdbc.sqlserver.SQLServerDriver";
    private static String dbUrl =
    "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop";
    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();
        }
    }

}