dbconnection.java

大学JSP课程大作业

package my.shop.db;

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

public class DBConnection {
	private static final String DRIVER ="sun.jdbc.odbc.JdbcOdbcDriver" ;
	private static final String url ="jdbc:odbc:shop" ;
	private static final String username ="" ;
	private static final String password ="" ;
	private static DBConnection dbc = new DBConnection() ;
	
	
	private DBConnection(){
		
	}
	public Connection getConnection(){
		Connection conn = null ;
		try {
			Class.forName(DRIVER) ;
			conn = DriverManager.getConnection(url,username,password) ;
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		return conn ;
	}
	public static DBConnection getInstance(){
		return dbc ;
	}

/*	public static void main(String[] args){
		System.out.println(DBConnection.getInstance().getConnection());
	}*/
}