大家帮帮小弟我看看这个指针错误出现在哪？ 待中。
日期：2014-05-18 浏览次数：20821 次
大家帮帮我看看这个指针异常出现在哪？ 在线等待中。。。
<%@ page contentType= "text/html; charset=gb2312 " language= "java " %>
<%@ page import= "java.sql.* "%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN "
"http://www.w3.org/TR/html4/loose.dtd ">
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 配件信息入库 </title>
</head>
<jsp:useBean id= "db " scope= "page " class= "ywgl.DataBean "/>
<jsp:useBean id= "tb " scope= "page " class= "ywgl.ToolBean "/>
<body>
<%
String name=tb.ntos((String)request.getParameter( "name "));
String zjm=tb.ntos((String)request.getParameter( "zjm "));
String cp=tb.ntos((String)request.getParameter( "cp "));
String xh=tb.ntos((String)request.getParameter( "xh "));
zjm=zjm.toUpperCase();
name=tb.gtoi(name);
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
boolean bcommit=true;
String sql= " ",code= " ";
try{
conn=db.GetConnection();
bcommit=conn.getAutoCommit();
conn.setAutoCommit(false);
stmt=conn.createStatement();
sql= "select max(code) from YW_PEIJIAN ";
rs=stmt.executeQuery(sql);
if(rs.next())
{
code=rs.getString(1);
if(code==null) code= "0001 ";
else code=String.valueOf(Integer.parseInt(code)+1);
}
else code= "0001 ";
int i,j;
j=code.length();
for(i=0;i <4-j;i++) code= "0 "+code;
sql= "insert into YW_PEIJIAN(code,name,cp,xh,zjm,) values( ' "+code+ " ', ' "+name+ " ', ' "+cp+ " ', ' "+xh+ " ', ' "+zjm+ " ',) ";
stmt.execute(sql);
conn.commit();
response.sendRedirect( "isitem.jsp ");
}
catch(Exception e){
e.printStackTrace();
conn.rollback();
out.println( " <div align=center> 添加设备种类失败！ </div> ");
out.println( " <p> <p> <div align=center> <a href=javascript:history.back();> 返回前页 </a> </div> ");
}
finally{
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(conn!=null && !conn.isClosed()) conn.close();
}
%>
</body>
</html>
------解决方案--------------------
建议不要把代码写到页面里，写个javabean
------解决方案--------------------
String name=tb.ntos((String)request.getParameter( "name "));
String
<%@ page contentType= "text/html; charset=gb2312 " language= "java " %>
<%@ page import= "java.sql.* "%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN "
"http://www.w3.org/TR/html4/loose.dtd ">
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 配件信息入库 </title>
</head>
<jsp:useBean id= "db " scope= "page " class= "ywgl.DataBean "/>
<jsp:useBean id= "tb " scope= "page " class= "ywgl.ToolBean "/>
<body>
<%
String name=tb.ntos((String)request.getParameter( "name "));
String zjm=tb.ntos((String)request.getParameter( "zjm "));
String cp=tb.ntos((String)request.getParameter( "cp "));
String xh=tb.ntos((String)request.getParameter( "xh "));
zjm=zjm.toUpperCase();
name=tb.gtoi(name);
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
boolean bcommit=true;
String sql= " ",code= " ";
try{
conn=db.GetConnection();
bcommit=conn.getAutoCommit();
conn.setAutoCommit(false);
stmt=conn.createStatement();
sql= "select max(code) from YW_PEIJIAN ";
rs=stmt.executeQuery(sql);
if(rs.next())
{
code=rs.getString(1);
if(code==null) code= "0001 ";
else code=String.valueOf(Integer.parseInt(code)+1);
}
else code= "0001 ";
int i,j;
j=code.length();
for(i=0;i <4-j;i++) code= "0 "+code;
sql= "insert into YW_PEIJIAN(code,name,cp,xh,zjm,) values( ' "+code+ " ', ' "+name+ " ', ' "+cp+ " ', ' "+xh+ " ', ' "+zjm+ " ',) ";
stmt.execute(sql);
conn.commit();
response.sendRedirect( "isitem.jsp ");
}
catch(Exception e){
e.printStackTrace();
conn.rollback();
out.println( " <div align=center> 添加设备种类失败！ </div> ");
out.println( " <p> <p> <div align=center> <a href=javascript:history.back();> 返回前页 </a> </div> ");
}
finally{
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(conn!=null && !conn.isClosed()) conn.close();
}
%>
</body>
</html>
------解决方案--------------------
建议不要把代码写到页面里，写个javabean
------解决方案--------------------
String name=tb.ntos((String)request.getParameter( "name "));
String
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
