| jsp留言本示例 |
|
来源：互联网 |
时间：2005-09-01 |
浏览：
相关评论 |
报告错误 |
发布文章
|
【字号：大 | 中 | 小】
【背景色 
 】
|
|
>
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 
欢迎在本站发布信息，在线投递稿件
我要投稿
打印本文
推荐本文
加入收藏
返回顶部
关闭窗口
