dbcon.java

products program INSTRACTION item

package com.nextier.model;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBcon {
	public  static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
	//public  static String dbURL = "jdbc:microsoft:sqlserver://172.16.1.144:1433; DatabaseName=infosearch"; 
	public  static String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=infosearch"; 
	private static String userName = "sa"; 
	private static String userPwd = "sa"; 
	public  static Connection getConnection() { 
	  Connection dbconn=null; 
	try { 
	  Class.forName(driverName); 
	  dbconn = DriverManager.getConnection(dbURL, userName, userPwd); 
	  System.out.println("Connection Successful!"); 
	} 
	catch (Exception e) { 
	  e.printStackTrace(); 
	  System.out.println("aa");
	} 
    return dbconn; 
	}
}