新人刚刚接触JSP和ORACLE,给大家添麻烦了.
下面是连接数据库的JSP代码,测试后已经可以成功连接到ORACLE9I.
如果想要在浏览器中显示,我选择的字段或scott用户下emp表的全部内容.应该怎么写代码呢?
这是ORACLE9I自带的一个表,表内数据不多,请前辈帮写两句,多谢了.<%@ page language="java" import="java.io.*, java.sql.*, javax.sql.*"%>
<%@ page import="oracle.jdbc.*, oracle.sql.* "%>
<%
// Connect to the database
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:myoracle";
String user="scott";
String password="zong0716";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement ();
ResultSet rs =
stmt.executeQuery("SELECT empno(或者这里写*,选择全部字段) FROM scott.emp" );
if (rs.next()) {
下面不会写了:(
}
// Close input and output streams
is.close();
os.close();
conn.close();
%>
下面是连接数据库的JSP代码,测试后已经可以成功连接到ORACLE9I.
如果想要在浏览器中显示,我选择的字段或scott用户下emp表的全部内容.应该怎么写代码呢?
这是ORACLE9I自带的一个表,表内数据不多,请前辈帮写两句,多谢了.<%@ page language="java" import="java.io.*, java.sql.*, javax.sql.*"%>
<%@ page import="oracle.jdbc.*, oracle.sql.* "%>
<%
// Connect to the database
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:myoracle";
String user="scott";
String password="zong0716";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement ();
ResultSet rs =
stmt.executeQuery("SELECT empno(或者这里写*,选择全部字段) FROM scott.emp" );
if (rs.next()) {
下面不会写了:(
}
// Close input and output streams
is.close();
os.close();
conn.close();
%>
下面不会写了:(
%>
<%=rs.getString(1);%>||<%=rs.getString(2);%>
<%
}
ResultSet rs =
stmt.executeQuery("SELECT empno(或者这里写*,选择全部字段) FROM scott.emp" );
out.println("<table>");
while(rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString("第一个字段名") + "</td>");
out.println("<td>" + rs.getString("第二个字段名") + "</td>");
... out.println("<td>" + rs.getString("第N个字段名") + "</td>");
out.println("</tr>");
}
out.println("</table>");