為什麼我的資料會顯示為16進制的。
各位高手,我是一JSP新手,當我用從資料庫裡面抓取資料時為什麼當將createStament帶上參數時(代碼如下所示)資料全部會用十六進制顯示出來。如Canning會變成0x43616E6E696E67。該欄位是varchar,資料庫Oracle8.05。敬請各位高手指點,感激不盡。
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn;
String url="jdbc:oracle:thin:@172.18.60.9:1521:mat";
String user="apps";
String password="quota";
conn= DriverManager.getConnection(url,user,password);
String strSQL="select user_id,USER_NAME,FACT_NO from userm where USER_KIND='U' and rownum<=40";
strSQL=strSQL+" minus select user_id,USER_NAME,FACT_NO from userm where USER_KIND='U' and rownum<=30";
//Statement statement = conn.createStatement
//(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
Statement statement = conn.createStatement();
ResultSet rs=statement.executeQuery(strSQL);
while(rs.next())
{
out.println("<tr>");
out.println("<td>"+rs.getString("USER_ID")+"</td>");
out.println("<td>"+rs.getString("USER_NAME")+"</td>");
out.println("<td>"+rs.getString("FACT_NO")+"</td>");
out.println("</tr>");
}
rs.close();
statement.close();
conn.close();
%>