更新数据库中的记录出错!!!!
我想用JSP更新数据库中的记录,字段templateid为number类型,我本想给其赋予一个随机整数,但现在测试时,赋予一个整数都出错,不知道何故。请各位大哥指教!
<!--test.jsp-->
<%@ page language="java" import="java.io.*,java.sql.*,javax.sql.* ,javax.naming.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<body>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@name:1521:dbname";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,"dbuser","password");
String sqlupdate="update m_company_base_info set templateid=5 where name='"+"hjhm"+'";
rs = stmt.executeUpdate(sqlupdate);
}
catch(Exception e)
{
out.println(e.getMessage());
}
finally
{
stmt.close();
conn.close();
}
%>
</body>
</html>