dbconn.java

挺好的东东

/***********************************************
 /*
 /*数据库连接文件
 /*
 /******************************************* */
package com.util;

import java.sql.*;

public class DBConn {
             static String  driverName  =    "com.microsoft.jdbc.sqlserver.SQLServerDriver";  
             static String  dbURL  =    "jdbc:Microsoft:sqlserver://localhost;DatabaseName=sll103111040";  
             static String  userName  =    "sa";  
             static String  userPwd  =    "sa";  
             static Connection  dbConn=null;  

             public DBConn(){
            	 } 
            
public static Connection getConn(){

       try {
 
  Class.forName(driverName);   
  dbConn=DriverManager.getConnection(dbURL+";User="+userName+";Password="+userPwd);  
       }
       catch (Exception e) {
        e.printStackTrace();   
       }
       return dbConn;
    }
}