<%@ page language="java" import="java.sql.*" pageEncoding="gbk"%>

<%!
	
		String driverName ="com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
		String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; 
		String userName = "sa"; 
		String userPwd = ""; 
		Connection dbConn; 
		
		try { 
			Class.forName(driverName); 
			dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
			System.out.println("Connection Successful!"); 
		} 
		catch(Exception e){ 
			e.printStackTrace(); 
		} 
	 
%>