dbconnection.java

简单的员工管理

package com.db;

import java.sql.*;

import javax.sql.*;

import org.apache.struts.action.ActionServlet;
public class DBConnection {
	private static final DBConnection dbconn=new DBConnection();
	private ActionServlet servlet;
	private Connection conn=null;
	private DBConnection(){}
	
	public static DBConnection getDBConnection()
	{
		return dbconn;
	}
	
	//获得链接
	public Connection getConn()
	{
//		DataSource ds=servlet.findDataSource("mssql2000");
//		try {
//			conn=ds.getConnection();
//		} catch (SQLException e1) {
//			// TODO Auto-generated catch block
//			e1.printStackTrace();
//		}
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:test","sa","");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	public ActionServlet getServlet() {
		return servlet;
	}
	public void setServlet(ActionServlet servlet) {
		this.servlet = servlet;
	}
}