| jsp留言本示例 |
|
来源：互联网 |
时间：2005-09-01 |
浏览：
相关评论 |
报告错误 |
发布文章
|
【字号：大 | 中 | 小】
【背景色 
 】
|
|
ic/5.gif" width="100" height="100"></div></td>
</tr>
<tr>
<td><div align="center">1</div></td>
<td><div align="center">2</div></td>
<td><div align="center">3</div></td>
<td><div align="center">4</div></td>
<td><div align="center">5</div></td>
</tr>
<tr>
<td><div align="center"><img src="pic/6.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/7.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/8.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/9.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/10.gif" width="100" height="100"></div></td>
</tr>
<tr>
<td><div align="center">6</div></td>
<td><div align="center">7</div></td>
<td><div align="center">8</div></td>
<td><div align="center">9</div></td>
<td><div align="center">10</div></td>
</tr>
<tr>
<td><div align="center"><img src="pic/11.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/12.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/13.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/14.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/15.gif" width="100" height="100"></div></td>
</tr>
<tr>
<td><div align="center">11</div></td>
<td><div align="center">12</div></td>
<td><div align="center">13</div></td>
<td><div align="center">14</div></td>
<td><div align="center">15</div></td>
</tr>
<tr>
<td><div align="center"><img src="pic/16.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/17.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/18.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/19.gif" width="100" height="100"></div></td>
<td><div align="center"><img src="pic/20.gif" width="100" height="100"></div></td>
</tr>
<tr>
<td><div align="center">16</div></td>
<td><div align="center">17</div></td>
<td><div align="center">18</div></td>
<td><div align="center">19</div></td>
<td><div align="center">20</div></td>
</tr>
<tr>
<td colspan="5"><div align="center"></div>
<div align="right"><a href="javascript:history.back();">返回</a></div>
<div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div>
<div align="right"></div></td>
</tr>
</table>
</body>
</html>
Data.java>>>>>>>>>>>>>>>>>>
package connection;
import java.sql.*;
public class Data
{
Connection conn;
public Connection getConn()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/txl?useUnicode=true&characterEncoding=gb2312","root","qlshzbk");
return conn;
}
catch(Exception ex)
{
ex.printStackTrace();
return null;
}
}
}
master.java>>>>>>>>>>>>>>>>>>>>>
package tools;
public class master
{
//网站首页
String wangzhanshouye="";
//网站简介
String wangzhanjianjie="";
//联系我们
String lianxiwomen="";
//关于我们
String guanyuwomen="";
//友情连接
String youqinglianjie="";
public String getWangzhanshouye()
{
return wangzhanshouye;
}
public String getWangzhanjianjie()
{
return wangzhanjianjie;
}
public String getLianxiwomen()
{
return lianxiwomen;
}
public String getGuanyuwomen()
{
return guanyuwomen;
}
public String getYouqinglianjie()
{
return youqinglianjie;
}
}
Servlet_edit.java
package tools;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import connection.Data;
import java.text.*;
import java.util.*;
public class Servlet_edit extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
Data data=new Data();
Connection conn;
Statement stme;
ResultSet rs;
String sname="",spass="",请不要发表含有不雅言语的内容="",stouxiang="",smail="",soicq="";
//Initialize global variables
public void init() throws ServletException
{
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
request.setCharacterEncoding("gb2312");
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
spass=request.getParameter("tpass1");
请不要发表含有不雅言语的内容=request.getParameter("请不要发表含有不雅言语的内容");
stouxiang=request.getParameter("ttouxiang");
smail=request.getParameter("tmail");
soicq=request.getParameter("toicq");
ServletContext sc=this.getServletContext();
HttpSession session=request.getSession();
try
{
conn=data.getConn();
stme=conn.createStatement();
stme.executeUpdate("update userinfo set userpass='"+spass+"',请不要发表含有不雅言语的内容='"+请不要发表含有不雅言语的内容+"',usermail='"+smail+"',useroicq='"+soicq+"',userhead='"+stouxiang+"' where username='"+session.getAttribute("loginname")+"'" );
closeConn();
session.setAttribute("chenggong","2");
sc.getRequestDispatcher("/chenggong.jsp").forward(request,response);
}
catch(Exception ex)
{
ex.printStackTrace();
closeConn();
sc.getRequestDispatcher("/edit.jsp").forward(request,response);
}
}
public void closeConn()
{
try
{
conn.close();
stme.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
//Clean up resources
public void destroy()
{
}
}
Servlet_login.java>>>>>>>>>>>>>>>>>>>>>>
package tools;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import connection.Data;
import java.sql.SQLException;
public class Servlet_login extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=gb2312";
Data data=new Data();
Connection conn;
Statement stme;
Statement stme2;
ResultSet rs;
ResultSet rs2;
String sname;
String spass;
//Initialize global variables
public void init() throws ServletException
{
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
request.setCharacterEncoding("gb2312");
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
ServletContext sc=this.getServletContext();
HttpSession session=request.getSession();
sname=request.getParameter("tname");
spass=request.getParameter("tpass");
try
{
conn=data.getConn();
stme=conn.createStatement();
rs=stme.executeQuery("select * from userinfo where username='"+sname.trim()+"' and userpass= '"+spass.trim()+"' and userflag=1");
if(rs.next())
{
session.setAttribute("loginname",sname);
closeConn();
sc.getRequestDispatcher("/index.jsp").forward(request,response);
}
else
{
stme2=conn.createStatement();
rs2=stme2.executeQuery("select * from userinfo where username='"+sname.trim()+"' and userpass= '"+spass.trim()+"' and userflag=3");
if(rs2.next())
{
session.setAttribute("loginname",sname);
session.setAttribute("adminname","3");
stme2.close();
sc.getRequestDispatcher("/index.jsp").forward(request,response);
}
else
{
session.setAttribute("error" ,"2");
closeConn();
sc.getRequestDispatcher("/error.jsp").forward(request ,
response);
}
}
}
catch(Exception ex)
{
ex.printStackTrace();
closeConn();
sc.getRequestDispatcher("/index.jsp").forward(request,response);
}
}
public void closeConn()
{
try
{
conn.close();
stme.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
//Clean up resources
public void destroy()
{
}
}
Servlet_post.java
package tools;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.util.*;
import java.text.*;
import java.sql.*;
import connection.*;
public class Servlet_post extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=gb2312";
Connection conn;
Statement stme;
ResultSet rs;
Data data=new Data();
String snr="";
String sbt="";
//Initialize global variables
public void init() throws ServletException
{
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
response.setContentType(CONTENT_TYPE);
request.setCharacterEncoding("gb2312");
PrintWriter out = response.getWriter();
java.util.Date newDate=new java.util.Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd:HH:mm:ss");
String date=sdf.format(newDate);
sbt=request.getParameter("tbt");
snr=request.getParameter("tnr");
//取得session对象
HttpSession session=request.getSession();
//取得servletContext对象
ServletContext sc=this.getServletContext();
if(session.getAttribute("loginname")!=null)
{
//没有输入用户名，提前登陆了
try
{
String tempname = (String)session.getAttribute("loginname");
conn=data.getConn();
stme = conn.createStatement();
stme.executeUpdate(
"insert into lyxx(lyuser,lybt,lynr,lydate) values ('" +
tempname + "','" + sbt + "','" + snr + "','" + date + "') ");
closeConn();
sc.getRequestDispatcher("/show.jsp").forward(request,response);
}
catch(Exception ex)
{
ex.printStackTrace();
closeConn();
}
}
else
{
//以前没有登陆，输入用户名登陆的
String sname=request.getParameter("tname");
String spass=request.getParameter("tpass");
try
{
conn=data.getConn();
stme = conn.createStatement();
rs = stme.executeQuery(
"select * from userinfo where username='" + sname +
"'and userpass='" + spass + "'");
if(rs.next())
{
//可以找到用户,添加留言信息
session.setAttribute("loginname",sname);
stme.executeUpdate("insert into lyxx(lyuser,lybt,lynr,lydate) values ('" +
sname + "','" + sbt + "','" + snr + "','" + date + "') ");
closeConn();
sc.getRequestDispatcher("/show.jsp").forward(request,response);
}
else
{
session.setAttribute("error","3");
closeConn();
sc.getRequestDispatcher("/error.jsp").forward(request,response);
}
}
catch(Exception ex)
{
closeConn();
ex.printStackTrace();
}
}
}
public void closeConn()
{
try
{
conn.close();
stme.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
//Clean up resources
public void destroy()
{
}
}
Servlet_reg.java>>>>>>>>>>>>>>
package tools;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import connection.Data;
import java.text.*;
import java.util.*;
public class Servlet_reg extends HttpServlet
{
Data data=new Data();
Connection conn;
Statement stme;
ResultSet rs;
String sname="",spass="",请不要发表含有不雅言语的内容="",stouxiang="",smail="",soicq="";
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException
{
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
request.setCharacterEncoding("gb2312");
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
sname=request.getParameter("tname");
spass=request.getParameter("tpass1");
请不要发表含有不雅言语的内容=request.getParameter("请不要发表含有不雅言语的内容");
stouxiang=request.getParameter("ttouxiang");
smail=request.getParameter("tmail");
soicq=request.getParameter("toicq");
ServletContext sc=this.getServletContext();
HttpSession session=request.getSession();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
java.util.Date newDate=new java.util.Date();
String date_s=sdf.format(newDate);
try
{
conn=data.getConn();
stme=conn.createStatement();
rs=stme.executeQuery("select * from userinfo where username='"+sname+"'");
if(rs.next())
{
session.setAttribute("error","1");
closeConn();
sc.getRequestDispatcher("/error.jsp").forward(request,response);
}
else
{
stme.executeUpdate("insert into userinfo(username,userpass,请不要发表含有不雅言语的内容,usermail,useroicq,userdate,userhead) values ('"+sname+"','"+spass+"','"+请不要发表含有不雅言语的内容+"','"+smail+"','"+soicq+"','"+date_s+"','"+stouxiang+"')");
session.setAttribute("loginname",sname);
closeConn();
session.setAttribute("chenggong","1");
sc.getRequestDispatcher("/chenggong.jsp").forward(request,response);
}
}
catch(Exception ex)
{
ex.printStackTrace();
closeConn();
sc.getRequestDispatcher("/reg.jsp").forward(request,response);
}
}
public void closeConn()
{
try
{
conn.close();
stme.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
//Clean up resources
public void destroy()
{
}
}
Data.java是在包connection里建的，其余的java文件是在tools包里的
大家用的时候别弄错了
|
| 分页 [1] [2] [3] [4] [5] |
|
 |
| |
|
|
|
|
收 藏
投 稿
繁 体
RSS 
欢迎在本站发布信息，在线投递稿件
我要投稿
打印本文
推荐本文
加入收藏
返回顶部
关闭窗口
