UC知道jdbc连接oracle后查询结果
来源：百度知道 编辑：UC知道 时间：2024/05/19 18:03:30
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%--
使用JDBC连接Oracle数据库
使用MLDN数据库
用户名：scott
密码：tiger
--%>
<%!String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
String DBURL = "jdbc:oracle:thin:@localhost:1521:java";
String DBUSER = "system";
String DBPASSWORD = "java";
Connection conn = null;
PreparedStatement stmt = null;
String s = null ;
ResultSet rs = null;%>
<%
try
{
Class.forName(DBDRIVER) ;
// 连接时必须填写用户名及密码
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
// 创建表的SQL语句
String sql = "select * from sqn" ;
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while(rs.next()){
s = s + " " + rs.getString(1)
<%@ page import="java.sql.*"%>
<%--
使用JDBC连接Oracle数据库
使用MLDN数据库
用户名：scott
密码：tiger
--%>
<%!String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
String DBURL = "jdbc:oracle:thin:@localhost:1521:java";
String DBUSER = "system";
String DBPASSWORD = "java";
Connection conn = null;
PreparedStatement stmt = null;
String s = null ;
ResultSet rs = null;%>
<%
try
{
Class.forName(DBDRIVER) ;
// 连接时必须填写用户名及密码
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
// 创建表的SQL语句
String sql = "select * from sqn" ;
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while(rs.next()){
s = s + " " + rs.getString(1)
应该不会的,除非你的sqn表里没数据,要么没有这个表,你查出来了也应该只打出一条来,至于打出哪一条,那不一定的,看存储的时候rowid的
System.out.print(s);
放到循环里试试
do{
s = s + " " + rs.getString(1) + " " + rs.getString(2);
或者
s = s + " " + rs.getString(0) + " " + rs.getString(1);
}while(rs.next())