总结Jsp开发网站Word文档下载推荐.docx
- 文档编号:22678345
- 上传时间:2023-02-05
- 格式:DOCX
- 页数:23
- 大小:20.64KB
总结Jsp开发网站Word文档下载推荐.docx
《总结Jsp开发网站Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《总结Jsp开发网站Word文档下载推荐.docx(23页珍藏版)》请在冰豆网上搜索。
importjava.sql.SQLException;
importjava.sql.ResultSet;
publicclassConnectionManager
{
privatestaticfinalStringDERIVE="
com.microsoft.sqlserver.jdbc.SQLServerDriver"
;
privatestaticfinalStringURL="
jdbc:
sqlserver:
//localhost:
1433;
DatabaseName=数据库名字"
privatestaticfinalStringUSER="
sa"
privatestaticfinalStringPASS="
publicstaticConnectiongetConnection()
{
Connectioncon=null;
try{
Class.forName(DERIVE);
try{
con=DriverManager.getConnection(URL,USER,PASS);
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}catch(ClassNotFoundExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
returncon;
}
publicstaticvoidcloseAll(ResultSetrs,PreparedStatementps,Connectioncon)
if(rs!
=null)
{
rs.close();
if(ps!
ps.close();
if(con!
=null&
&
con.isClosed())
{
try{
con.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}catch(SQLExceptione){
}
impl包(实现接口代码)
创建实现接口代码时注意Add添加定义接口。
importjava.util.ArrayList;
importpany.dao.+接口名;
importpany.entity.+类名;
importpany.uitle.ConnectionManager;
privateConnectionconn=null;
privatePreparedStatementps=null;
privateResultSetrs=null;
publicintdelete+类名(类名n)throwsException
[publicintdelete+类名(intn)throwsException]
//TODOAuto-generatedmethodstub删除
intnum=0;
conn=ConnectionManager.getConnection();
Stringsql="
deletefromUsersWhereuID=?
"
ps=conn.prepareStatement(sql);
ps.setInt(1,usersID);
num=ps.executeUpdate();
}catch(RuntimeExceptione){
}finally
ConnectionManager.closeAll(rs,ps,conn);
returnnum;
publicintadd+类名(类名n)throwsException
//TODOAuto-generatedmethodstub增加
intnum=0;
try
con=ConnectionManager.getConnection();
Stringsql="
insertinto+表名values(?
?
)"
ps=con.prepareStatement(sql);
[
ps.setString(1,n.getUserName());
ps.setString(2,n.getPassword());
ps.setInt(3,n.getStatus());
]根据实际情况写
num=ps.executeUpdate();
catch(RuntimeExceptione)
finally
ConnectionManager.closeAll(rs,ps,conn);
returnnum;
publicintupdate+类名(类名n)throwsException
//TODOAuto-generatedmethodstub更新
数据库语句"
ps.setString(1,user.getPassword());
ps.setInt(2,user.getUserID());
publicListfind+类名()throwsException
//TODOAuto-generatedmethodstub查询
Newsn=null;
Listlist=newArrayList();
Stringsql="
select*fromNEWS"
conn=ConnectionManager.getConnection();
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next())
[
n=newNews();
n.setNewsID(rs.getInt
(1));
n.setTitle(rs.getString
(2));
n.setContent(rs.getString(3));
n.setWriterDate(rs.getString(4));
list.add(n);
]根据实际情况写
catch(RuntimeExceptione)
//TODOAuto-generatedcatchblock
e.printStackTrace();
finally
ConnectionManager.closeAll(rs,ps,conn);
returnlist;
publicNewsfindNewsByID(intid)throwsException
Newsnews=null;
//TODOAuto-generatedmethodstub但参数的查询
conn=ConnectionManager.getConnection();
Stringsql="
select*fromNewswherenewsID=?
ps=conn.prepareStatement(sql);
ps.setInt(1,id);
rs=ps.executeQuery();
while(rs.next())
[
news=newNews();
news.setNewsID(rs.getInt("
newsID"
));
news.setTitle(rs.getString("
title"
news.setContent(rs.getString("
content"
news.setWriterDate(rs.getString("
writerDate"
]根据实际情况写
finally
ConnectionManager.closeAll(rs,ps,conn);
returnnews;
显示页面类:
导入验证码JSP
<
%@pagecontentType="
image/jpeg"
import="
java.awt.*,java.awt.image.*,java.util.*,javax.imageio.*"
%>
%!
ColorgetRandColor(intfc,intbc){//给定范围获得随机颜色
Randomrandom=newRandom();
if(fc>
255)fc=255;
if(bc>
255)bc=255;
intr=fc+random.nextInt(bc-fc);
intg=fc+random.nextInt(bc-fc);
intb=fc+random.nextInt(bc-fc);
returnnewColor(r,g,b);
%>
%
//设置页面不缓存
response.setHeader("
Pragma"
"
No-cache"
);
Cache-Control"
no-cache"
response.setDateHeader("
Expires"
0);
//在内存中创建图象
intwidth=60,height=20;
BufferedImageimage=newBufferedImage(width,height,BufferedImage.TYPE_INT_RGB);
//获取图形上下文
Graphicsg=image.getGraphics();
//生成随机类
Randomrandom=newRandom();
//设定背景色
g.setColor(getRandColor(200,250));
g.fillRect(0,0,width,height);
//设定字体
g.setFont(newFont("
TimesNewRoman"
Font.PLAIN,18));
//画边框
//g.setColor(newColor());
//g.drawRect(0,0,width-1,height-1);
//随机产生155条干扰线,使图象中的认证码不易被其它程序探测到
g.setColor(getRandColor(160,200));
for(inti=0;
i<
155;
i++)
intx=random.nextInt(width);
inty=random.nextInt(height);
intxl=random.nextInt(12);
intyl=random.nextInt(12);
g.drawLine(x,y,x+xl,y+yl);
//取随机产生的认证码(4位数字)
//Stringrand=request.getParameter("
rand"
//rand=rand.substring(0,rand.indexOf("
."
StringsRand="
4;
i++){
Stringrand=String.valueOf(random.nextInt(10));
sRand+=rand;
//将认证码显示到图象中
g.setColor(newColor(20+random.nextInt(110),20+random.nextInt(110),20+random.nextInt(110)));
//调用函数出来的颜色相同,可能是因为种子太接近,所以只能直接生成
g.drawString(rand,13*i+6,16);
//将认证码存入SESSION
session.setAttribute("
sRand);
//图象生效
g.dispose();
//输出图象到页面
ImageIO.write(image,"
JPEG"
response.getOutputStream());
out.clear();
out=pageContext.pushBody();
实现验证码:
%@pagelanguage="
java"
java.util.*"
pageEncoding="
GBK"
%@pageimport="
pany.dao.*"
pany.dao.impl.*"
pany.entity.*"
request.setCharacterEncoding("
Stringname=request.getParameter("
uname"
Stringpass=request.getParameter("
upass"
Stringcheck=request.getParameter("
read"
Stringrand=(String)session.getAttribute("
//验证码取值
UsersDaousers=newUsersDaoImpl();
Usersus=newUsers();
us.setUserName(name);
us.setPassword(pass);
if(!
rand.equals(check))//验证码判断
session.setAttribute("
error"
验证码错误~!
request.getRequestDispatcher("
error.jsp"
).forward(request,response);
}else
{
if(users.selectUser(us)>
0)
session.setAttribute("
LONG"
us);
Listlist=newArrayList();
if(application.getAttribute("
)!
list=(List)application.getAttribute("
list.add(us);
application.setAttribute("
list);
response.sendRedirect("
Talking.jsp"
else
check"
输入信息错误~!
request.getRequestDispatcher("
四大(增删改查)Jsp页面
显示查询页面
导包
pany.impl.*"
<
tr>
TextDaono=newTextDaoImpl();
Listlist=no.findUsers();
for(inti=0;
list.size();
{
Usersnews=(Users)list.get(i);
%>
<
td>
%=news.getUsername()%>
/td>
(带Id的显示
ahref="
detailNews.jsp?
给一个值一般是ID名字小写=<
%=news.get+ID名字()%>
"
>
/a>
)
%=news.getPassword()%>
]根据实际情况修改
/tr>
%>
显示修改页面
显示增加页面
代码
request.setCharacterEncoding("
gbk"
UsersDaomanDao=newUsersDaoImpl();
Usersman=newUsers();
StringuserName=request.getParameter("
Name"
Stringuserpass=request.getParameter("
Pass"
//得到修改的值
man.setUName(userName);
man.setUPass(userpass);
if(userpass!
intcount=manDao.addUsers(man);
if(count>
0){
out.print("
scripttype='
text/javascript'
alert('
成功添加一名管理员。
'
location.replace('
rights.jsp'
/script>
}else{
添加失败。
history.go(-1);
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 总结 Jsp 开发 网站