对oracle数据库抽取指定条件的数据

发布网友发布时间：2022-04-09 00:14

共2个回答

懂视网时间：2022-04-09 04:35

package qddx.JDBC; 2 import java.sql.*; 3 public class QueryById { 4 5 public bbsVo QuerybbsVoById(int id){ 6 bbsVo vo = null; 7 Connection conn = null; 8 PreparedStatement pst = null; 9 ResultSet rs = null; 10 try{ 11 conn = JDBC_Connection.getConnection(); 12 pst = conn.prepareStatement("select * from article where id=?"); 13 pst.setInt(1, id);//设置条件id 14 rs=pst.executeQuery(); 15 while(rs.next()){//结果集存在则进行遍历 16 vo = new bbsVo(); 17 vo.setId(rs.getInt("id")); 18 vo.setPid(rs.getInt("pid")); 19 vo.setRootid(rs.getInt("rootid")); 20 vo.setCont(rs.getString("cont")); 21 vo.setPdate(rs.getTimestamp("pdate")); 22 vo.setIsleaf(rs.getInt("isleaf")); 23 vo.setTitle(rs.getString("title")); 24 25 } 26 }catch(SQLException e){ 27 e.printStackTrace(); 28 }finally{ 29 JDBC_Connection.free(rs, conn, pst); 30 } 31 return vo; 32 33 } 34 public static void main(String[] args) { 35 // TODO Auto-generated method stub 36 QueryById byid = new QueryById(); 37 int id = 3; 38 bbsVo vo = byid.QuerybbsVoById(id); 39 if(vo!=null){ 40 System.out.print("id "); 41 System.out.print("pid "); 42 System.out.print("rootid "); 43 System.out.print("title "); 44 System.out.print("cont "); 45 System.out.print("pdate "); 46 System.out.print("isleaf "); 47 System.out.println(); 48 System.out.print(vo.getId()+" "); 49 System.out.print(vo.getPid()+" "); 50 System.out.print(vo.getRootid()+" "); 51 System.out.print(vo.getTitle()+" "); 52 System.out.print(vo.getCont()+" "); 53 System.out.print(vo.getPdate()+" "); 54 System.out.print(vo.getIsleaf()+" "); 55 }else{ 56 System.out.println("id为"+id+" 的用户不存在"); 57 } 58 } 59 60 }

JDBC查询指定条件的数据

标签：

热心网友时间：2022-04-09 01:43

用eclipse
首先在oracle文件下找到jdbc文件，里面的lib文件下有个class12.zip
在eclipse里新建个项目，建好后在左边右击那个项目图标，选择属性（最下面的），里面有个java build path，点进去，找到add external jars按键，点一下，把那个class12.zip加载进来，然后可以开始写代码了。

我的代码如下：
import java.sql.*;

public class connect {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection con = null;
Statement stmt = null;
ResultSet rs = null;

try{
String url="jdbc:oracle:thin:@服务器ip地址:端口号:数据库名字";
String user="用户名";
String password="密码";
String str="INSERT INTO ZZZ_2 VALUES('041110018','JHDK')";

con = java.sql.DriverManager.getConnection(url,user,password);
// 创建状态
stmt = con.createStatement();
// 执行SQL语句，返回结果集
//int rowcount = stmt.executeUpdate(str);
int j = stmt.executeUpdate("update ZZZ_2 set NAME='dbt' where ID=21");
int k = stmt.executeUpdate("delete from ZZZ_2 where ID=41110020");
rs = stmt.executeQuery("SELECT * FROM ZZZ_2");
// 对结果集进行处理

while (rs.next()) {
int id = rs.getInt("ID");
String name = rs.getString("NAME");
//Integer age = rs.getObject("age") == null ? null : rs.getInt("age");
System.out.println(id + ": " + name);
} }catch(SQLException e){
e.printStackTrace();}

// 释放资源
finally{
try{
rs.close();
}catch(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try{
stmt.close();
}catch(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try{
con.close();
}catch(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}

}

注意,上面的ip地址什么的要填对,ZZZ_2是我随便建的表,你改成自己的表名就行了