c07ae73fd8cc001d159ac0bb64c29be7

用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=AddressList-helin";
		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;
	}
}