Jdbc connect mysql初识 示例1

工具：MyEclipse，MySql5.5

首先需要将

mysql-connector-java-5.*.*-bin.jar

添加到MyEclipse中

确保存在连接驱动。

然后新建一个普通APP工程，并新建Base.java,如下代码。

/**
 * Create Date:2013-6-24
 * Author : Dzj
 * E-mail : 625065470@qq.com
 */
package cn.dzj.demo.jdbc;

import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;

/**
 * Summary : Test jdbc to mysql (1)
 */
public class Base {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		try {
			test();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static void test() throws SQLException
	{
		//register
		//DriverManager.registerDriver(new com.mysql.jdbc.Driver()); //just so so
		//System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver"); //better
		Class.forName("com.mysql.jdbc.Driver"); //best
		
		//build connection
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/PIMS","root","123456");
	
		//create statement
		Statement st = conn.createStatement();
		
		//execute sql sentense
		ResultSet rs =  st.executeQuery("select * from persons");
		
		//output result
		while(rs.next())
		{
			System.out.println("First column: "+rs.getObject(1)+";Second column:"+rs.getObject(2));
		}
		
		//close resource
		rs.close();
		st.close();
		conn.close();
	}
}

结果如下：