databaseopr.java

主要介绍客户端ajax技术的应用,主要绍了服务器与客户端的交互过程,是ajax开发的好帮手

package dataaccess.dbtool;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DataBaseOpr {
	
	public Connection createConnection(){
		Connection conn=null;
		try{
		String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
		Class.forName(driver);
		conn = DriverManager.getConnection(url, "sa", "");//建立连线
		conn.setAutoCommit(false);
		return conn;
		}
		catch(SQLException ex1){
		System.out.println("建立连线錯誤="+ex1.toString());
		}
		catch (ClassNotFoundException ex2){
		System.out.println("建立连线錯誤="+ex2.toString());
		}
		return null;
		}
	//关闭连接
	public void CloseConnect(Connection conn){
		try{
		conn.commit();
		conn.setAutoCommit(true);
		conn.close();
		}
		catch(Exception e){
		System.out.println("连线关闭错误="+e.toString());
		}
		}

}