Java 链接 MySql 例子

package jason.com;

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

public class JDBCTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		String driver = "com.mysql.jdbc.Driver";
		String url="jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8";
		String user = "root";
		String password = "root";
		String sql = "";
		
		try{
			Class.forName(driver);
			Connection conn = DriverManager.getConnection(url,user,password);
			if(!conn.isClosed()){
				System.out.println("Succed connecting to database!");
			}
			Statement stmt = conn.createStatement();
			
			sql = " INSERT person(name,age) VALUES('小花',13) ";
			stmt.execute(sql);
			
			sql ="select * from person ";
			ResultSet rs = stmt.executeQuery(sql);
			
			while(rs.next()!=false){
				System.out.println("id:"+rs.getString("id"));
				System.out.println("name:"+rs.getString("name"));
				System.out.println("age:"+rs.getString("age"));
				System.out.println("--------------------------");
			}
			
			if(rs!=null)rs.close();
			if(stmt!=null)stmt.close();
			if(conn!=null)conn.close();
		}catch(Exception e){
			System.out.println(e.toString());
		}

	}

}