GuestBook Test

最新推荐文章于 2024-08-07 03:02:13 发布

milan25429688

最新推荐文章于 2024-08-07 03:02:13 发布

阅读量5.2k

点赞数

分类专栏： Servlet/Bean/JSP 文章标签： string jsp email 数据库驱动程序 class stylesheet

本文链接：https://blog.csdn.net/milan25429688/article/details/277674

版权

Servlet/Bean/JSP 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

这是我的第一个留言板测试例子，包括登陆界面，留言板主页，添加留言等页面：

1.页面
F:/Tomcat 5.0/webapps/ROOT/login
log.html
log_cm.jsp
success.jsp
relog.jsp
index.jsp
guestbook.jsp

2.Bean
F:/Tomcat 5.0/webapps/ROOT/WEB-INF/classes/login
LogBean.java

F:/Tomcat 5.0/webapps/ROOT/WEB-INF/classes/dbtest
Accessdb.java

3.数据库
F:/Tomcat 5.0/webapps/ROOT/BUSINESS(BUSINESS 是可以自定义的)
firm.mdb——两个表：
user(name,password,email)；
guest(未完成，用作保存留言.....)

4.表情
F:/Tomcat 5.0/webapps/ROOT/images
hello.gif
...

1。log.html

<html>
<head>
<title>我的第一个HTML登陆界面</title>

body { font-family:宋体; font-size:9pt}
th { font-size: 9pt }

</style>
</head>

<body>

</form>
</table>

</center>
</body>
</html>

2。log_cm.jsp

<%-- class="login.LogBean" 指代/ROOT/WEB-INF/classes/login 目录下的LogBean 类 --%>
<jsp:useBean id="handle" class="login.LogBean" scope="request">
<jsp:setProperty name="handle" property="*"/>
</jsp:useBean>

<body>
<%-- session.putValue("loginsign", "ok"); 用于检验用户是否已经登陆 --%>
<%
session.putValue("loginsign", "ok");
if(handle.validate()){
%>
<jsp:forward page="success.jsp"/>
<%
}
if(!handle.validate()){
%>
<jsp:forward page="relog.jsp"/>
<%
session.putValue("loginsign", "false");
}
%>
</body>
</html>

3。success.jsp

<%-- class="login.LogBean" 指代/ROOT/WEB-INF/classes/login 目录下的LogBean 类 --%>
<jsp:useBean id="handle" class="login.LogBean" scope="request"/>
<jsp:useBean id="addBean" class="dbtest.Accessdb" scope="page"/>

body { font-family:宋体; font-size:9pt}
th { font-size: 9pt }
td { font-size: 9pt }

</style>
</head>

<body>

<tr><td colspan=2 align='center'><h4>祝贺你注册成功！</h4></td></tr>

</table>

<%
//把"8859_1"码转换为"gb2312"码
String name = new String(handle.getUsername().getBytes("8859_1"));
String password = new String(handle.getPassword().getBytes("8859_1"));
String email = new String(handle.getEmail().getBytes("8859_1"));
String strSQL = " insert into user(name, password, email) values(' "
+ name + " ',' " + password + " ',' " + email + " ') "; //把记录写入数据库
addBean.executeUpdate(strSQL);
out.print("你的留言已经保存到数据库中，谢谢！");
%>

</center>
</body>
</html>

4。relog.jsp

<jsp:useBean id="handle" class="login.LogBean" scope="request"/>

body { font-family:宋体; font-size:9pt}
th { font-size: 9pt }

</style>
</head>

<tr><td colspan=2 align='center'><h4>请重新登陆：</h4></td></tr>

</table>
</form>

</body>
</html>

5。index.jsp

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="showBean" scope="page" class="dbtest.Accessdb" />

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>我的第一个留言板主页</title>

<body>
<script language="javascript">
function submit(){
self.location.replace("index.jsp")
}
</script>

<%
//指定行数
int pageLine = 10;
int totalRec = 0;
int totalSub = 0;
int intPage = 1;
int i;

try{
ResultSet rs = null;
//取得总记录数
rs = showBean.executeQuery("select count(*) as cnt from guestbook");
if( rs.next() )
totalRec = rs.getInt("cnt");
rs.close();
showBean.closeStat();
}catch(Exception e){ e.printStackTrace(); }

//取得总页数
int intPageCount = 0;
intPageCount = (totalRec + pageLine - 1) / pageLine ;

ResultSet RS = showBean.executeQuery("select * from guestbook order by serial_no desc");
String emote1;
String name1;
Date gtime1;
String content1;
%>

<%
if(intPageCount>0){
for(i=1; i<(intPage-1)*pageLine; i++)
  RS.next();
for(i=1; i<=pageLine; i++) {
  if(RS.next()){
      emote1 = RS.getString("emote");
   name1 = RS.getString("name");
   gtime1 = RS.getDate("guest_time");
   content1 = RS.getString("content");
%>

<%
}//if(RS.next())
}//for(i=1; i<=pageLine; i++)
RS.close();
}//if(intPageCount>0)
%>

</table>
</center>

</body>
</html>

6。guestbook.jsp

<html>
<head>
<title>我的第一个GUESTBOOK</title>
<link rel = stylesheet href="../style.css" type="text/css">
<script language="JavaScript">
function valiform() {
if(document.form1.content.value=""){
  alert("留言内容不能为空！");
  documnet.form1.content.focus();
  return false;
}
}
</script>
</head>
<body>
<form method=post action="ok_guestbook.jsp" name=form1 onSubmit="return valiform()">

<%-- 取得用户登陆时的session 变量值，并存放在隐藏域中 --%>
<%String name1 = (String)session.getValue("username");%>
<input type="hidden" name="name" value＝<%=name1%>>
<tr>
<td>留言人：<%=name1%></td>
</tr>

</table>
</center>
</form>
</body>
</html>

7。LogBean.java

package login;

import java.util.*;

public class LogBean
{
private String username;
private String password;
private String email;
private Hashtable errors;

public LogBean(){
    username = "";
    password = "";
    email = "";
    errors = new Hashtable();
}

public String getUsername(){
    return username;
}

public String getPassword(){
    return password;
}

public String getEmail(){
    return email;
}

public void setUsername(String usernameStr){
    username = usernameStr;
}

public void setPassword(String passwordStr){
    password = passwordStr;
}

public void setEmail(String emailStr){
    email = emailStr;
}

public void setErrors(String Key,String msg){
    errors.put(Key,msg);
}

public boolean validate(){
    boolean allOk = true;
    if(username.equals("")){
      errors.put("username","Plz enter your name");
      username = "";
      allOk = false;
    }
    if( (password.equals(""))||(password.length()>10)||(password.length()<6) ){
      errors.put("password","Plz enter a password of 6-10 charactors.");
      allOk = false;
    }
    if( (email.equals(""))||(email.indexOf('@')==-1)||(email.indexOf('.')==-1) ){
      errors.put("email","Plz enter a valid Email");
      allOk = false;
    }

    return allOk;

}

public String getErrorMsg(String s){
    String errorMsg = (String) errors.get(s.trim());
    return (errorMsg==null)?"":errorMsg;
}

}

8。Accessdb.java

package dbtest;

//1.导入JDBC 标准类库
import java.sql.*;

public class Accessdb {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection con = null;
private Statement stat = null;
ResultSet rs = null;

//2.注册数据库驱动程序
public Accessdb()
{
    try{
      Class.forName(sDBDriver);
    }
    catch(java.lang.ClassNotFoundException e){
      System.err.println("firm():" + e.getMessage());
    }
}

//3.建立数据库连接及定义数据查询
public ResultSet executeQuery(String sql){
    rs = null;
    try{
      con = DriverManager.getConnection(sConnStr);
      stat = con.createStatement();
      rs = stat.executeQuery(sql);
    }
    catch(SQLException ex){
      System.err.println("aq.executeQuery:" + ex.getMessage());
    }
    return rs;
}

//4.定义数据操作
public void executeUpdate(String sql){
    stat = null;
    rs = null;
    try{
      con = DriverManager.getConnection(sConnStr);
      stat = con.createStatement();
      stat.executeQuery(sql);
      stat.close();
      con.close();
    }
    catch(SQLException ex){
      System.err.println("aq.executeQuery:" + ex.getMessage());
    }
}

//5.关闭数据库连接
public void closeStat(){
    try{
      stat.close();
    }
    catch(SQLException e){
      e.printStackTrace();
    }
}

public void closeCon(){
    try{
      con.close();
    }
    catch(SQLException e){
      e.printStackTrace();
    }
}
}