高分求用javabean实现对数据库的插入修改删除的源码！谢谢

[buggavin]

用sqlserver数据库，最好还有连接哈！

谢谢的说1

[buggavin]

有没有用rowset的例子？谢谢了哈，楼上这位老大，你的例子不错，可是我们老板要求用rowset，十分抱歉没有说清楚！！！

[buggavin]

没有人知道吗？

[buggavin]

还有如何返回jsp页面中listbox的值给javabean？

[ejbcreate]

以下是我以前的一个用来操作数据库的Bean：

/*
Name: $DBOperation.java
Function desc: The operations of oracle database;
Author: Ejbcreate
*/

package com.susun.bean;

import java.lang.*;
import java.util.*;
import java.io.*;
import java.sql.*;
import java.math.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;
import com.susun.cmppApi.LogWriter;

public class DBOperation
{
private static final int DB_FATAL = -1;
private static final int DB_LOCKED = 1;
private static final int DB_ABORTED = 2;
private static final int DB_MODIFIED = 3;
private static final int DB_SUCC = 0;
private static final int DB_EOF = 100;
private static final int DB_ORA_EOF = +1403; //Record not found
private static final int DB_ORA_DUP = -1; //Duplicate record (key)
private static final int DB_ORA_RLOCK= -54; //Resource locked

private int gDBStatus;
private int gSQLCode;
private String gSQLState;
private String gSQLMsg;

private String gConnStr;
private String gDBUser;
private String gDBPassWord;

public Connection gConn;
private Statement gStat;
private ResultSet gRSet;
private Hashtable gStatHash;
private Hashtable gRSetHash;

private LogWriter gSysLog = new LogWriter("E:\\API\\CMPP\\DB.txt");

public static void main(String[] args)
{
String lConnStr ="jdbc:oracle:thin:@ABserver:1521:ORCL";
String lUser = "sms";
String lPWord = "sms";
String lName = "Test";
String lNameU = "TestU";
String lSqlStr = "";
DBOperation lDBOper = null;
try
{
lDBOper = new DBOperation(lConnStr, lUser, lPWord);
lDBOper.dbConnect();
if(!lDBOper.dbIsSuccess())
{
System.out.println("DB connect fail!!!");
return;
}
//lSqlStr = "Select * from testbyleo";
//lSqlStr = "select id, name from testbyleo where id='00001'";
//lSqlStr = "select id, name from testbyleo";
//lDBOper.dbSQL(lName, lSqlStr);
//lDBOper.dbSQL(lNameU, lSqlStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
//lDBOper.dbSQL(lName, lSqlStr, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
/*
while(lDBOper.dbIsSuccess())
{
String lId = lDBOper.dbGetString(lName, "ID");
String lNa = lDBOper.dbGetString(lName, "NAME");
System.out.println("ID = "+lId);
System.out.println("NAME = " + lNa);
lDBOper.dbMoveNext(lName);
}
lDBOper.dbCloseRS(lName);
*/
/*
if(lDBOper.dbIsSuccess())
{
lDBOper.dbUpdateString(lName, "NAME", "OKAY");
lDBOper.dbUpdateRow(lName);

if(lDBOper.dbIsSuccess())
System.out.println("Update success");
else
System.out.println("Update fail");
}
lDBOper.dbCloseRS(lName);
*/
/*
System.out.println("lDBOper.dbIsSuccess() is "+lDBOper.dbIsSuccess());
//if(lDBOper.dbIsEOF())
//{
System.out.println("Insert action......");

lDBOper.dbMoveToInsertRow(lName);
lDBOper.dbUpdateString(lName, "ID", "00002");
//dbUpdateString(String rName, String rColumnName, String rContent)
lDBOper.dbUpdateString(lName, "NAME", "YEAH");
lDBOper.dbInsertRow(lName);
if(lDBOper.dbIsSuccess())
System.out.println("Insert data success!!!");
else
System.out.println("Insert data failure!!!");
//}
*/

/******Test the operation which write a picture into DB*************/
/*
lSqlStr = "insert into testsms values(1, '13662400888', 'ejbcreate', empty_blob(), sysdate, 1)";
lDBOper.dbBeginTrans();
int lInsert = lDBOper.dbExecute(lSqlStr);
System.out.println("Insert count = "+lInsert);
if(!lDBOper.dbIsSuccess())
{
System.out.println("Insert data failure!!!");
return;
}
lSqlStr = "select smsimg from testsms where id=1";
lDBOper.dbSQL(lName, lSqlStr, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
if(!lDBOper.dbIsSuccess())
{
System.out.println("select smsimg failure!!!");
return;
}
BLOB lBlob = lDBOper.dbGetBlob(lName, "smsimg");
OutputStream lOut = lBlob.getBinaryOutputStream();
String lPicPath = "E:\\API\\google.gif";
FileInputStream lFIS = new FileInputStream(lPicPath);
//BufferedInputStream in = new BufferedInputStream(new FileInputStream(infile));
int lC;
while((lC=lFIS.read()) != -1)
{
lOut.write(lC);
}
lFIS.close();
lOut.close();
lDBOper.dbUpdateBlob(lName, "smsimg", lBlob);
lDBOper.dbUpdateRow(lName);
if(lDBOper.dbIsSuccess())
System.out.println("Update success!!!");
else
System.out.println("Update failure!!!");
*/

/******Test the operation which get the blob type datas from DB*************/
/**/
lSqlStr = "select id, mobnumb, smscont, smsimg, senddate, lockflag from testsms";
lDBOper.dbSQL(lName, lSqlStr, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
String lFN = "E:\\API\\Blob_";
int lF = 0;
while(lDBOper.dbIsSuccess())
{
int lID = lDBOper.dbGetInt(lName, "ID");
String lMobNumb = lDBOper.dbGetString(lName, "MOBNUMB");
String lSmsCont = lDBOper.dbGetString(lName, "SMSCONT");
BLOB lSmsImg = lDBOper.dbGetBlob(lName, "SMSIMG");
java.util.Date lSendDate = lDBOper.dbGetDate(lName, "SENDDATE");
int lLockFlag = lDBOper.dbGetInt(lName, "LOCKFLAG");

java.text.SimpleDateFormat lFormat = new java.text.SimpleDateFormat("yyyy-MM-dd");
String lSendStr = lFormat.format(lSendDate);
System.out.println("ID = "+lID);
System.out.println("MOUNUM = "+lMobNumb);
System.out.println("SMSCONT = "+lSmsCont);
System.out.println("SMSIMG.size = "+lSmsImg.length());
System.out.println("SENDDATE = "+lSendDate);
lFN = lFN + lF + ".gif";
FileOutputStream lFOS = new FileOutputStream(lFN);

InputStream lInS = lSmsImg.getBinaryStream();
int lX;
while((lX=lInS.read()) != -1)
{
lFOS.write(lX);
}
lInS.close();
lFOS.close();
lF++;
lDBOper.dbMoveNext(lName);
}
/**/
lDBOper.dbCommitTrans();
lDBOper.dbCloseRS(lName);
lDBOper.dbDisConnect();
}
catch(Exception ex)
{
System.out.println("DBOperation main() Excpt: "+ex.toString());
}
}

[ejbcreate]

public DBOperation(String rConnStr, String rDBUser, String rDBPassWord)
{
gConnStr = rConnStr;
gDBUser = rDBUser;
gDBPassWord = rDBPassWord;

gConn = null;
gStat = null;
gRSet = null;
gStatHash = new Hashtable();
gRSetHash = new Hashtable();
}

public void dbSuccess()
{
gDBStatus = DB_SUCC;
}

public void dbEndOfData()
{
gDBStatus = DB_EOF;
}

public boolean dbIsSuccess()
{
return (gDBStatus==DB_SUCC);
}

public boolean dbIsEOF()
{
return (gDBStatus==DB_EOF);
}

public boolean dbIsLocked()
{
return (gDBStatus==DB_LOCKED);
}

public boolean dbIsAborted()
{
return (gDBStatus==DB_ABORTED);
}

public boolean dbIsModified()
{
return (gDBStatus==DB_MODIFIED);
}

public boolean dbIsFatal()
{
return (gDBStatus==DB_FATAL);
}

public boolean dbIsNoChange(String rName, int rValue)
{
try
{
if(rValue==this.dbGetInt(rName, "LOCKFLAG"))
{
return true;
}
else
{
gDBStatus = DB_MODIFIED;
return false;
}
}
catch(Exception ex)
{
System.out.println("dbIsNoChange() Excpt: "+ex.toString());
return false;
}
}

public void dbAnalyzeError(SQLException ex)
{
gSQLCode = ex.getErrorCode();
gSQLState= ex.getSQLState();
gSQLMsg = ex.getMessage().toString();
System.out.println("gSQLCode = "+gSQLCode);
System.out.println("gSQLState = "+gSQLState);
System.out.println("gSQLMsg = "+gSQLMsg);

if(gSQLCode==DB_ORA_RLOCK)
{
gDBStatus = DB_LOCKED;
}
else if(gSQLCode==DB_ORA_DUP)
{
gDBStatus = DB_ABORTED;
}
else
{
gDBStatus = DB_FATAL;
}
}

public boolean dbIsClosed()
{
boolean lRtn = false;
try
{
if(gConn.isClosed())
lRtn = true;
}
catch(SQLException SqlEx)
{
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbIsClosed() Excpt: "+SqlEx.toString());
}
return lRtn;
}

public void dbConnect()
{
gConn = null;
gStat = null;
gRSet = null;
gStatHash = new Hashtable();
gRSetHash = new Hashtable();

try
{
//Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
gConn = DriverManager.getConnection(gConnStr, gDBUser, gDBPassWord);
dbSuccess();
}/*
catch(ClassNotFoundException ex)
{
System.out.println("ClassNotFoundException: "+ex.toString());
}*/
catch(SQLException SqlEx)
{
System.out.println("dbConnect() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbConnect() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbDisConnect()
{
try
{
gConn.close();
gConn = null;
gStat = null;
gRSet = null;
gStatHash = new Hashtable();
gRSetHash = new Hashtable();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbDisConnect() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbDisConnect() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbSQL(String rName, String rSqlStr)
{
ResultSet lRSet = null;
Statement lStat = null;
try
{
lStat = gConn.createStatement();
lRSet = lStat.executeQuery(rSqlStr);
if(lRSet.next())
dbSuccess();
else
dbEndOfData();
if(rName==null)
{
gRSet = lRSet;
gStat = lStat;
}
else
{
gRSetHash.put(rName, lRSet);
gStatHash.put(rName, lStat);
}
}
catch(SQLException SqlEx)
{
System.out.println("dbSQL() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbSQL() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbSQL(String rName, String rSqlStr, int rRSType, int rRSConcurr)
{
ResultSet lRSet = null;
Statement lStat = null;
try
{
lStat = gConn.createStatement(rRSType, rRSConcurr);
lRSet = lStat.executeQuery(rSqlStr);
if(lRSet.next())
dbSuccess();
else
dbEndOfData();
if(rName==null)
{
gRSet = lRSet;
gStat = lStat;
}
else
{
gRSetHash.put(rName, lRSet);
gStatHash.put(rName, lStat);
}
}
catch(SQLException SqlEx)
{
System.out.println("dbSQL() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbSQL() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public int dbExecute(String rSqlStr)
{
Statement lStat = null;
int lCount=0;
try
{
lStat = gConn.createStatement();
lCount= lStat.executeUpdate(rSqlStr);
lStat.close();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbExecute() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbExecute() dbIsFatal() Excpt: "+SqlEx.toString());
}
return lCount;
}

public void dbCloseRS(String rName)
{
ResultSet lRS = gRSet;
Statement lST = gStat;
try
{
if(rName != null)
{
lRS = (ResultSet)gRSetHash.get(rName);
lST = (Statement)gStatHash.get(rName);
}
if(lRS != null) lRS.close();
if(lST != null) lST.close();
if(rName != null)
{
gRSetHash.remove(rName);
gStatHash.remove(rName);
}
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbCloseRS() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbCloseRS() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

[ejbcreate]

public void dbMoveToInsertRow(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
lRSet.moveToInsertRow();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbMoveToInsertRow() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMoveToInsertRow() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbMoveToCurrentRow(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
lRSet.moveToCurrentRow();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbMoveToCurrentRow() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMoveToCurrentRow() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbInsertRow(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
lRSet.insertRow();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbInsertRow() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbInsertRow() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbUpdateRow(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
lRSet.updateRow();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbUpdateRow() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbUpdateRow() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbDeleteRow(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
lRSet.deleteRow();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbDeleteRow() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbDeleteRow() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbCancelRowUpdate(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
lRSet.cancelRowUpdates();
dbSuccess();
}
catch(SQLException SqlEx)
{
System.out.println("dbCancelRowUpdate() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbCancelRowUpdate() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbMove(String rName, int rRow)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
if(lRSet.absolute(rRow))
{
dbSuccess();
}
else
{
dbEndOfData();
}
}
catch(SQLException SqlEx)
{
System.out.println("dbMove() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMove() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbMoveFirst(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
if(lRSet.first())
{
dbSuccess();
}
else
{
dbEndOfData();
}
}
catch(SQLException SqlEx)
{
System.out.println("dbMoveFirst() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMoveFirst() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbMoveLast(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
if(lRSet.last())
{
dbSuccess();
}
else
{
dbEndOfData();
}
}
catch(SQLException SqlEx)
{
System.out.println("dbMoveLast() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMoveLast() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbMoveNext(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
if(lRSet.next())
{
dbSuccess();
}
else
{
dbEndOfData();
}
}
catch(SQLException SqlEx)
{
System.out.println("dbMoveNext() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMoveNext() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

public void dbMovePrevious(String rName)
{
ResultSet lRSet = null;
try
{
lRSet = gRSet;
if(rName != null)
lRSet = (ResultSet)gRSetHash.get(rName);
if(lRSet.previous())
{
dbSuccess();
}
else
{
dbEndOfData();
}
}
catch(SQLException SqlEx)
{
System.out.println("dbMovePrevious() Excpt: "+SqlEx.toString());
dbAnalyzeError(SqlEx);
if(dbIsFatal())
System.out.println("dbMovePrevious() dbIsFatal() Excpt: "+SqlEx.toString());
}
}

[buggavin]

各位老大，帮帮忙吧！

[laiyuehui]

http://yuehui.cn.gs/CPJS/Ksst.html

[mycomcn]

up
jsp查书系统源码:http://yuehui.cn.gs/soft/sbook.rar(这个可以是并且免费)
自定查询源码:http://yuehui.cn.gs/soft/find.rar
考试系统源码:http://yuehui.cn.gs/CPJS/ks_bb_gm.html