dbforjdbcsqlcls.java

jdbc单连接样例程序

package DbJdbc;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */




import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.Hashtable;
import java.util.Vector;
import javax.swing.JTable;



/**
 *
 * @author Administrator
 */
 public class DBForJdbcSqlCls {
    public static final int jdbcJtdsSqlServer2000sp4=1; 
    public static final int jdbcOdbcBridge=2; 
    public static final int jdbcSqlServer2000sp4=3; 
            
    protected String DbAccount="";
    protected String DbPassWord="";
    protected String Url ="";// "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CallCenter";
    public String DbDriverName="";//com.microsoft.jdbc.sqlserver.SQLServerDriver";
    
    protected CallableStatement CallState1;
    protected ResultSet DataSet;
    
    protected Statement State1;
    
    protected Connection con1;
    
    private Vector CallStateVector;
    
//    private static InitialContext ctx;
//    private static  DataSource ds = null;

    /****************************************************
     * 鍔熻兘锛氳