dbutil.java

Light in the box 抓取程序。 使用HttpClient

package com.blogool.export;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DBUtil {
	public static java.sql.Connection getConnection() {
		String jdbcUrl = "jdbc:mysql://www.busmate.com/etrade?useUnicode=true&characterEncoding=utf-8";
		String username = "etrade";
		String password = "etrade";
		try {
			Class.forName("org.gjt.mm.mysql.Driver").newInstance();
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		java.sql.Connection conn = null;
		try {
			conn = DriverManager.getConnection(jdbcUrl, username, password);
			conn.setAutoCommit(true);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}

		return conn;

	}
	
	public static void update(Connection conn, String sql, Object[] params) {
		PreparedStatement pstmt = null;
		
		try {

			pstmt = conn.prepareStatement(sql);
			if (params != null) {
				for (int i = 0; i < params.length; i ++)
					pstmt.setObject(i + 1, params[i]);
			}
				
			
			pstmt.executeUpdate();
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			try {
				if (pstmt != null) {
					pstmt.close();
				}

			} catch (SQLException ex1) {

			}
		}
	}
}