306027a091cd001d161a8fa9da235848

用struts框架做的jsp通讯录

package com.csthit.phonebook.db;



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

public class ConnClass {
	private static ConnClass instance = new ConnClass();
	private static Connection conn=null;
	private ConnClass(){}
	public static ConnClass getInstance(){
		
		return instance;
	}
	public static Connection getConn(){
 		String classname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
		try {
			Class.forName(classname);
			conn =DriverManager.getConnection(url,"sa","");
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			//conn = DriverManager.getConnection("jdbc:odbc:helin","sa","");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
}