JDBC简单例子(MySQL)

package database;


import java.sql.*;


public class sqlreview {


	public static void main(String[] args) {
		// Driver and URL
		final String JDBC_DRIVER = "com.mysql.jdbc.driver";
		final String DB_URL = "jdbc:mysql://localhost:3306/bank";
		// User name and password
		final String username = "root";
		final String password = "xeon5300";
		// Connection and Statement
		Connection conn = null;
		Statement stm = null;
		// Open a connection
		System.out.println("Opening a DB connection...");
		try {
			conn = DriverManager.getConnection(DB_URL, username, password);
		} catch (SQLException e) {


			e.printStackTrace();
		}
		// Execute query statement
		final String sql = "select * from admin";
		System.out.println("Executing Query...");
		try {
			ResultSet rs = conn.prepareStatement(sql).executeQuery();
			// Extract data from Result Set
			while (rs.next()) {
				int id = rs.getInt(1);
				String Username = rs.getString(2);
				String Password = rs.getString(3);
				System.out.println("ID: " + id);
				System.out.println("User Name: " + Username);
				System.out.println("Password: " + Password);
				System.out.println("----------------");


			}
			// Close ResultSet, Connection,Statement


			rs.close();
			conn.close();
		} catch (SQLException e) {


			e.printStackTrace();
		}
		System.out.println("Goodbye!");
	}


}