databaseconnection.java

来自「该代码是《JSP应用与开发实例》一书的配套光盘」· Java 代码 · 共 24 行

package com.jspdev.util;
import java.sql.*;
public class DataBaseConnection
{
	public static Connection getConnection()
	{
		Connection con=null;
		String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	    String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
	    String USER="bn";
	    String PWD="bn"; 
	    try
	    {
	    	
	    	Class.forName(CLASSFORNAME);
			con = DriverManager.getConnection(SERVANDDB,USER,PWD);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return con;
	}
}