dbutil.java

swnglu数据库连接统struts和hinernate

package model;
import java.io.*;
import java.sql.*;

public class DbUtil {
	public static Connection connectToDb(String hostName, String databaseName )throws Exception{
		Connection conn = null;
	
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
		conn = DriverManager.getConnection 
		  ("jdbc:microsoft:sqlserver://"+
				  hostName+
				  ":1433;databasename="+databaseName+";User=sa;Password=123");
		

		return conn;
	}
	
	public static java.sql.Connection connectToDb()throws Exception{
		return connectToDb("localhost","D_ADDRESSBOOK");
		
	}
	
	
	public static Connection connectToDb(String databaseName)throws Exception{

		return connectToDb("127.0.0.1",databaseName);
		
	}
	
	public static void main(String args[]){
		DbUtil mydbutil = new DbUtil();
		String str = new String();
		try{
		str = DbUtil.connectToDb().toString();
		}
		catch(Exception e){
			System.out.println(e.toString());
		}
		System.out.println(str);
	}
	

}