|
|
|
Помогите разобраться
|
|||
|---|---|---|---|
|
#18+
этот примерчик я взял с интернета вызываю http://hp530:8080/sample/StaffByJSPDirect.jsp не отвечает!!! Оракл 10 -ка, на локальном компе,порт 1521! Нормально соединяюсь через Sqlplus <%@ page import="java.sql.*" %> <html> <head><title>Direct JDBC Query JSP</title></head> <body> <h3>JSP StaffByJSPDirect result:</h3> <pre> <%= StaffByJSPDirect() %> </pre> <hr> </body> </html> <%! private String StaffByJSPDirect() throws SQLException { Connection cn = null; StringBuffer sb = new StringBuffer(); try { cn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:myfcc", "scott", "tiger"); } catch (SQLException e) { }; Statement st = null; ResultSet rs = null; try { st = cn.createStatement(); rs = st.executeQuery("SELECT empno, ename FROM emp"); while (rs.next()) { sb.append("Number=" + rs.getString(1) + " " + "Name=" + rs.getString(2) + "\n"); }; cn.close(); } catch (SQLException e) { }; return sb.toString(); } %> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.09.2008, 10:51 |
|
||
|
|
start [/forum/topic.php?desktop=1&fid=22&tid=1455926]: |
0ms |
get settings: |
6ms |
get forum list: |
12ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
30ms |
get topic data: |
6ms |
get forum data: |
2ms |
get page messages: |
15ms |
get tp. blocked users: |
1ms |
| others: | 226ms |
| total: | 302ms |
| 0 / 0 |
