select.java

来自「这是用java进行数据库操作的全部源代码 可以帮助大家更明确的学习利用java」· Java 代码 · 共 89 行

import java.sql.* ;
import java.util.* ;

class User
{
	private String mName ;
	private String mPhone ;
	
	public User( String name, String phone )
	{
		mName = name ;
		mPhone = phone ;
	}
	
	public String getName( ) 
	{ 
		return mName ; 
	}
	public String getPhone( ) 
	{ 
		return mPhone ; 
	}
	public void setName( String name ) 
	{ 
		mName = name ; 
	}
	public void setPhone( String phone ) 
	{ 
		mPhone = phone ; 
	}
}

class Select
{
	public static void main( String [] args )
	{
		try
		{
			Class.forName( "com.mysql.jdbc.Driver" ) ;
		}
		catch ( ClassNotFoundException classNotFound )
		{
			System.out.println( "ERR: load driver." ) ;
			return ;
		}
		
		try
		{
			Connection connection = DriverManager.getConnection(
				"jdbc:mysql://127.0.0.1/Hello"
					+ "?useUnicode=true&characterEncoding=utf8",
				"root",
				""
			) ;
			
			Statement statement = connection.createStatement( ) ;
			
			ResultSet resultSet = statement.executeQuery(
				"SELECT phone, name FROM User"
			) ;
			
			ArrayList userList = new ArrayList( ) ;
			while ( resultSet.next( ) )
			{
				String phone = resultSet.getString( 1 ) ;
				String name = resultSet.getString( 2 ) ;
				
				userList.add( new User( name, phone ) ) ;
			}
			
			statement.close( ) ;
			
                	connection.close( ) ;
			
			for ( int i = 0 ; i < userList.size( ) ; i++ )
			{
				User user = (User)userList.get( i ) ;
				System.out.println(
					"User: " + user.getName( ) + " | "
					+ user.getPhone( ) ) ;
			}
		}
		catch ( SQLException sql )
		{
			System.out.println( "ERR: select." ) ;
		}
	}
}