customerlistingds.java

噶额外噶外骨骼感广泛高热感 就 啊啊

package itso.javadb;
import java.sql.*;

/**
 * @author UELI
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */
public class CustomerListingDS {
	static String dbtab = "CUSTOMER";
	
	public static void main(String[] args) {
		System.out.println("Customer Listing for " + dbtab);

		Connection con = null;
		con = connect();

		Statement stmt = null;
		ResultSet rs = null;
		String select = "SELECT * FROM ITSO." + dbtab;
		try {
			stmt = con.createStatement();
			rs = stmt.executeQuery(select);
			while (rs.next()) {
				String firstName = rs.getString("firstName");
				String lastName = rs.getString("lastName");
				String userID = rs.getString("userID");
				System.out.println(firstName + " " + lastName + " " + userID);
			}
			System.out.println("End of Listing");
		} catch (Exception e) {
			System.err.println("Exception: " + e.getMessage());
		} finally {
			try {
				if (rs   != null) rs.close();
				if (stmt != null) stmt.close();
				if (con  != null) con.close();
			} catch (SQLException e) {}
		}
	}
	
	protected static Connection connect() {
		Connection con = null;
		try {
			javax.naming.InitialContext ctx = new javax.naming.InitialContext();
			javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/mybank");
			con = ds.getConnection();
		} catch (javax.naming.NamingException e) {
			System.err.println("Naming-Exception: " + e.getMessage());
		} catch (java.sql.SQLException e) {
			System.err.println("SQL-Exception: " + e.getMessage());
		}
		return con; 
	}
}