jdbc

hello world

import java.sql.*;

public class HelloWorldApp {
	
	public static void main(String[] args){
		System.out.println("hello");
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://127.0.0.1:3306/mysql";
		String user = "root";
		String password = "123456";//数据库用户的密码
		try{	
			try{
				Class.forName(driver);				
			}catch(ClassNotFoundException e){
				e.printStackTrace();
			}
			
			Connection conn = DriverManager.getConnection(url,user,password);
			if(!conn.isClosed()){
				System.out.println("success!");
			}

			Statement statement = conn.createStatement();
			String sql = "select * from user";
			
			ResultSet rs = statement.executeQuery(sql);
			String name = null;
			
			while(rs.next()){
				name = rs.getString("User");
				System.out.println(name);
			}
			
			rs.close();
			conn.close();
			
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}

}

执行成功，会打印出Mysql中的mysql数据库的user table的User列表。