jsp access2000数据库操作!!!!!!!!!!!!!!!!!!!!!!!
请问???
我在jsp编程的过程中遇到点麻烦向各位请教.我想用useBean往access2000数据库写入数据,但是我写完java程序编译成.class文件然后再jsp中操作,但是就是不能把数据写入数据库,想请各位指教,
package Report;
import java.io.*;
import java.sql.*;
import java.util.*;
import DataBase.accessConnect;
public class DataOperation extends DataInfo
{
public ResultSet rs=null;
public String dbName;
public DataOperation() {}
/**
*添加记录
*
*/
public void addRecord(String tableName)
{
accessConnect dbConnect=new accessConnect();
dbConnect.databaseName=this.dbName;
try
{
String sql="INSERT INTO "+tableName+"(帐号,项目名称)values("+this.bill+",\'"+this.proname+"\')";
dbConnect.executeUpdate(sql);
}
catch(Exception e)
{
System.out.println("Location:DataOperation:Error 1:"+e.getMessage());
}
finally
{
dbConnect.close();
}
}
jsp代码:
<jsp:useBean id="insert" scope="page" class="Report.DataOperation"/>
<%
insert.dbName="*****.mdb";
tableName=tableInfo.getdataname();
insert.setbill(bill);
insert.setproname(proname);
insert.addRecord(tableName);
%>
请各位指正,或者更好的建议.谢谢