/*
 * Created on 2004-8-9
 * 
 * TODO To change the template for this generated file go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
package com.sanshang.jdbc;

/*
 * Copyright 2003 Sun Microsystems, Inc. ALL RIGHTS RESERVED. Use of this
 * software is authorized pursuant to the terms of the license found at
 * http://developer.java.sun.com/berkeley_license.html.
 */

import java.sql.*;

public class UsePreparedStatement {

	public static void main(String args[]) {
		Connection con = null;
		PreparedStatement stmt;
		String query = "select * from user where Name = ?";

		try {
			// step 1 load driver
			Class.forName(DBInfo.driver);

		} catch (java.lang.ClassNotFoundException e) {
			e.printStackTrace();
		}

		try {
			// step 2 get connection
			con = DriverManager.getConnection(DBInfo.dbURI, DBInfo.user,
					DBInfo.password);
			// step 3 create statement
			stmt = con.prepareStatement(query);
			// set parameter
			stmt.setString(1,"wang");
			// step 4 execute query
			ResultSet rs = stmt.executeQuery();
			// step 5 Process the results
			System.out.println("ID   Name");
			while (rs.next()) {
				System.out.println(rs.getString("ID") + "   "
						+ rs.getString("Name"));
			}
			stmt.close();

		} catch (SQLException ex) {
			ex.printStackTrace();
		} finally {
			try {
				if (con != null) {
					// step 6 close connection
					con.close();
				}
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}
	}
}