eclipse +Tomcat 连接sql server 2005数据库 配置.

第一步：

db.properties配置文件：

dbdriver=com.microsoft.sqlserver.jdbc.SQLServerDriver

url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ExamDemoDB
password=123456

user=sa

类ReadDataBaseFile.java:

package com.icss.util;


import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.net.URISyntaxException;
import java.util.Properties;

public class ReadDataBaseFile {
private  String driver;
private  String url;
private  String user;
private  String pwd;
public static ReadDataBaseFile dateBase;


private ReadDataBaseFile() {
try {
String path = ReadDataBaseFile.class.getResource("/").toURI()
.getPath()
+ "db.properties";
Properties ps = new Properties();
ps.load(new FileInputStream(path));
driver = ps.getProperty("dbdriver");
url = ps.getProperty("url");
user = ps.getProperty("user");
pwd = ps.getProperty("password");
} catch (URISyntaxException e) {
Log.logger.error(e.getMessage());
} catch (FileNotFoundException e) {
Log.logger.error(e.getMessage());
} catch (IOException e) {
Log.logger.error(e.getMessage());
} catch (Exception e) {
Log.logger.error(e.getMessage());
}
}


public String getDriver() {
return driver;
}


public String getUrl() {
return url;
}


public String getUser() {
return user;
}


public String getPwd() {
return pwd;
}


public static ReadDataBaseFile getDateBase() {
return dateBase;
}

public static ReadDataBaseFile newInstance() {
if (dateBase == null) {
synchronized (ReadDataBaseFile.class) {
if (dateBase == null) {
dateBase = new ReadDataBaseFile();
}
}
}
return dateBase;
}

}

第二步：

log4j.properties：

log4j.rootLogger=INFO,AA,BB




log4j.appender.AA=org.apache.log4j.ConsoleAppender
log4j.appender.AA.Target=System.err
log4j.appender.AA.layout=org.apache.log4j.SimpleLayout




log4j.appender.BB=org.apache.log4j.FileAppender
log4j.appender.BB.File=BookShop.log
log4j.appender.BB.layout=org.apache.log4j.PatternLayout
log4j.appender.BB.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %l %F %p %m%n

类Log.java:

package com.icss.util;

import org.apache.log4j.Logger;

public class Log {
public static Logger logger = Logger.getLogger(Log.class.getName());
}