81,092
社区成员
发帖
与我相关
我的任务
分享
import javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
import data.conndb;
public class noteServlet extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse
response)
{
String name=request.getParameter("name");
String subject=request.getParameter("subject");
String memo=request.getParameter("memo");
String sql;
sql="insert into note values("+"'"+name+"',"+"'"+subject+"',"+"'"+memo+"')";
conndb db=new conndb();
db.executeUpdate(sql);
}
public void doGet(HttpServletRequest request,HttpServletResponse response)
{
doPost(request,response);
}
}
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>留言板</title>
</head>
<body>
<div align="center">
<form action="noteServlet" method="post">
您的姓名:<input type="text" name="name" size="20"><br>
主题:<input type="text" name="subject" size="20"><br>
内容:<br>
<textarea name="memo" cols="15" rows="9">
</textarea><br>
<input type="submit" value="提交">
<input type="reset" value="重写">
</form>
</div>
</body>
</html>
package data;
import java.sql.*;
public class conndb {
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String ConStr="jdbc:odbc:wjh";
Connection connect =null;
ResultSet rs=null;
public conndb(){
try
{
Class.forName(DBDriver);
}catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}
public ResultSet executeQuety(String sql)
{
try {
connect = DriverManager.getConnection(ConStr);
Statement stmt=connect.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql)
{
int i=0;
try
{
connect=DriverManager.getConnection(ConStr);
Statement stmt=connect.createStatement();
i=stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return i;
}
}