sqlutils.java

一套大型Office网络办公系统

/**
* Copyright (c) 2002 CORPCN.com
* All right reserved.
*
* Description: ....
*
* Author: Chu Daping 2002-6-17 13:36
*
*/

package com.corpcn.utils;

import com.corpcn.www.*;

import javax.xml.parsers.*;
import java.sql.*;
import java.util.*;
import java.io.*;


public class SqlUtils {
	
	public static long getOS() {
		long OSsymbol = -1;
		try {
			SAXParserFactory saxpFactory = SAXParserFactory.newInstance();
			SAXParser saxpser = saxpFactory.newSAXParser();
			MyHandler handler = new MyHandler();
			saxpser.parse("properties.xml", handler);
			Hashtable hshTable = handler.getTable();
			Object obj = "os";
			OSsymbol = Long.parseLong((String)hshTable.get(obj));
		} catch (Exception e) {}
		return OSsymbol;
	}
	
	public static long getDB() {
		return -1;
	}
	
	public static void setString(PreparedStatement pst,
                                 int paraIndex, String args)
    {
	    if ((args == null)||(args.equals("")))
	    {
	      System.err.println("Your Chinese is null String!!");
	      System.err.println("please use PreparedStatement.setString(int, String)");
	    }
	    if (SqlUtils.getOS()==1)
        {
		    try {
				pst.setString(paraIndex, args);
		    } catch(Exception e){
				e.printStackTrace();
		    }
		}
		else if (SqlUtils.getOS()==2)
		{
		    try {
				byte buf[] = args.getBytes("GBK");
				String s1 = new String(buf, "ISO-8859-1");
				pst.setString(paraIndex, s1);
				System.out.println("String converted!");
		    } catch(Exception e) {
				e.printStackTrace();
		    }
        }
    }
    
    public static String getString(ResultSet rs, int paraIndex)
    {
	    if (SqlUtils.getOS()==1)
        {
		    try {
				String geted = rs.getString(paraIndex);
				return geted;
		    } catch(Exception e){
				e.printStackTrace();
		    }
		}
		else if (SqlUtils.getOS()==2)
		{
		    try {
		    	String s1 = rs.getString(paraIndex);
				byte buf[] = s1.getBytes("ISO-8859-1");
		        return (new String(buf, "GBK"));
		    } catch(Exception e){
		    	e.printStackTrace();
		    }
		}
	    return null;
    }
    
    public static String getString(ResultSet rs, String paraString)
    {
	    if (SqlUtils.getOS()==1)
        {
		    try {
				String geted = rs.getString(paraString);
				return geted;
		    } catch(Exception e){
				e.printStackTrace();
		    }
		}
		else if (SqlUtils.getOS()==2)
		{
		    try {
		     	String s1 = rs.getString(paraString);
				byte buf[] = s1.getBytes("ISO-8859-1");
		        return (new String(buf, "GBK"));
		    } catch(Exception e){
		    	e.printStackTrace();
		    }
		}
	    return null;
    }


}