📄 9.txt
字号:
catch(Exception e)
{
}
return "null";
}
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb239">
</head>
<body bgcolor="#FFFFFF">
<%
String id;
id=request.getParameter("id");
String sql;
sql="select * from inbox where id="+id;
ResultSet RS;
RS=userBean.executeQuery(sql);
if(RS.next())
{
%>
<table width="75%" border="1">
<tr>
<td width="30%">
<div align="right">发件人：</div>
</td>
<td width="70%"> <%=RS.getString("fromID")%> </td>
</tr>
<tr>
<td width="30%">
<div align="right">标题：</div>
</td>
<td width="70%"> <%=RS.getString("title")%> </td>
</tr>
<tr>
<td width="30%">
<div align="right">内容：</div>
</td>
<td width="70%"> <%=RS.getString("content")%> </td>
</tr>
<tr>
<td width="30%">
<div align="right">附件：</div>
</td>
<%
String fj;
fj=RS.getString("fujian");
%>
<td width="70%"> <a href="upload/<%=fj%>"><%=fj%></a> </td>
</tr>
<tr>
<td colspan="2">
<div align="center"></div>
</td>
</tr>
</table>
<%
}
RS.close();
%>
</body>
</html>
例程9-16
<%@ page contentType="text/html;charset=gb239" %>
<%@page language="java" import="java.sql.*"%>
<jsp:useBean id="userBean" scope="page" class="WebMail.conn"/>
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
}
return "null";
}
%>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<table align="center" border="0" width="760" cellspacing="0" cellpadding="0" height="355">
<tr>
<td width="150" height="355" valign="top">
</td>
<td width="10" height="100%"></td>
<td width="1" height="100%" bgcolor="#3399ff"></td>
<td width="10" height="100%"></td>
<td width="589" height="331" valign="top" background="images/bg1.gif">
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="307">
<tr>
<td width="100%" colspan="2" height="20" bgcolor="#3399ff"> <font color="#ffffff">修改密码</font>
</td>
</tr>
<form action="editpass_ok.jsp" method="post">
<tr><td align="right" height="32" width="40%">登录名：</td>
<td>
<%=session.getAttribute("username")%>
</td>
</tr>
<tr>
<td align="right" height="32">旧密码：</td>
<td>
<input type="text" name="oldpass">
</td>
</tr>
<tr>
<td align="right" height="32">新密码：</td>
<td>
<input type="text" name="newpass">
</td>
</tr>
<tr>
<td align="right" height="32">确认新密码：</td>
<td>
<input type="text" name="cfmnewpass">
</td>
</tr>
<tr> <td colspan="2" align="center">
<input type="submit" value="修改密码" name="editpass">
</td>
</tr>
</form>
<tr>
<td colspan="2" height="150" align="right"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
例程9-17
package WebMailservlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class login extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void init() throws ServletException {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
String sConnStr = "jdbc:odbc:WebMail";
Connection connect = null;
ResultSet rs = null;
rs = null;
try {
connect = DriverManager.getConnection(sConnStr);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
e.printStackTrace();
}
return "null";
}
/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<font color=\"green\">");
out.println("<p>The servlet get method is the reply.</p>");
out.println("</font>");
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>login</title></head>");
out.println("<body>");
out.println("</body></html>");
String logname,logpass;
boolean loginAttempt = false;
boolean loginOK = false;
String errorMessage = "请您登陆";
HttpSession session=request.getSession(true);
if(request.getParameterValues("login") != null
&&request.getParameterValues("logname") != null
&&request.getParameterValues("logpass") != null)
{
loginAttempt = true;
}
if (loginAttempt)
{
logname=request.getParameter("logname");
logpass=request.getParameter("logpass");
logname=getStr(logname);
logpass=getStr(logpass);
String sql="select * from member where logname='"+logname+"' and password='"+logpass+"'";
out.println(sql);
ResultSet RS=executeQuery(sql);
int rowscount=0;
try
{
while(RS.next())
{
rowscount++;
}
}
catch(Exception e)
{
e.printStackTrace();
}
//count.........
out.println(rowscount);
if(rowscount!=0)
{
errorMessage="成功登陆";
session.setAttribute("username",logname);
loginOK=true;
if(loginOK){
response.sendRedirect("../WebMail_sev/main.jsp");
}
}else{
errorMessage="loginerr";
session.setAttribute("username","");
response.sendRedirect("../WebMail_sev/login.jsp?err="+errorMessage);
}
}
}
/**Clean up resources*/
public void destroy() {
}
}
例程9-18
package WebMailservlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class reg extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void init() throws ServletException {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
String sConnStr = "jdbc:odbc:WebMail";
Connection connect = null;
ResultSet rs = null;
rs = null;
try {
connect = DriverManager.getConnection(sConnStr);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
e.printStackTrace();
}
return "null";
}
/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>reg</title></head>");
out.println("<body>");
out.println("<p>The servlet has received a GET. This is the reply.</p>");
out.println("</body></html>");
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>reg</title></head>");
out.println("<body>");
String logname,realname,passwd1,passwd2,email,gender,phone;
String problem,answer,province,education,selfintro,hobby;
String[] hobbies;
boolean regAttempt = false;
String errorMessage = "";
HttpSession session=request.getSession(true);
//必须填写的项目
logname=request.getParameter("logname");
realname=request.getParameter("realname");
passwd1=request.getParameter("passwd1");
passwd2=request.getParameter("passwd2");
email=request.getParameter("email");
gender=request.getParameter("Gender");
//非必须填写的项目
phone=request.getParameter("phone");
if(phone.trim().equals("")){
phone=null;
}
problem=request.getParameter("problem");
if(problem.trim().equals("")){
problem=null;
}
answer=request.getParameter("answer");
if(answer.trim().equals("")){
answer=null;
}
province=request.getParameter("Province");
if(province.trim().equals("")){
province=null;
}
education=request.getParameter("education");
if(education.trim().equals("")){
education=null;
}
hobbies=request.getParameterValues("hobbies");
hobby="";
if(hobbies!=null){
for (int i=0;i<hobbies.length;i++){
hobby=hobby+hobbies[i];
}
}else hobby="null";
selfintro=request.getParameter("selfintro");
if(selfintro.trim().equals("")){
selfintro=null;
}
///转换中文
logname=getStr(logname);
realname=getStr(realname);
passwd1 =getStr(passwd1);
email=getStr(email);
gender =getStr(gender);
phone =getStr(phone);
problem =getStr(problem);
answer =getStr(answer);
province =getStr(province);
education=getStr(education);
hobby=getStr(hobby);
selfintro=getStr(selfintro);
String sql="select ID from member where logname='"+logname+"'";
ResultSet RS=executeQuery(sql);
out.println(sql);
int rowscount=0;
try
{
while(RS.next())
{
rowscount++;
}
}
catch(Exception e)
{
}
//count.........
// out.println(rowscount);
if(rowscount==0)
{
regAttempt=true;
}else response.sendRedirect("../WebMail_sev/error.jsp");
if(regAttempt==true)
{
String sqlinsert="insert into member(logname,realname,password,email,gender,phone,problem,answer,province,education,hobbies,selfintro) Values('"+logname+"','"+realname+"','"+passwd1+"','"+email+"','"+gender+"','"+phone+"','"+problem+"','"+answer+"','"+province+"','"+education+"','"+hobby+"','"+selfintro+"')";
out.println(sqlinsert);
executeQuery(sqlinsert);
session.setAttribute("username",logname);
response.sendRedirect("../WebMail_sev/main.jsp");
}
out.println("</body></html>");
}
/**Clean up resources*/
public void destroy() {
}
}
例程9-19
package WebMailservlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class findpwd extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void init() throws ServletException {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
String sConnStr = "jdbc:odbc:WebMail";
Connection connect = null;
ResultSet rs = null;
rs = null;
try {
connect = DriverManager.getConnection(sConnStr);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
}
return "null";
}
/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>findpwd</title></head>");
out.println("<body>");
out.println("<p>The servlet has received a GET. This is the reply.</p>");
out.println("</body></html>");
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>findpwd</title></head>");
out.println("<body>");
out.println(" <table border=0 width=100% cellspacing=0 cellpadding=0 height=> ");
out.println(" <tr> ");
out.println("<td width=100% height=20 bgcolor=#3399ff> <font color=#ffffff>取回密码</font>");
out.println("</td>");
out.println("</tr>");
String logname,email;
boolean loginAttempt = false;
String errorMessage = "";
if(request.getParameterValues("findpass") != null
&&request.getParameterValues("logname") != null
&&request.getParameterValues("email") != null)
{
loginAttempt = true;
}
if (loginAttempt)
{
logname=request.getParameter("logname");
email=request.getParameter("email");
logname=getStr(logname);
email=getStr(email);
String sql="select * from member where logname='"+logname+"' and email='"+email+"'";
//out.println(sql);
ResultSet RS=executeQuery(sql);
int rowscount=0;
try
{
while(RS.next())
{
rowscount++;
errorMessage=RS.getString("password");
}
}
catch(Exception e)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -