JavaWeb项目 与 Sql server 数据库连接
DB.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DB {
private static final String DRIVERCLASS =
"com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String DRIVERURL =
"jdbc:sqlserver://localhost:1433;DatabaseName=db_CityInfo";
private static final String DRIVERUSERNAME = "sa";
private static final String DRIVERPASSWORD = "";
private Connection conn = null;
private PreparedStatement pStm = null;
private ResultSet res = null;
public DB(){
try{
Class.forName(DRIVERCLASS);
System.out.println("数据库驱动程序注册成功");
}catch(Exception e){
e.printStackTrace(