读书人

JSP中应用ACCESS的有关问题!

发布时间: 2012-01-10 21:26:51 作者: rapoo

JSP中应用ACCESS的问题!!!急
请问如何在JSP中控制ACCESS 进行 UPDATE DELETE

例如从一个页面接受数据

到JSP中 更改数据 或者删除数据 怎么做啊???

另外 以下的程序是修改代码 那里有错?

已经从第一个HTML页里POST 这些数据到这个JSP里

<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>

<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> POST </title>
</head>

<body>
<%

Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");

Connection con=DriverManager.getConnection( "jdbc:odbc:db ");

Statement Stmt=con.createStatement(); request.setCharacterEncoding( "GBK ");

String shuid=request.getParameter( "shuid ");

String lei=request.getParameter( "lei ");

String shu_name=request.getParameter( "shu_name ");

String dingjia=request.getParameter( "dingjia ");

String zhuozhe=request.getParameter( "zhuozhe ");

String banshe=request.getParameter( "banshe ");

Stmt.executeUpdate( "update tushumingxi set shuid= ' "+shuid+ " ',leiID= ' "+lei+ " ',shu_name= ' "+shu_name+ " ',dingjia= ' "+dingjia+ " '
,zhuozhe= ' "+zhuozhe+ " ',banshe= ' "+banshe+ " ' where shuid= ' "+shuid+ " ' ");



ResultSet Rs=Stmt.executeQuery( "SELECT shuid,lieID,shu_name,dingjia,zhuozhe,banshe FROM tushumingxi ");

while(Rs.next())
{
%>
<p> <strong> 修改成功 </strong>
<p>
<%
}

// Cleanup resources

Rs.close();
Stmt.close();


con.close();


%>
</body>
</html>

[解决办法]
fasdfasdf

读书人网 >Java Web开发

热点推荐