java 查询 oracle 数据库问题

你的time保存的是日期吗？yyyy-mm-dd

查询2008-07-07的纪录

select from game where time = to_date('2008-07-07','yyyy-mm-dd');

查询2008-07-07以后的纪录

select from game where time > to_date('2008-07-07','yyyy-mm-dd');

查询2008-07-07以前的纪录

select from game where time < to_date('2008-07-07','yyyy-mm-dd');

时间是可以用= > < 比较的

import javasql;

import javautilArrayList;

import javautilHashMap;

import javautilList;

import javautilMap;

public class BaseDao {

// private static final String DRIVER="commicrosoftsqlserverjdbcSQLServerDriver";

// private static final String URL="jdbc:sqlserver://localhost:1433;databaseName=orcl";

public static final String DRIVER = "oraclejdbcdriverOracleDriver";

public static final String URL = "jdbc:oracle:thin:@localhost:1521:ORCL";

private static final String USERNAME="sa";

private static final String PASSWORD="sa";

Connection conn=null;

PreparedStatement pst=null;

ResultSet rs=null;

public Connection getConnection(){

try {

ClassforName(DRIVER);

try {

conn=DriverManagergetConnection(URL, USERNAME, PASSWORD);

} catch (SQLException e) {

eprintStackTrace();

}

} catch (ClassNotFoundException e) {

eprintStackTrace();

}

return conn;

}

public void close(){

if(rs!=null){

try {

rsclose();

} catch (SQLException e) {

eprintStackTrace();

}

}

if(pst!=null){

try {

rsclose();

} catch (SQLException e) {

eprintStackTrace();

}

}

if(conn!=null){

try {

rsclose();

} catch (SQLException e) {

eprintStackTrace();

}

}

}

public void setParams(Objectparams){

if(null!=params){

for(int i=0;i<paramslength;i++){

try {

pstsetObject(i+1, params[i]);

} catch (SQLException e) {

eprintStackTrace();

}

}

}

}

public int executeUpdate(String sql,Objectparams){

int result=-1;

conn=getConnection();

try {

pst=connprepareStatement(sql);

setParams(params);

result=pstexecuteUpdate();

} catch (SQLException e) {

eprintStackTrace();

}

return result;

}

public List<Map<String, Object>> executeQuery(String sql, Object params) {

List<Map<String, Object>> result = new ArrayList<Map<String, Object>>(); conn = getConnection();

try {

pst = connprepareStatement(sql);

setParams(params);

rs = pstexecuteQuery();

ResultSetMetaData rsmd = rsgetMetaData();

int columnCount = rsmdgetColumnCount();

Map<String, Object> row = null;

while (rsnext()) {

row = new HashMap<String, Object>();

for (int i = 0; i < columnCount; i++) {

String columnName = rsmdgetColumnName(i + 1);

Object value = rsgetObject(columnName);

rowput(columnNametoLowerCase(), value);

}

resultadd(row);

}

} catch (SQLException e) {

eprintStackTrace();

} finally {

close();

}

return result;

}

public int execute(String sql, Object params) {

int result = -1;

conn = getConnection();

try {

pst = connprepareStatement(sql);

setParams(pst, params); result = pstexecuteUpdate();

} catch (SQLException e) {

eprintStackTrace();

} finally {

close();

}

return result;

} public ResultSet query(String sql, Object params) {

conn = getConnection();

try {

pst = connprepareStatement(sql);

setParams(pst, params);

rs = pstexecuteQuery();

} catch (SQLException e) {

eprintStackTrace();

}

return rs;

}

}

你经过上面的查询之后,把那些东西都存放到all里面去了嘛

List<DepartmentBean> all = new ArrayList<DepartmentBean>();

你再把all里面存的东西DepartmentBean一个一个取出来嘛

for(int i=0;i<allsize();i++){

DepartmentBeanp b= (DepartmentBean)allget(i);//逐个取出bean

//输出bean里面的属性

Systemoutprintln(bgetXXX());//你想输出b的哪些属性

}

你这个方法带有一个参数

public void printAll(DepartmentBean bean){

//不知道你想输出什么,直接用beangetXXX()方法就行了嘛

}

import javaxservlet;

import javaxservlet>

以上就是关于java 查询 oracle 数据库问题全部的内容，包括:java 查询 oracle 数据库问题、如何使用java对oracle数据库进行增删查改、java *** 作oracle数据库的问题等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！