Demo of MySQL for Java

Java使用MySQL的Demo
1.首先将mysql-connector-java-5.1.10-bin.jar包加进开发工具的build path 中
2.运行以下程序，进行Demo测试

package bill.com;

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

public class TestConnectDB {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String user = "root";
		String password = "xxx";
		String url = "jdbc:mysql://localhost:3306/test";
		String driver = "com.mysql.jdbc.Driver";
		String sqlstr;
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			Class.forName(driver);
			con = DriverManager.getConnection(url, user, password);
			stmt = con.createStatement();        
			sqlstr = "select name from pet";
			rs = stmt.executeQuery(sqlstr);
			while(rs.next()) {
				String name = rs.getString(1);
				System.out.println("Name :" + name);
			}
			stmt.close();
			con.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}