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

import javax.sql.DataSource;



public class TestStatement {

	public static void main(String[] args) {
		
		try {
			final Connection connection = DriverManager.getConnection("jdbc:mysql://192.168.1.200/sugarcrm", "root", "vir1324web");
			
			
			Statement s = connection.createStatement(); 
			ResultSet rs = s.executeQuery("select * from sugarcrm.accounts where name like '%a%'" );
			
			while (rs.next()) {
				System.out.println(rs.getString("name"));
			}

		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

}