MVC实现增删改查的小例子Word格式.docx
- 文档编号:16773364
- 上传时间:2022-11-26
- 格式:DOCX
- 页数:19
- 大小:18.21KB
MVC实现增删改查的小例子Word格式.docx
《MVC实现增删改查的小例子Word格式.docx》由会员分享,可在线阅读,更多相关《MVC实现增删改查的小例子Word格式.docx(19页珍藏版)》请在冰豆网上搜索。
%
Stringsql="
select*fromstudentorderbyid"
;
java.util.Listlist=sBean.getSearch(sql);
for(Iteratorit=list.iterator();
it.hasNext();
){
//获得JavaBean的一个对象
jBean=(com.jq92.bean.JavaBean)it.next();
%>
<
%=jBean.getId()%>
%=jBean.getName()%>
%=jBean.getPassword()%>
%=jBean.getSex()%>
%=jBean.getAge()%>
ahref="
Delete?
id=<
"
>
删除<
/a>
&
nbsp;
SearchById?
更新<
}
%>
/table>
Insert.jsp"
返回<
/body>
Update.jsp
<
fontsize="
7"
color="
red"
您要更新的数据如下:
formaction="
Update"
method="
post"
tableborder="
1"
<
Id:
inputname="
id"
value="
%=request.getAttribute("
)%>
readonly>
姓名:
name"
密码:
inputtype="
password"
name="
性别:
radio"
sex"
男"
man"
男
女"
woman"
女
年龄:
text"
age"
tdcolspan="
2"
submit"
更新"
reset"
重置"
/form>
SearchList.jsp"
查询<
Insert.jsp
92期学院管理页面<
Insert"
提交"
Error.jsp
对不起,您<
error"
失败
Servlet部分
Update.java
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
//获得前台表单信息
Stringsid=request.getParameter("
);
intid=Integer.parseInt(sid);
Stringname=request.getParameter("
Stringpassword=request.getParameter("
Stringsex=request.getParameter("
StringSage=request.getParameter("
intage=Integer.parseInt(Sage);
//封装到JavaBean对象中去
JavaBeanjBean=newJavaBean();
jBean.setId(id);
jBean.setName(name);
jBean.setPassword(password);
jBean.setSex(sex);
jBean.setAge(age);
updatestudentsetname=?
password=?
sex=?
age=?
whereid=?
SqlBeansBean=newSqlBean();
intcount=sBean.getUpdate(sql,jBean);
Stringurl="
if(count>
0){
url="
else{
Error.jsp"
request.setAttribute("
"
更新"
request.getRequestDispatcher(url).forward(request,response);
}
SearchById.java
//获得id
select*fromstudentwhereid=?
JavaBeanjBean=sBean.getSearchById(sql,id);
//ID
request.setAttribute("
jBean.getId());
//姓名
jBean.getName());
//密码
jBean.getPassword());
//性别
Stringsex="
Stringman="
Stringwoman="
if(jBean.getSex()!
=null){
sex=jBean.getSex().trim();
if(sex.equals("
)){
man="
checked"
}
else{
woman="
man);
woman);
//年龄
jBean.getAge());
//转发
request.getRequestDispatcher("
Update.jsp"
).forward(request,response);
Insert.java
throwsServletException,IOException{
//获取前台页面信息
//封装到JavaBean对象中
com.jq92.bean.JavaBeanjBean=newcom.jq92.bean.JavaBean();
//调用模型层
insertintostudentvalues(?
?
)"
intcount=sBean.getInsert(sql,jBean);
"
注册"
Delete.java
//获得删除超链接传来的参数
StringsId=request.getParameter("
intid=Integer.parseInt(sId);
//调用模型层删除方法
deletefromstudentwhereid=?
intcount=sBean.getDelete(sql,id);
删除"
JavaBean.java
packagecom.jq92.bean;
publicclassJavaBean{
privateintid;
privateStringname;
privateStringpassword;
privateStringsex;
privateintage;
publicintgetAge(){
returnage;
publicvoidsetAge(intage){
this.age=age;
publicintgetId(){
returnid;
publicvoidsetId(intid){
this.id=id;
publicStringgetName(){
returnname;
publicvoidsetName(Stringname){
this.name=name;
publicStringgetPassword(){
returnpassword;
publicvoidsetPassword(Stringpassword){
this.password=password;
publicStringgetSex(){
returnsex;
publicvoidsetSex(Stringsex){
this.sex=sex;
}
SqlBean.java
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.util.ArrayList;
importjava.util.List;
publicclassSqlBean{
Connectioncon;
PreparedStatementpre;
ResultSetrs;
publicSqlBean(){
try{
Class.forName("
com.microsoft.jdbc.sqlserver.SQLServerDriver"
}catch(ClassNotFoundExceptione){
//TODO自动生成catch块
e.printStackTrace();
con=DriverManager.getConnection("
jdbc:
microsoft:
sqlserver:
//localhost:
1433;
DatabaseName=jq92Model2"
sa"
}catch(SQLExceptione){
publicintgetInsert(Stringsql,JavaBeanjBean){
intcount=0;
pre=con.prepareStatement(sql);
pre.setString(1,jBean.getName());
pre.setString(2,jBean.getPassword());
pre.setString(3,jBean.getSex());
pre.setInt(4,jBean.getAge());
count=pre.executeUpdate();
finally{
try{
pre.close();
con.close();
}catch(SQLExceptione){
//TODO自动生成catch块
e.printStackTrace();
returncount;
publicintgetDelete(Stringsql,intid){
pre.setInt(1,id);
publicJavaBeangetSearchById(Stringsql,intid){
rs=pre.executeQuery();
while(rs.next()){
jBean.setId(rs.getInt("
));
jBean.setName(rs.getString("
jBean.setPassword(rs.getString("
jBean.setSex(rs.getString("
jBean.setAge(rs.getInt("
returnjBean;
publicintgetUpdate(Stringsql,JavaBeanjBean){
pre.setString(2,jBean.getPassword());
pre.setInt(5,jBean.getId());
publi
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- MVC 实现 增删 例子