ComposeName/src/qh/lqg/test/TestJdbc.java

package qh.lqg.test;

import java.io.UnsupportedEncodingException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import qh.lqg.utils.Messages;
import qh.lqg.utils.db.JdbcUtils;

public class TestJdbc {

	public static void main(String[] args) throws SQLException,
			UnsupportedEncodingException {
		// TODO 自动生成的方法存根
		String userName, password, url;
		userName = Messages.getString("TestJdbc.userName"); //$NON-NLS-1$
		password = Messages.getString("TestJdbc.password"); //$NON-NLS-1$
		url = Messages.getString("TestJdbc.url"); //$NON-NLS-1$
		JdbcUtils jdbcUtils = new JdbcUtils();
		jdbcUtils.setConnstr(userName, password, url);
		jdbcUtils.getConnection();// 连接数据库
		String sql = "UPDATE `tw_domain` SET  `description`=?, `chinese_description`=? WHERE (`domain_name`='baba.me')"; //$NON-NLS-1$
		List<Object> params = new ArrayList<Object>();
		params.add("90"); //$NON-NLS-1$
		String str = "中文"; //$NON-NLS-1$
		str = new String(str.getBytes(), "UTF8"); //$NON-NLS-1$
		params.add("中文"); //$NON-NLS-1$
		jdbcUtils.updateByPreparedStatement(sql, params);
		System.out.println(sql);
	}

}