<%
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/fire_emblem","root",""); ;
int i = 1;
String characters[] = new String[71];
try {
	Statement st= con.createStatement();
	ResultSet rs = st.executeQuery("select name from characters");
	while (rs.next()) {
		characters[i] = rs.getString("name");
		i++;
	}
}
catch (SQLException e) {
		System.out.println(e.getMessage());
}

%>