test_jdbc.java

总结用JDBC连接mysql数据库的程序样例

package com.JDBC;

import java.sql.*; 


public class test_JDBC {

	/**
	 * @param args
	 */

	public static void main(String[] args) {
		Connection conn = null ;
		ResultSet rs = null ;
		Statement stmt = null ;
		String url = "jdbc:mysql://localhost/mydata" ;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(url,"root","dinglinbin") ;
			stmt = conn.createStatement() ;
			//stmt = conn.createStatement("select * from dept") ;
			rs = stmt.executeQuery("select * from dept") ;
			while(rs.next()){
				System.out.println(rs.getString("deptno")) ;
			}
			

		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}catch(SQLException e){
			e.printStackTrace() ;
		}finally {
			try {
			if(rs != null){
					rs.close() ;
					rs = null ;
				} 
			if(stmt != null ){
				stmt.close();
				stmt = null ;
			}
			if(conn != null ){
				conn.close();
				conn = null ;
			}
			}
			catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}



		}
		

	}

}