<jsp:useBean id="dbconn" scope="page" class="com.zcjp.DbConn"></jsp:useBean>
<%
String JiSiType=null;
String Zc_ID=null;
Zc_ID=request.getParameter("id");
JiSiType=request.getParameter("JiSiType");
if(request.getParameter("sub")=="yes"){
String JiSiWpID=null;
String LiuName=null;
String LiuyanEmail=null;
String LiuyanTitle=null;
String LiuyanContent=null;
JiSiType=request.getParameter("JiSiType");
Zc_ID=request.getParameter("Zc_ID");
JiSiWpID=request.getParameter("JiSiWpID");
LiuName=request.getParameter("LiuName");
LiuyanEmail=request.getParameter("LiuyanEmail");
LiuyanTitle=request.getParameter("LiuyanTitle");
LiuyanContent=request.getParameter("LiuyanContent");
String sql=null;
sql="insert into Zc_liuyan(Zc_ID,LyTitle,LyContent,JiSiTypeID,JiSiWpID,LyName,LyEmail) values ('"+Integer.parseInt(Zc_ID)+"','"+LiuyanTitle+"','"+LiuyanContent+"','"+Integer.parseInt(JiSiType)+"','"+Integer.parseInt(JiSiWpID)+"','"+LiuName+"','"+LiuyanEmail+"')";
Statement stmt=null;
dbconn.getconn();
stmt.executeUpdate(sql);
//dbconn.updateSQL(sql);
//request.getRequestDispatcher("Zc_JiSi.jsp").forward(request,response);
response.sendRedirect("Zc_JiSi.jsp");
}插入老是不成功,
<%
String JiSiType=null;
String Zc_ID=null;
Zc_ID=request.getParameter("id");
JiSiType=request.getParameter("JiSiType");
if(request.getParameter("sub")=="yes"){
String JiSiWpID=null;
String LiuName=null;
String LiuyanEmail=null;
String LiuyanTitle=null;
String LiuyanContent=null;
JiSiType=request.getParameter("JiSiType");
Zc_ID=request.getParameter("Zc_ID");
JiSiWpID=request.getParameter("JiSiWpID");
LiuName=request.getParameter("LiuName");
LiuyanEmail=request.getParameter("LiuyanEmail");
LiuyanTitle=request.getParameter("LiuyanTitle");
LiuyanContent=request.getParameter("LiuyanContent");
String sql=null;
sql="insert into Zc_liuyan(Zc_ID,LyTitle,LyContent,JiSiTypeID,JiSiWpID,LyName,LyEmail) values ('"+Integer.parseInt(Zc_ID)+"','"+LiuyanTitle+"','"+LiuyanContent+"','"+Integer.parseInt(JiSiType)+"','"+Integer.parseInt(JiSiWpID)+"','"+LiuName+"','"+LiuyanEmail+"')";
Statement stmt=null;
dbconn.getconn();
stmt.executeUpdate(sql);
//dbconn.updateSQL(sql);
//request.getRequestDispatcher("Zc_JiSi.jsp").forward(request,response);
response.sendRedirect("Zc_JiSi.jsp");
}插入老是不成功,
,连接要关闭..
还要,你数据库中字段Zc_ID..等
都是INT类型吧,把'"+Integer.parseInt(Zc_ID)+"'这种
形式改为"+Integer.parseInt(Zc_ID)+"
http://localhost:8080/Js_Zcjp/ZongChi/Zc_JiSi.jsp?sub=yes&JiSiType=26
Statement stmt=null;
dbconn.getconn();
stmt.executeUpdate(sql); stmt 没有看到赋值的语句,你报的是不是 nullPointer 错误啊!!!!