prepareStatement

注意我用了prest.setObject(1, "house");

import java.sql.*;

public class TwicePreparedStatement {
	public static void main(String[] args) {
		System.out.println("Twice use prepared statement example!\n");
		Connection con = null;
		PreparedStatement prest;
		String temp="";
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/db_cityinfo", "root", "HuaDi5");
			try {
				String sql = "SELECT * FROM tb_type WHERE type_name = ?";
				prest = con.prepareStatement(sql);
				prest.setString(1, "tutor");
				ResultSet rs1 = prest.executeQuery();
				System.out.println("家教信息");
				while (rs1.next()) {
					String mov_name = rs1.getString(1);
					temp=rs1.getString("type_intro");
					temp=new String(temp.getBytes("iso-8859-1"),"gbk");
					String mad_year = rs1.getString("type_intro");
					System.out.println(mov_name + "\t- " + temp);
				}
				prest.setObject(1, "house");
				ResultSet rs2 = prest.executeQuery();
				System.out.println("房产信息");
				while (rs2.next()) {
					temp=rs2.getString("type_intro");
					temp=new String(temp.getBytes("iso-8859-1"),"gbk");
					int mad_year = rs2.getInt(2);
					System.out.println(temp + "\t- " + mad_year);
				}
			} catch (SQLException s) {
				System.out.println("SQL statement is not executed!");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

本例所用数据库和表见： http://blog.csdn.net/weiyanghuadi/article/details/8898258