importdi.java

dgbas公文管理核心java源码

package com.jasson.business.archive;
/**
 * <p>Title: JXML---PRO XML EDITOR</p>
 * <p>Description: pro xml editor</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: www.JEngine.org</p>
 * @author Jarrywen
 * @version 1.0
 */

import java.io.*;
import java.util.*;

import org.xml.sax.*;
import org.xml.sax.helpers.DefaultHandler;
import java.util.List;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


import javax.xml.parsers.SAXParserFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.parsers.SAXParser;
import com.jasson.business.archive.ArchiveCatalogueIF;
import com.jasson.business.common.DbConn;
import com.jasson.business.common.*;
import com.jasson.common.*;


public class ImportDI
    extends DefaultHandler {

    String curName = "";
    String sql = "";
    String s1 = "";
    String s2 = "";
    public ImportDI() {
    	}
    public ImportDI(String FileName) {
    	DefaultHandler handler = new ImportDI();
    	SAXParserFactory factory = SAXParserFactory.newInstance();
        try {
            // Set up output stream
            // Parse the input
            SAXParser saxParser = factory.newSAXParser();
            saxParser.parse(FileName, this);
        }
        catch (Throwable t) {
            t.printStackTrace();
        }
    }
    public boolean RunSql(String sql) {
    		DbConn dbConn = new DbConn();
        	Connection con = dbConn.getConnection();
        	PreparedStatement preparedStatement = null;
        	ResultSet rs = null;
        	boolean aa=false;
        	try {
            		
		        preparedStatement = con.prepareStatement(sql);
		        System.out.println(sql);
		        aa= preparedStatement.executeUpdate()==1;
            		/*
            		while(rs.next())
            		{
            	}
            	*/
            	
            	
            	}
        	 catch (SQLException se) {
            			System.out.println(se.getMessage());
            		
        	}
        finally {
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (con != null) {
                    con.close();
                }
            }
            catch (SQLException se) {
                System.out.println(se.getMessage());
                return false;
                
            }
        }
        return aa;
      }      			
            			
    //ゅ郎秨﹍
    public void startDocument() throws SAXException {
        emit("秨﹍");
        nl();
    }

    //ゅ郎挡