我现在有一个jsp写的网站,数据库用的是sqlserver2000,现在想改成oracle8i数据库,程序方面都需要改动那些地方啊,数据库操作添加,删除,更新,等等都需要怎么改变呢,呵呵,有源码程序更好了,谢谢!!!
解决方案 »
- 关于jsp:useBean的一个小困惑
- 求助贴,急!!!
- 紧急求助!!!
- 在Applet中,如何改变鼠标指针的形状
- 一个小问题,来拿分
- 超难度问题,怎么样把TEXTAREA 中的数据提交到数据库再回显到TEXTAREA 而且格式不变!
- 各位老大,谁能回答以下几道操作系统问题的,重谢!急,关系到到MM明天的考试
- 请教jsp对各类数据库的连接
- 哪位大虾对robocode有研究??请指教一下!~!!
- 在线给分啊!
- 如何将这样的日期“2006-12-20 00:00:00.0”的小时分钟去掉成为“2006-12-20”
- 广告:怀念卖JSP网站集锦的那两位,我的专业的PK网站做完了,他们怎么也不来注册参加PK.炸锅网:http://www.zaguo.com/
public boolean addNewZyhjyshzb(Zyhjyshzb pobjZyhjyshzb,int RecordFileid) throws Exception
{
boolean pblnFlag = false;
mstrSQL = "INSERT INTO H_Zyhjyshzb(CreateIP,CreateTime,message,createUserID) VALUES ('"+pobjZyhjyshzb.getCreateIP()+"',to_date('"+pobjZyhjyshzb.getCreateTime()+"','yyyy-mm-dd hh24:mi:ss'),'"+pobjZyhjyshzb.getMessage()+"',"+pobjZyhjyshzb.getCreateUser().getSysUserID()+")";
if(mobjDatabase.executeUpdate(mstrSQL))
{
//文件资料ID
int pintzyhjyshzb = 0;
mobjRS = mobjDatabase.getResultSet("select ID from H_Zyhjyshzb where ID=(select max(ID) from H_Zyhjyshzb)");
if(mobjRS.next())
{
pintzyhjyshzb = mobjRS.getInt("ID");
//将审批该文件的用户插入数据库
mstrSQL = "INSERT INTO H_RECORD(RECORDFILEID,SYSUSERID,CREATEFILEID) VALUES("+RecordFileid+","+pobjZyhjyshzb.getChkSysUser().getSysUserID()+",'"+pintzyhjyshzb+"')";
pblnFlag = mobjDatabase.executeUpdate(mstrSQL);
}
}
return pblnFlag;
} /**
* Function Detail : 更新部门名称
* @param pobjDep : 部门对象
* @return : boolean
*/
public boolean updateDepartment(Department pobjDep) throws SQLException
{
if(pobjDep!=null)
{
if(this.chkDepName(pobjDep.getDepartmentName(),pobjDep.getDepartmentId()))
{
return false;
}
mstrSql = "update H_DepAndSec SET NAME = '"+pobjDep.getDepartmentName()+"'," +
"INTRODUCE = '"+pobjDep.getDepartmentIntroduce()+"' " +
"WHERE ID = " + pobjDep.getDepartmentId();
return mobjDatabase.executeUpdate(mstrSql);
}
else
{
return false;
}
}
/**
* Function Detail : 删除部门列表
* @param parrStr : 被删除的部门ID
* @return : boolean
*/
public boolean delDepartment(String[] parrDepID) throws SQLException
{
String pstrDepID = FunLibrary.toString(parrDepID);
mstrSql = "select * from H_DepAndSec where parentid in ("+pstrDepID+")";
mobjRs = mobjDatabase.getResultSet(mstrSql);
if(mobjRs.next())
{
return false;
}
else
{
mstrSql = "delete H_DepAndSec where ID IN ("+pstrDepID+")";
return mobjDatabase.executeUpdate(mstrSql);
} }
url改為: jdbc:oracle:thin:@192.168.XX.XXX:1521:XXX
還有user和passwordOracle的數據庫的操作和sql2000差不多,
增,查,刪,改的sql語法也是差不多,只是區別在某些函數的使用,
建議樓主去查看一下Oracle的幫助文檔.
还有就是对数据库date类型的数据进行操作,要用to_date 和 to_char 还要加格式
没有top或者limit只能用between and代替其他的应该差别不大~~~
public DatabaseService() throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.1.102:1521:database";
String user="user";
String password="password";
mobjConn = DriverManager.getConnection(url,user,password);
}
1.建立序列create sequence seq_nbsh
minvalue 1
maxvalue 9999999999
start with 1
increment by 12.建立触发器create trigger tri_NBSP BEFORE INSERT ON H_NBSH FOR EACH ROW
begin
select seq_nbsh.nextval into :new.ID from dual;
end;
{
private final String driver, url, user, pwd;
private int initialConnections;
private static final int DEFAULT_INIT_CONNS = 5;
private static final int DEFAULT_MAX_CONNS = 40;
//private final int finalInitConns;
private boolean driverLoaded = false;
private boolean localDB = false;
private Logger logger;
public DBConnectionPool() {
driver=null;
url=null;
user=null;
pwd=null;
logger = new WebLogger( this.getClass() ).getLogger();
logger.fatal("Null pool created.");
/*
this( "oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:thin:@10.10.1.188:1521:pdgm",
"csi_sample",
"csi_sample",
java.lang.Integer.toString(DEFAULT_INIT_CONNS),
java.lang.Integer.toString(DEFAULT_MAX_CONNS) );*/
}