dbconnection.java

利用jsp

/*
 * Created on 2008-2-27
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ibm.j2ee.zhanjiang.bean;
/*
public class DBConnection {

}
*/

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * @author J2EE
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class DBConnection {

	/**
	 * 
	 */
	public DBConnection() {
		super();
		// TODO Auto-generated constructor stub
	}
	public void DBConnect(){
		
		try {
				Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
				conn = DriverManager.getConnection(
									"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zjTravel",
									"sa",
									"sa");
//			Class.forName("net.sourceforge.jtds.jdbc.Driver"); 
//			conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/zjTravel","sa","sa");
//			Connection conn = DriverManager.getConnection("jdbc:odbc:zjTravel", "sa", 
//			"sa"); 
			}catch( Exception e ){
				e.printStackTrace();
			}
	}
	
	public Connection getConnection(){
		return conn;
	}

	public void ConnectionClosed(){
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}
	
	public void ConnectionCommit(){
			try {
				conn.commit();
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}

	private Connection conn;
}