这是错
exception javax.servlet.ServletException: Servlet execution threw an exception
root cause java.lang.Error: Unresolved compilation problems:
Unhandled exception type ClassNotFoundException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException servlet.Reg.doPost(Reg.java:40)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
这是源代码
package servlet;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Reg extends HttpServlet { public Reg() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { String name=request.getParameter("name");
String psw=request.getParameter("psw");
String email=request.getParameter("email");
String psw1=request.getParameter("psw1");
String sql=new String();
response.setContentType("text/html");
request.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
try{
Connection con=getConnection();
Statement stmt=con.createStatement();
sql="insert into hy_info values('"+name+"','"+email+"','"+psw+"','')";
stmt.executeUpdate(sql);
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("<p>name:"+name+"</p>");
out.println("<p>psw:"+psw+"</p>");
out.println("<a href='denglu.jsp'>点击返回</a>");
out.println(" </BODY>");
out.println("</HTML>");
stmt.close();
con.close();
}catch(Exception e){}
out.flush();
out.close();
}
public void init() throws ServletException {
}
public Connection getConnection()
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:myDatabase","sa","");
}
catch(ClassNotFoundException e )
{
e.printStackTrace();
}
catch(SQLException e){ e.printStackTrace();}
return con;
}
}我是新手,没有多少分...谢谢各位了
exception javax.servlet.ServletException: Servlet execution threw an exception
root cause java.lang.Error: Unresolved compilation problems:
Unhandled exception type ClassNotFoundException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException
Unhandled exception type SQLException servlet.Reg.doPost(Reg.java:40)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
这是源代码
package servlet;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Reg extends HttpServlet { public Reg() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { String name=request.getParameter("name");
String psw=request.getParameter("psw");
String email=request.getParameter("email");
String psw1=request.getParameter("psw1");
String sql=new String();
response.setContentType("text/html");
request.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
try{
Connection con=getConnection();
Statement stmt=con.createStatement();
sql="insert into hy_info values('"+name+"','"+email+"','"+psw+"','')";
stmt.executeUpdate(sql);
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("<p>name:"+name+"</p>");
out.println("<p>psw:"+psw+"</p>");
out.println("<a href='denglu.jsp'>点击返回</a>");
out.println(" </BODY>");
out.println("</HTML>");
stmt.close();
con.close();
}catch(Exception e){}
out.flush();
out.close();
}
public void init() throws ServletException {
}
public Connection getConnection()
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:myDatabase","sa","");
}
catch(ClassNotFoundException e )
{
e.printStackTrace();
}
catch(SQLException e){ e.printStackTrace();}
return con;
}
}我是新手,没有多少分...谢谢各位了
解决方案 »
- set 中取LIST 的问题
- 最近学习J2EE,关于SQL注入的问题
- 为什么都乐而不疲的用struts+hibernate+spring
- 讨论一下框架和设计模式的概念?
- jsp中上传文件到FTP的问题~!分的多多。
- FusionCharts 双Y轴如何让0刻度线重合,保持在同一水平线上
- 一个函数问题(做用户管理时使用)
- 简单问题:servlet中用out.print输出中文为“乱码”如何解决,送分~~
- JSP如何从数据库中提取一个表完整的显示在页面中?
- update更新问题
- 青鸟小弟,请问用AJAX技术做的聊天室,一个页面发送 信息(Message),而另一个页面无法达到及时更新数据,当另一个页面发送数据的时候,才能更新数据!急求?
- 那位大牛可以提供LSA实现算法啊?
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
这一行代码报错,类装载发生错误。建议改为JDBC连接数据库。
import java.io.PrintWriter;
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Reg extends HttpServlet { public Reg() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { String name=request.getParameter("name");
String psw=request.getParameter("psw");
String email=request.getParameter("email");
String psw1=request.getParameter("psw1");
String sql=new String();
response.setContentType("text/html");
request.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
try{
Connection con=getConnection();
Statement stmt=con.createStatement();
sql="insert into hy_info values('"+name+"','"+email+"','"+psw+"','')";
stmt.executeUpdate(sql);
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("<p>name:"+name+"</p>");
out.println("<p>psw:"+psw+"</p>");
out.println("<a href='denglu.jsp'>点击返回</a>");
out.println(" </BODY>");
out.println("</HTML>");
stmt.close();
con.close();
}catch(Exception e){}
out.flush();
out.close();
}
public void init() throws ServletException {
}
public Connection getConnection()
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:myDatabase","sa","");
}
catch(ClassNotFoundException e )
{
e.printStackTrace();
}
catch(SQLException e){ e.printStackTrace();}
return con;
}
}
这个可以运行,不知道差在哪?
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
你使用odbc,但是没有找到jar包,无法加载该类.