import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;


public class TestSelect {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/jdbcTest?user=root&zeroDateTimeBehavior=convertToNull");
			PreparedStatement stmt = connection.prepareStatement("SELECT us_id, us_loginname, us_password FROM users WHERE delmark = 0 AND us_loginname = ? AND us_password = ?");
			stmt.setString(1,"beso");
			stmt.setString(2,"beso");
			
			if(stmt.executeQuery().next()) {
				System.err.println("Found item");
			} else {
				System.err.println("Not Found item");
			}
			
			Statement stmt2 = connection.createStatement();
			ResultSet set = stmt2.executeQuery("SELECT us_id, us_loginname, us_password FROM users WHERE delmark = 0 AND us_loginname = 'beso' AND us_password = 'beso'");
			
			if(set.next()) {
				System.err.println("Found item");
			} else {
				System.err.println("Not Found item");
			}
			
		} catch( Exception e ) {
			e.printStackTrace();
		}
	}

}