oracle的jdbc语句,Java Oracle jdbc SELECT语句

我在

Eclipse环境中使用java练习Oracle JDBC.我理解如何通过使用next()迭代每一行表来从产品输出SELECT *.我是在耍弄

输出语句

SELECT pid, pname

from product

where price>20

这是我的代码:

import java.sql.*;

public class intro {

/**

* @param args

*/

public static void main(String[] args)

{

// throws SQLException

//initiazlie the connection

Connection con=null;

try //try connection to database

{

//load driver

Class.forName("oracle.jdbc.OracleDriver");

System.out.println("Oracle JDBC driver loaded ok.");

con=DriverManager.getConnection("jdbc:oracle:thin:test/123321@localhost:1521:orcl");

System.out.println("Connect with @oracle:1521:orcl");

//declaring statement

Statement stmt = con.createStatement();

String dropProductTable="drop table product cascade constraints";

//create string

String createProductTable="CREATE TABLE product(" +

"pid number," +

"pname CHAR(20)," +

"price number," +

"PRIMARY KEY (pid)" +

")"; //do not add the semicolon(;) after closing the parenthesis.

/*drop table */

stmt.executeUpdate(dropProductTable);

//execute the create statement

stmt.executeUpdate(createProductTable);//execure the create statement

//create string that holds the insert statement

String insertIntoProduct="INSERT INTO product VALUES (1,'Pepsi',10)";

String insertIntoProduct1="INSERT INTO product VALUES (2,'Fanta',20)";

String insertIntoProduct2="INSERT INTO product VALUES (3,'Mirinda',30)";

String insertIntoProduct3="INSERT INTO product VALUES (4,'Gum',5)";

String updatePrice="UPDATE product set price=55 where price=20";

//stmt.executeUpdate(insertIntoProduct);

stmt.executeUpdate(insertIntoProduct);

stmt.executeUpdate(insertIntoProduct1);

stmt.executeUpdate(insertIntoProduct2);

stmt.executeUpdate(insertIntoProduct3);

//update statement

stmt.executeUpdate(updatePrice);

//save the select statement in a string

String selectStat="SELECT * FROM product";

String selectProduct="SELECT pid, pname from product where price>20";

//stmt.executeUpdate(selectStat);

//create a result set

ResultSet rows = stmt.executeQuery(selectStat);

ResultSet rows1= stmt.executeQuery(selectProduct);

//stmt.executeQuery(selectStat);

int count=0;

while (rows.next()) {

count+=1;

String productNumber = rows.getString("pid");

String productName = rows.getString("pname");

String productPrice = rows.getString("price");

System.out.println("Row #:"+count);

System.out.println("Product#: "+productNumber);

System.out.println("Product Name: "+productName);

System.out.println("Price: "+productPrice);

}

int count1=0;

while (rows1.next()) {

count1+=1;

String productNumber = rows1.getString("pid");

String productName = rows1.getString("pname");

String productPrice = rows1.getString("price");

System.out.println("Row #:"+count);

System.out.println("Product#: "+productNumber);

System.out.println("Product Name: "+productName);

System.out.println("Price: "+productPrice);

}

con.close();

}

catch (Exception e)

{

System.err.println("Exception:"+e.getMessage());

}

}

}

当我试图输出selectProduct变量时,我得到了这个错误

Exception:Invalid column name

请需要帮助

这是我得到的输出

Oracle JDBC driver loaded ok.

Connect with @oracle:1521:orcl

Row #:0

Product#: 2

Product Name: Fanta

Price: 55

Row #:0

Product#: 3

Product Name: Mirinda

Price: 30

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值