📄 9.txt
字号:
例程9-1
package WebMail;
import java.sql.*;
public class conn {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:WebMail";
Connection connect = null;
ResultSet rs = null;
public conn() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
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;
}
}
例程9-2
<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="login_ok.jsp" method="post">
<tr><td align="right" height="32" width="40%">名字：</td>
<td>
<input type="hidden" name="returl" value="">
<input type="text" name="logname" value="">
</td>
</tr>
<tr>
<td align="right" height="32">密码：</td>
<td>
<input type="password" name="logpass">
</td>
</tr>
<tr>
<td align="center" colspan="2" height="32"> |
<a href="findpass.jsp">密码忘了，找一下</a> |
<a href="reg.jsp">注册新用户</a> |
<input type="submit" name="login" value="登录!">
</td>
</tr>
</form>
<tr>
<td colspan="2" align="right"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
例程9-3
<%@ 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";
}
%>
<%!
String logname,logpass;
boolean loginAttempt = false;
boolean loginOK = false;
String errorMessage = "请您登陆";
%>
<%
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=userBean.executeQuery(sql);
int rowscount=0;
try
{
while(RS.next())
{
rowscount++;
}
}
catch(Exception e)
{
}
//count.........
// out.println(rowscount);
if(rowscount!=0)
{
errorMessage="成功登陆";
session.setAttribute("username",logname);
loginOK=true;
if(loginOK){
response.sendRedirect("main.jsp");
}
}else{
errorMessage="您的用户名或者密码不正确";
session.setAttribute("username","");
}
}
%>
<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>
<tr><td align="right" height="32" width="40%">
<font color=red><%=errorMessage%></font>
</td>
</tr>
<form action="" method="post">
<tr><td align="right" height="32" width="40%">名字：</td>
<td>
<input type="hidden" name="returl" value="">
<input type="text" name="logname" value="">
</td>
</tr>
<tr>
<td align="right" height="32">密码：</td>
<td>
<input type="password" name="logpass">
</td>
</tr>
<tr>
<td align="center" colspan="2" height="32"> |
<a href="findpass.jsp">密码忘了，找一下</a> |
<a href="reg.jsp">注册新用户</a> |
<input type="submit" name="login" value="GO!">
</td>
</tr>
</form>
<tr>
<td colspan="2" align="right"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
例程9-4
<html>
<head>
<title>Untitled</title>
</head>
<body>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="307">
<tr align=center>
<td width="100%" colspan="4" height="20" bgcolor="#3399ff"> <font color="#ffffff">新成员注册新成员注册新成员注册新成员注册</font>
</td>
</tr>
<tr>
<td width="100%" align="center" colspan="4" height="36"> 粗体内容必须填写 </td>
</tr>
<form name="form1" method="post" action="reg_ok.jsp">
<tr>
<td align="right" ><b>登录名称：</b></td>
<td > </td>
<td colspan="2" >
<input type="text" name="logname" value="wangxining">
</td>
</tr>
<tr>
<td align="right"><b>真实姓名：</b></td>
<td> </td>
<td colspan="2">
<input type="text" name="realname" value="wangwang">
</td>
</tr>
<tr>
<td align="right"><b>您的密码：</b></td>
<td> </td>
<td colspan="2">
<input type="password" name="passwd1" value="blueriver">
</td>
</tr>
<tr>
<td align="right"><b>密码确认：</b></td>
<td> </td>
<td colspan="2">
<input type="password" name="passwd2" value="blueriver">
</td>
</tr>
<tr>
<td align="right"><b>电子邮件：</b></td>
<td> </td>
<td colspan="2">
<input type="text" name="email" value="wangxining@263.net">
</td>
</tr>
<tr>
<td align="right"><b>性 别：</b></td>
<td> </td>
<td colspan="2">
<input type="radio" name="Gender" value="0" checked>
男
<input type="radio" name="Gender" value="1">
女 </td>
</tr>
<tr>
<td align="right">联系电话：</td>
<td> </td>
<td colspan="2">
<input type="text" name="phone" value="">
</td>
</tr>
<tr>
<td align="right">密码提示问题：</td>
<td> </td>
<td colspan="2">
<input type="text" name="problem" value="">
</td>
</tr>
<tr>
<td align="right">提示答案：</td>
<td> </td>
<td colspan="2">
<input type="text" name="answer" value="">
</td>
</tr>
<tr>
<td align="right">省市：</td>
<td> </td>
<td colspan="2">
<select name="Province" size="1">
<option value="null" >请选择</option>
<option value="Beijing" >北京</option>
<option value="Tianjin" >天津</option>
<option value="Shanghai" >上海</option>
<option value="Chongqing" >重庆</option>
<option value="Hebei" >河北</option>
<option value="Henan" >河南</option>
<option value="Heilongjiang">黑龙江</option>
<option value="Jinlin" >吉林</option>
<option value="Shenyang" >辽宁</option>
<option value="Neimenggu" >内蒙古</option>
<option value="Hainan" >海南</option>
<option value="Shanxi" >山西</option>
<option value="Shanxi3" >陕西</option>
<option value="Shandong" >山东</option>
<option value="Jiangsu" >江苏</option>
<option value="Zhejiang" >浙江</option>
<option value="Anhui" >安徽</option>
<option value="Jiangxi" >江西</option>
<option value="Fujian" >福建</option>
<option value="Gansu" >甘肃</option>
<option value="Ningxia" >宁夏</option>
<option value="Qinghai" >青海</option>
<option value="Xinjiang" >新疆</option>
<option value="Hubei" >湖北</option>
<option value="Hunan" >湖南</option>
<option value="Guangxi" >广西</option>
<option value="Sichuan" >四川</option>
<option value="Guizhou" >贵州</option>
<option value="Yunnan" >云南</option>
<option value="Xizang" >西藏</option>
<option value="Hongkong" >香港</option>
<option value="Aomen" >澳门</option>
<option value="Taiwan" >台湾</option>
</select>
</td>
</tr>
<tr>
<td align="right">教育程度：</td>
<td> </td>
<td colspan="2">
<select name=education size=1>
<option value="null" selected>请选 ...</option>
<option value="Below high school">高中以下程度</option>
<option value="high school/5-year college">高中/中专</option>
<option value="College/University">大学/专科</option>
<option value="Graduate and above">研究生以上</option>
</select>
</td>
</tr>
<tr>
<td align="right">兴趣爱好：</td>
<td> </td>
<td>
<input type=checkbox name=hobbies value="1@">
计算机行业/软硬件
<input type=checkbox name=hobbies value="2@">
旅游、度假 </td>
</tr>
<tr>
<td align="right"> </td>
<td> </td>
<td>
<input type=checkbox name=hobbies value="3@">
上网聊天、游戏
<input type=checkbox name=hobbies value="4@">
阅读、图书音像</td>
</tr>
<tr>
<td align="right"> </td>
<td> </td>
<td>
<input type=checkbox name=hobbies value="5,">
文化/教育/育儿
<input type=checkbox name=hobbies value="6,">
情感生活 </td>
</tr><tr>
<td align="right"> </td>
<td> </td>
<td>
<input type=checkbox name=hobbies value="7,">
影音娱乐
<input type=checkbox name=hobbies value="8,">
生活资讯 </td>
</tr><tr>
<td align="right"> </td>
<td> </td>
<td>
<input type=checkbox name=hobbies value="9,">
医疗健康
<input type=checkbox name=hobbies value="10,">
房产家居 </td>
</tr>
<tr>
<td align="right" valign="top">自我简介：</td>
<td> </td>
<td colspan="2">
<textarea name="selfintro" cols="40" rows="5">selddddddddd</textarea>
</td>
</tr>
<tr>
<td align="right"> </td>
<td> </td>
<td align="left" colspan="2">
<input type="button" value="填好了" onclick="sub()">
<input type="reset" value="重填">
<script language="javascript">
function sub()
{
if(document.form1.logname.value=="")
{
window.alert("请填写你的登录名！");
window.form1.logname.focus();
return false;
}
if(document.form1.realname.value=="")
{
window.alert("请填写你的真名！");
window.form1.realname.focus();
return false;
}
if(document.form1.passwd1.value=="")
{
window.alert("请填写密码！");
window.form1.passwd1.focus();
return false;
}
if(document.form1.passwd1.value!=document.form1.passwd2.value)
{
window.alert("请验证密码！");
window.form1.passwd2.focus();
return false;
}
if(document.form1.email.value=="")
{
window.alert("请填写你的E_mail！");
window.form1.email.focus();
return false;
}
document.form1.submit();
}
</script>
</td>
</tr>
</form>
</table>
</body>
</html>
例程9-5
<%@ 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";
}
%>
<%!String logname,realname,passwd1,passwd2,email,gender,phone;
String problem,answer,province,education,selfintro,hobby;
String[] hobbies;
boolean regAttempt = false;
String errorMessage = "";
%>
<% //out.print(request.getParameterValues("logname"));
//必须填写的项目
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);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -