| |
<%
Connection connection = null;
String artType = null;
String category = null;
/*
* Load database records.
*/
try
{
connection = openConnection();
Statement statement = connection.createStatement();
// AP053008 Removed unwelcome=0 from where. Reason: some artists don't want to be in
// our artist listings, yet we need at least one place referring to their account.
if (statement.execute("SELECT id, firstName, lastName, login, package, portfolio FROM galleryArtist WHERE activeflag='Y' AND package>0 ORDER BY lastName"))
{
ResultSet resultSet = statement.getResultSet();
while (resultSet.next())
{
String portfolio = resultSet.getString("portfolio");
String artist=resultSet.getString("id");
String lastname=resultSet.getString("lastName");
String firstname=resultSet.getString("firstName");
if (resultSet.getString("firstName")==null || "".equals(resultSet.getString("firstName")))
{
firstname = "";
}
String login=resultSet.getString("login");
int pack=resultSet.getInt("package");
String query = null;
Statement statement1=connection.createStatement();
int i=0;
query = "SELECT type,category FROM galleryArtwork WHERE artist=" + artist;
if (statement1.execute(query))
{
ResultSet resultSet1 = statement1.getResultSet();
while (resultSet1.next()&&(i==0))
{
category = resultSet1.getString("category");
artType = resultSet1.getString("type");
i++;
}
resultSet1.close();
}
else
{
//TODO
}
String uryl="artworks.jsp?artist="+artist;
String urylConverted = getURLFilename(uryl, "shtml", null);
if (pack == 0 || pack == 1 || pack == 5 || pack == 2 || pack == 3){ // Showroom or OpenStudio
//urylConverted = substituteTokens(firstname.substring(0,Math.min(1,firstname.length())).toLowerCase() + lastname.toLowerCase()," ","");
//substituteTokens(firstName.substring(0,1).toLowerCase() + lastName.toLowerCase()," ","");
//urylConverted = login+ ".jsp";
urylConverted = portfolio;
}
out.print("| "
//+ firstname + " "
//+ lastname
+ " | "
+ ""
+ firstname + " "
+ lastname
+ "
|
");
}
resultSet.close();
}
else
{
//TODO
}
}
catch(Exception e)
{
//TODO
}
finally
{
if (connection != null && !connection.isClosed()) connection.close();
}
%>
 |
SELL ART.
ART INVEST.
INVEST IN ART.
ART INVESTMENT.
INVESTMENT ART.
INVESTING IN ART.
|
|
|
<%@ include file="inc/bottom.txt" %>
<%@ include file="cacheEnd.jsp" %>
<%@ include file="globalFinally.jsp" %>