java数据库封装类,Java 连接数据库、执行SQL封装类

/*当执行SQL时发现不能连接数据库，先重连一次*/

import java.io.FileInputStream;

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Date;

import java.util.TimerTask;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.ImageIcon;

import javax.swing.JOptionPane;

class SQL_OPERATION_TRAN {

//private Connection cn;

private PreparedStatement pst;

private ResultSet rs;

private boolean isAutoCommit=true;

private CallableStatement proc;

java.util.Timer tmReceive;

//int counter=0;

Main gbl_Main;

SQL_OPERATION_TRAN(Main main){

//cn=connection;

gbl_Main=main;

//this.CheckConnect();

// this.Connect();

}

public void Connect(){

//gbl_Main.cn=gbl_Main.con.getConnection();

String name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

String url = "jdbc:microsoft:sqlserver://10.10.10.10:1433;DatabaseName=aa";

String username = "bb";

String password = "cc";

try {

Class.forName(name);

try {

gbl_Main.cnTran = DriverManager.getConnection(url, username, password);

//DriverManager.setLoginTimeout(30000);

gbl_Main.gbl_ErrorCounter = 0;

gbl_Main.gbl_TryCounter = 0;

System.out.println("Connect="+gbl_Main.gbl_ErrorCounter);

} catch (SQLException ex) {

gbl_Main.gbl_ErrorCounter++;

Logger.getLogger(SQL_OPERATION.class.getName()).log(Level.SEVERE, null, ex);

}

} catch (ClassNotFoundException ex) {

Logger.getLogger(SQL_OPERATION.class.getName()).log(Leve