- 1PS提示：因为图层已锁定，无法编辑图层的处理方法
- 2picacg苹果版怎么找不到|picacg ios版是不是下架了介绍
- 3Adobe Illustrator CS5 序列号大全
- 4ACDsee注册码免费分享（含ACDsee18、ACDsee10等版本）
- 5Potato(土豆聊天)怎么换头像|Potato app更改头像方法介绍
- 6PDF浏览器能看3D文件吗？PDF浏览器看3D文件图文详细教程
- 7Potato(马铃薯聊天)怎么注册不了|Potato不能注册处理方法介绍
- 8最新的Adobe Illustrator CS4序列号大全
- 9Intel i7-9700K性能跑分曝光：同代提升约12%
- 10XP系统怎么清除缓存？
- 11Intel Z390主板有望10月8日公布：8核9代酷睿随后登场
- 12XP系统安装chrome无法找到入口怎么处理？
[摘要]注:过去不会用mvc，经过摸索终于明白了，自己写了个例子，献给那些迷茫的java爱好者！！前提：我用的sql2k,database:clear,table:testbean(newid(int),n...
注:过去不会用mvc，经过摸索终于明白了，自己写了个例子，献给那些迷茫的java爱好者！！前提：
我用的sql2k,database:clear,table:testbean(newid(int),name(char),addr(char))
容器用的tomcat
//
test.jsp:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<body>
<center>
<%=(String)request.getAttribute("alert")!=null?(String)request.getAttribute("alert"):""
%>
<p>
<p>
<form name=f method="post" action="/servlet/FirstBean?req=no">
号码:<input type=text name=deleteno size=4>
<br>
<input type=submit>
</form>
</center>
<body>
//bean:CheckNo
package bean;
import java.sql.*;
public class CheckNo
{
private int no;
int val;
//
public void setNo(int no){
this.no=no;
}
//
public int getNo(){
return no;
}
//
public int execdelete() throws ClassNotFoundException,SQLException{
String con="delete from beantest where newid="+no;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url2="jdbc:microsoft:sqlserver://192.168.0.3:1433;DataBaseName=clear";
String user="sa";
String password="pft";
Connection conn= DriverManager.getConnection(url2,user,password);
Statement st=conn.createStatement();
val=st.executeUpdate(con);
st.close();
conn.close();
return val;
}
}
//servlet:FirstBean
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
import bean.*;
public class FirstBean extends HttpServlet {
//定义全局变量
int theno;
//init
public void init() throws ServletException {
super.init();
}
//doget
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String req = request.getParameter("req");
if(req==null){redirect(request,response,"test.jsp");}
}
//dopost
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try{
String req = request.getParameter("req");
if(req==null){redirect(request,response,"test.jsp");}
else if(req.equals("no")){
theno=Integer.parseInt(request.getParameter("deleteno"));
begin(request,response);
}
}catch(Exception e){
System.out.print(e.toString());
}
}
//begin
public void begin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
try{
CheckNo cn=new CheckNo();
cn.setNo(theno);
int val=cn.execdelete();
if(val==1){
//System.out.print("successful!");
request.setAttribute("alert","删除成功");
redirect(request,response,"test.jsp");
}
else{
//System.out.print("Failed!");
request.setAttribute("alert","删除失败");
redirect(request,response,"test.jsp");
}
}catch(Exception e){
System.out.print(e.toString());
}
}
//redirect
public void redirect(HttpServletRequest request, HttpServletResponse response, String directory) throws ServletException, IOException {
RequestDispatcher redirectory = getServletContext().getRequestDispatcher("/mail/" + directory);
redirectory.forward(request,response);
}
}
//目录结构
root
test.jsp
web-inf
classes
bean
FirstBean.class
推荐资讯 总人气榜
最新教程 本月人气
- 1苹果手机信息内最近联系人下文清除方法
- 23星galaxy s6 edge自动旋转失灵处理方法
- 3小米手机怎么定时发短信 小米手机定时发短信设置图文说明教程
- 4小米手机怎么定时开关机 小米手机定时开关机设置流程图
- 5华为p8max上市时间 华为p8max多少钱
- 6华为p8max手机怎么 华为p8max参数设置
- 7一号快车app官方版下载地址 一号快车app下载网址
- 8乐视手机1/1pro与乐max哪一个好？乐1/1pro/max比较评测视频
- 9手机电池容量怎么校正 手机电池容量校正方法
- 103星tizen z2廉价手机价格多少 3星tizen z2什么时候出
- 113星tizen z2廉价手机设置曝光 3星tizen z2参数设置介绍
- 12魅族mx3升级flyme4.1图文说明教程及注意事项(附flyme4.1固件官方版下载)
