connectdb.java

excel打印模板,支持单表,主从关系表格,利用xml格式的office文档特点

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company:倚天软件 </p>
 *
 * @author 丁锋
 * @version 1.0
 */



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

public class connectDB {
    Connection conn = null;
    Statement stmt = null;
    public connectDB() throws SQLException {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").
                    newInstance();

        } catch (ClassNotFoundException ex1) {
        } catch (IllegalAccessException ex1) {
        } catch (InstantiationException ex1) {
        }

        String url =
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";

//pubs为你的数据库的

        String user = "sa";

        String password = "";

        conn = DriverManager.getConnection(url, user, password);

        stmt = conn.createStatement(ResultSet.
                                    TYPE_SCROLL_SENSITIVE,
                                    ResultSet.CONCUR_UPDATABLE);

    }

    public ResultSet getResultSet(String sql) {
        ResultSet rs = null;
        try {
            rs = stmt.executeQuery(sql);
        } catch (SQLException ex) {
        }
        return rs;

    }
    public void close(){

            try {
                stmt.close();
            } catch (SQLException ex) {
            }
        try {
            conn.close();
        } catch (SQLException ex1) {
        }

    }
}