PDA

View Full Version : مشکل با اتصال به دیتابیس در JSP



akoori
یک شنبه 27 فروردین 1391, 18:11 عصر
فایل زیر باید تمام دیتابیس ها رو نشون بده اما یه ارور میده :

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.* " %>
<%@ page import="java.io.*" %>
<%
try {
String driver = "org.postgresql.Driver";
String url = "jdbc:postgresql://10.10.10.10:4444/admin";
String username = "admin";
String password = "admin";
String myDataField = null;
String myQuery = "select datname from pg_database;";
Connection myConnection = null;
PreparedStatement myPreparedStatement = null;
ResultSet myResultSet = null;
Class.forName(driver).newInstance();
myConnection = DriverManager.getConnection(url,username,password) ;
myPreparedStatement = myConnection.prepareStatement(myQuery);
myResultSet = myPreparedStatement.executeQuery();
if(myResultSet.next())
myDataField = myResultSet.getString("dispname");
out.print(myDataField);
}
catch(ClassNotFoundException e){e.printStackTrace();}
catch (SQLException ex)
{
out.print("SQLException: "+ex.getMessage());
out.print("SQLState: " + ex.getSQLState());
out.print("VendorError: " + ex.getErrorCode());
}
%>

ارورش اینه :

SQLException: The column name dispname was not found in this ResultSet.SQLState: 42703VendorError: 0

مشکل از کجاست؟