从数据库中读出字符数据转换成整数数据,有问题题?急!!!给分!
废话很多 2001-06-29 12:00:49 <%@ page contentType="text/html;charset=Gb2312" import="java.sql.*"%>
<html>
<head>
<title>长庆油田公司——物资</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
//加载驱动程序类
String url="jdbc:oracle:thin:@demo:1521:ora8";
Connection con=DriverManager.getConnection(url,"demo_user","kingstone");
//建立数据库联机
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
// 建立Statement对象
ResultSet rs;
//建立ResultSet(结果集)对象
rs=stmt.executeQuery("select max(max_type_id) as maxid from max_type");
//执行SQL语句
%>
<p> </p><table bg=dodgerBlue>
<tr bg=skyblue>
<td><b>物资大类编号</b></td>
<td><b>物资大类名称</b></td>
</tr>
<form name="form1" method="post" action="addmax_success.jsp">
<%
//利用while循环将数据表的记录输出
while(rs.next())
{
%>
<p>物资大类编号 <input type="text" name="id" value=" " disabled> *<%
int dd=Integer.parseInt(rs.getString("maxid"));
// int dd2=Integer.parseInt(dd);
%><%=dd%></p>
<p>物资大类名称
<input type="text" name="name">
*</p>
<%
}
rs.close();//关闭ResultSet对象
stmt.close();//关闭Statement
con.close();//关闭Connection对象
%>
</table>
<input type="submit" name="Submit" value="提交">
<input type="button" name="Submit2" value="取消">
</p>
</form>
</body>
</html>
出错为
异常:
java.lang.NumberFormatException: 07