这个例子包括CreateAccountServlet.java和web.xml
老是调试不出来,请高手帮忙调试一下。
1、CreateAccountServlet.javaimport javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;public class CreateAccountServlet extends HttpServlet
{
private String URL1;
private String user;
private String password;
public void init() throws ServletException
{
ServletContext sc=getServletContext();
String driverClass=sc.getInitParameter("driverClass");
URL1=sc.getInitParameter("url");
user=sc.getInitParameter("user");
password=sc.getInitParameter("password");
try
{
Class.forName(driverClass);
}
catch(ClassNotFoundException ce)
{
throw new UnavailableException("加载数据库驱动失败!");
}
}
public void doGet(HttpServletRequest req,HttpServletResponse resp)
throws ServletException,IOException
{
Connection conn=null;
Statement stmt=null;
PreparedStatement pstmt=null;
try
{
conn=DriverManager.getConnection(URL1,user,password);
stmt=conn.createStatement();
stmt.executeUpdate("create table account(userid varchar(10) not null primary key,balance FLOAT(6,2))ENGINE=InnoDB");
pstmt=conn.prepareStatement("insert account values(?,?)");
pstmt.setString(1,"甲");
pstmt.setFloat(2,500.00f);
pstmt.executeUpdate();
pstmt.setString(1,"乙");
pstmt.setFloat(2,200.00f);
pstmt.executeUpdate();
PrintWriter out=resp.getWriter();
out.println("success");
out.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
finally
{
if(stmt!=null)
{
try
{
stmt.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
stmt=null;
}
if(pstmt!=null)
{
try
{
pstmt.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
pstmt=null;
}
if(conn!=null)
{
try
{
conn.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
conn=null;
}
}
}
}
2、web.xml
<?xml version="1.0" encoding="gb2312"?><web-app xmlns=""
xmlns:xsi=""
xsi:SchemaLocation=""
version="2.4">
<context-param>
<param-name>driverClass</param-name>
<param-value>com.microsoft.jdbc.sqlserver.SQLServerDriver</param-value>
</context-param>
<context-param>
<param-name>url</param-name>
<param-value>jdbc:microsoft:sqlserver://localhost:1433;databasename=testdb</param-value>
</context-param>
<context-param>
<param-name>user</param-name>
<param-value>sa</param-value>
</context-param>
<context-param>
<param-name>password</param-name>
<param-value>qazwsx</param-value>
</context-param>
<servlet>
<servlet-name>CreateAccountServlet</servlet-name>
<servlet-class>CreateAccountServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>CreateAccountServlet</servlet-name>
<url-pattern>/account</url-pattern>
</servlet-mapping>
</web-app>
老是调试不出来,请高手帮忙调试一下。
1、CreateAccountServlet.javaimport javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;public class CreateAccountServlet extends HttpServlet
{
private String URL1;
private String user;
private String password;
public void init() throws ServletException
{
ServletContext sc=getServletContext();
String driverClass=sc.getInitParameter("driverClass");
URL1=sc.getInitParameter("url");
user=sc.getInitParameter("user");
password=sc.getInitParameter("password");
try
{
Class.forName(driverClass);
}
catch(ClassNotFoundException ce)
{
throw new UnavailableException("加载数据库驱动失败!");
}
}
public void doGet(HttpServletRequest req,HttpServletResponse resp)
throws ServletException,IOException
{
Connection conn=null;
Statement stmt=null;
PreparedStatement pstmt=null;
try
{
conn=DriverManager.getConnection(URL1,user,password);
stmt=conn.createStatement();
stmt.executeUpdate("create table account(userid varchar(10) not null primary key,balance FLOAT(6,2))ENGINE=InnoDB");
pstmt=conn.prepareStatement("insert account values(?,?)");
pstmt.setString(1,"甲");
pstmt.setFloat(2,500.00f);
pstmt.executeUpdate();
pstmt.setString(1,"乙");
pstmt.setFloat(2,200.00f);
pstmt.executeUpdate();
PrintWriter out=resp.getWriter();
out.println("success");
out.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
finally
{
if(stmt!=null)
{
try
{
stmt.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
stmt=null;
}
if(pstmt!=null)
{
try
{
pstmt.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
pstmt=null;
}
if(conn!=null)
{
try
{
conn.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
conn=null;
}
}
}
}
2、web.xml
<?xml version="1.0" encoding="gb2312"?><web-app xmlns=""
xmlns:xsi=""
xsi:SchemaLocation=""
version="2.4">
<context-param>
<param-name>driverClass</param-name>
<param-value>com.microsoft.jdbc.sqlserver.SQLServerDriver</param-value>
</context-param>
<context-param>
<param-name>url</param-name>
<param-value>jdbc:microsoft:sqlserver://localhost:1433;databasename=testdb</param-value>
</context-param>
<context-param>
<param-name>user</param-name>
<param-value>sa</param-value>
</context-param>
<context-param>
<param-name>password</param-name>
<param-value>qazwsx</param-value>
</context-param>
<servlet>
<servlet-name>CreateAccountServlet</servlet-name>
<servlet-class>CreateAccountServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>CreateAccountServlet</servlet-name>
<url-pattern>/account</url-pattern>
</servlet-mapping>
</web-app>
解决方案 »
- 关于网络
- 关于session有效期设置的问题
- Socket连接的时候如何keep-alive,是不是需要服务器支持?
- 在eclipse下开发jsp,大家是怎么调试的?
- 我的JSP代码抛出java.lang.UnsupportedOperationException怎么回事?
- 请问什么地方能申请到免费的JSP空间,带数据库的
- 怎样使table表格中的各个单元格能够进行编辑?
- 下载数据自动保存到指定位置.
- 高分求助:JSP+TOMCAT+SQLSERVER的配置问题....
- 谁能告诉我JSP中怎样使用类??先谢谢了
- 请问这个问题有什么办法可以实现呢?用Javascript好像不能实现。
- 一个JSP的一个条件判断的小问题!
pstmt=conn.prepareStatement("insert account values(?,?)");
”
请问哪里错了?