求助简单问题

qczl1224 2005-08-09 04:43:03

我用的JBuilder2005开发

HTM加载servlet JAVA类代码。。

<form action="/servlet/Create" method="POST">
<b>建立表格</b>
<input type="submit" value="建立表格">

Create.java

package jfbooks;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.Properties;

public class Create extends HttpServlet {
private Connection con = null;
public void init(ServletConfig config) throws ServletException {
super.init(config);
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Properties sysProps = new Properties();
sysProps.put("user", "jbuser");
sysProps.put("password", "abc");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:chenbo", sysProps);
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();
}

}

public void doGet(HttpServletRequest req,
HttpServletResponse res) throws ServletException,
IOException {
String sql =
"CREATE TABLE bookTab(" +
"bookId LONG CONSTRAINT bookIndex PRIMARY KEY," +
"bookTirle char(36)NULL," +
"bookAuthor char(20)NULL," +
"bookPrice SINGLE);";
//
res.setContentType("text/html");
ServletOutputStream sos = res.getOutputStream();
PrintWriter out = new PrintWriter(sos, true);
out.println("<HTML><HEAD><TITLE>Create</TITLE></HEAD>");
out.println("<BODY>");
SqlResult result = new SqlResult(con, sql);
out.println(result);
out.println("</BODY></HTML>");
}

public void destroy() {
try {
if (con != null) {
con.close();
}
} catch (SQLException ignored) {}
}

public void doPost(HttpServletRequest req,
HttpServletResponse res) throws ServletException,
IOException {
doGet(req, res);
}

private void jbInit() throws Exception {
}

}

请问要怎样部署web.xml 这个servlet/Create才可以用
？

...全文

53 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

giant216 2005-08-09

打赏
举报

web.xml中加入:
<servlet-mapping>
<servlet-name>Create</servlet-name>
<url-pattern>servlet/Create</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>Create</servlet-name>
<url-pattern>/Create</url-pattern>
</servlet-mapping>