求教：servlet无法将表单获取的数据插入数据库

[weirdo_]

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import we.Opp;
public class Ar extends HttpServlet
{ static Connection conn;
public void service(HttpServletRequest rq, HttpServletResponse rp)throws ServletException, IOException
{
String userName = "system";
String userPwd = "123";
// String driverName = "oracle.jdbc.driver.OracleDriver";
//String dburl = "jdbc:oracle:thin:@localhost:1521:WENHUA";
rp.setContentType("text/html;charset=gbk");
PrintWriter out = rp.getWriter();
String no = new String(rq.getParameter("wzbh").getBytes("iso-8859-1"));
String nm = new String(rq.getParameter("wzmc").getBytes("iso-8859-1"));
String sx = new String(rq.getParameter("wzxh").getBytes("iso-8859-1"));
String ag = new String(rq.getParameter("wzlx").getBytes("iso-8859-1"));
String dp = new String(rq.getParameter("wzdw").getBytes("iso-8859-1"));
System. out.println("Thank u ");
try {
if (Ab.flag == 0){
new Ab(userName, userPwd);
out.println("flag==0");
}
out.println("Connection Susful!");
Statement stmt = Ab.conn.createStatement();
String s1 = "insert into WUZIXX values('";
s1 = s1 + no + "','" + nm + "','" + sx + "','" + ag + "','" + dp + "')";
out.println(s1+"cao!");
stmt.executeUpdate(s1);
out.println("Thank you ca");
} catch (java.lang.Exception stmt) {
}
out.println("Thank you ");
out.println("Thank you !!");

}
}



Ab类：
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
public class Ab {
String driverName = "oracle.jdbc.driver.OracleDriver";
String dburl = "jdbc:oracle:thin:@localhost:1521:WENHUA";
static int flag = 0;
// String username = "system";
// String password = "123";
static Connection conn;

public Ab(String userName, String userPwd)
{
try
{
Class.forName(this.driverName);
conn = DriverManager.getConnection(this.dburl, userName, userPwd);
flag = 1;
System.out.println("Connec Successful!");
} catch (Exception e) {
System.out.println("connec error!");
e.printStackTrace();
}
}
}

[身胖不怕影子歪]

HttpServlet 不是有俩默认方法呢 哪去了

[weirdo_]

引用 1 楼 songbgi 的回复:

HttpServlet 不是有俩默认方法呢 哪去了

这是我刚改的 import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class Ar extends HttpServlet { static Connection conn; public void service(HttpServletRequest rq, HttpServletResponse rp)throws ServletException, IOException { String userName = "system"; String userPwd = "123"; String driverName = "oracle.jdbc.driver.OracleDriver"; String dburl = "jdbc:oracle:thin:@localhost:1521:WENHUA"; rp.setContentType("text/html;charset=gbk"); PrintWriter out = rp.getWriter(); String no = new String(rq.getParameter("wzbh").getBytes("iso-8859-1")); String nm = new String(rq.getParameter("wzmc").getBytes("iso-8859-1")); String sx = new String(rq.getParameter("wzxh").getBytes("iso-8859-1")); String ag = new String(rq.getParameter("wzlx").getBytes("iso-8859-1")); String dp = new String(rq.getParameter("wzdw").getBytes("iso-8859-1")); out.println(no+sx); try { Class.forName(driverName); conn = DriverManager.getConnection(dburl, userName, userPwd); Statement stmt = conn.createStatement(); String s1 = "insert into WUZIXX values('"; s1 = s1 + no + "','" + nm + "','" + sx + "','" + ag + "','" + dp + "')"; out.println(s1+"cao!"); stmt.executeUpdate(s1); out.println("Thank you ca"); out.println("Connec是真的 Successful!"); } catch (Exception e) {out.println("connec草啊 error!"); //e.printStackTrace(); } out.println("Thank you "); out.println("Thank you !!"); } } 这是浏览器返回的 1232 connec草啊 error! Thank you Thank you !!

[身胖不怕影子歪]

那 web.xml里你配置了么 你咋访问的

[Defonds]

都抛异常了，还怎么持久化你的数据进入数据库？ 你的异常信息捕捉一下，贴一下看看