java2db.java

工厂版本管理系统,STRUTS2框架,用于管理商品的版本,便于有效的控制版本

package com.dingl.jdbc;

import java.io.UnsupportedEncodingException;
import java.sql.SQLException;
import java.util.Properties;

public class Java2Db {

	/**
	 * 处理字符的编码问题
	 */
	public static String convert2Java(String arg0, Properties param)
			throws SQLException {
		if (param.getProperty("charset") == null || arg0 == null) {
			return arg0;
		} else {
			String value = arg0;
			try {
				value = new String(arg0.getBytes(param
						.getProperty("os-charset")), param
						.getProperty("charset"));
			} catch (UnsupportedEncodingException e) {
				throw new SQLException("unknown charset ："
						+ param.getProperty("charset"));
			}
			return value;
		}
	}

	public static String convert2db(String arg0, Properties param)
			throws SQLException {
		if (param.getProperty("charset") == null || arg0 == null) {
			return arg0;
		} else {
			String value = arg0;
			String osCharset = param.getProperty("os-charset") == null ? "iso8859-1"
					: param.getProperty("os-charset");

			try {
				value = new String(arg0.getBytes(param.getProperty("charset")),
						osCharset);
			} catch (UnsupportedEncodingException e) {
				throw new SQLException("unknown charset ："
						+ param.getProperty("charset"));
			}
			return value;
		}
	}
}