Retrieving data from jdbc
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql//localhost/mydatabase","user","pass");
PreparedStatement stmt = conn.prepareStatement("SELECT (NAME) FROM stocks1 WHERE FULLNAME =?");
for(int i1=0;i1<i;i1++)
{
  stmt.setString(1, name[i1]);


  stmt.addBatch();
}
ResultSet t=stmt.executeQuery();
while(t.next())
  System.out.println(t.getString("NAME"));

Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql//localhost/mydatabase","user","pass");
PreparedStatement stmt = conn.prepareStatement("SELECT NAME FROM stocks1 WHERE FULLNAME is in (SELECT FULLNAME FROM arraystocks)");
ResultSet t=stmt.executeQuery();
while(t.next()) {
    System.out.println(t.getString("NAME"));
}

PreparedStatement stmt = conn.prepareStatement("SELECT (NAME) FROM stocks1 WHERE FULLNAME LIKE ?");

ps.setString(1, name[i1]+ "%");

SELECT (NAME) FROM stocks1 WHERE upper(FULLNAME) LIKE ?

ps.setString(1, upper(name[i1])+ "%");