jdbc for mysql demo

package com.huawei.mysql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class MySqlTest {public static void main(String[] args) throws SQLException {Connection conn = null;PreparedStatement stmt = null;ResultSet rs = null;try {            Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root","123");stmt = conn.prepareStatement("select * from person where id=?");stmt.setInt(1, 10);rs = stmt.executeQuery();while (rs.next()) {System.out.println(rs.getInt("id"));System.out.println(rs.getString("name"));System.out.println("----------------------------");}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {if (rs != null)rs.close();if (stmt != null)stmt.close();if (conn != null)conn.close();}}}