留言板html模板源代码（留言板html模板源代码怎么写）

qiaoqingyi 2023-04-02 776

默认

本篇文章给大家谈谈留言板html模板源代码，以及留言板html模板源代码怎么写对应的知识点，希望对各位有所帮助，不要忘了收藏本站喔。

本文目录一览：

1、完整的php&mysql的留言板源代码,可以运行的
2、开源里有没有留言板的源代码，JAVA的
3、HTML做出来了一个留言板界面，但是想要实现功能还需要怎么操作？？？

完整的php&mysql的留言板源代码,可以运行的

input.htm

html

head

meta http-equiv="Content-Language" content="zh-cn"

meta http-equiv="Content-Type" content="text/html; charset=gb2312"

titleinput/title

/head

body

form method="POST" action="receive.php"

p您的姓名： input type="text" name="T1" size="20"/p

p您的性别：男input type="radio" value="0" name="R1"

女input type="radio" name="R1" value="1"/p

p您的EMAIL：input type="text" name="T2" size="35"/p

p您的留言内容：/p

p textarea rows="16" name="S1" cols="45"/textarea/p

p /p

p input type="submit" value="提交" name="B1"

input type="reset" value="重置" name="B2"/p

/form

/body

/html

receive.php

?php

$user='root';

$password='123';

$db='guestbook';

$table='gbook';

$ip=getenv(REMOTE_ADDR);

$sql = "INSERT INTO `guestbook`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, '$T1', '$R1', '$T2', '$S1', '$ip', NOW());";

$connect=mysql_connect('localhost',$user,$password);

mysql_select_db($db);

mysql_query($sql);

$result=mysql_query("select * from $table");

while ($arr=mysql_fetch_array($result))

{

if ($arr[2]==0)

$gender='先生';

else

$gender='女士';

html

head

meta http-equiv="Content-Language" content="zh-cn"

meta http-equiv="Content-Type" content="text/html; charset=gb2312"

titleReceive/title

/head

body style="background-attachment: fixed"

table border="1" width="100%" id="table1" bgcolor="#FFFFFF"

td bordercolor="#FFFFFF" bgcolor="#C0C0C0"?=$arr[6]?(?=$arr[5]?)p?=$arr[1]? ?=$gender?a href="?=$arr[3]?"?=$arr[3]?/a

写到:/td

/tr

td?=$arr[4]?p /p

pa href="del.php?id=?=$arr[0]?"[删除]/a

a href="modify.php?id=?=$arr[0]?"[修改]/a]/td

/tr

/table

/body

/html

?php

echo 'p';

}

html

head

meta http-equiv="Content-Language" content="zh-cn"

meta http-equiv="Content-Type" content="text/html; charset=gb2312"

title新建网页 1/title

/head

body

pa href="input.htm"继续留言/a/p

/body

/html

del.php

?php

$user='root';

$password='123';

$db='guestbook';

$table='gbook';

$sql="DELETE FROM $table WHERE id=$id";

$connect=mysql_connect('localhost',$user,$password);

mysql_select_db($db);

$result=mysql_query($sql);

if ($result)

echo "删除成功";

else

echo "删除失败";

html

head

meta http-equiv="Content-Language" content="zh-cn"

meta http-equiv="Content-Type" content="text/html; charset=gb2312"

title新建网页 1/title

/head

body

pa href="receive.php"返回首页/a/p

/body

/html

modify.php

?php

$user='root';

$password='123';

$db='guestbook';

$table='gbook';

$ip=getenv(REMOTE_ADDR);

$connect=mysql_connect('localhost',$user,$password);

mysql_select_db($db);

$result=mysql_query("select * from $table where id=$id");

$arr=mysql_fetch_array($result);

html

head

meta http-equiv="Content-Language" content="zh-cn"

meta http-equiv="Content-Type" content="text/html; charset=gb2312"

titleinput/title

/head

body

form method="POST" action="modify_ok.php?id=?=$id?"

p您的姓名： input type="text" name="T1" size="20" value="?=$arr[1]?"/p

p您的性别：

?php

if ($arr[2]==0) echo '男input type="radio" value="0" name="R1" checked

女input type="radio" name="R1" value="1"/p';

else echo '男input type="radio" value="0" name="R1"

女input type="radio" name="R1" value="1" checked/p';

p您的EMAIL：input type="text" name="T2" size="35" value="?=$arr[3]?"/p

p您的留言内容：/p

p textarea rows="16" name="S1" cols="45" ?=$arr[4]?/textarea/p

p /p

p input type="submit" value="修改" name="B1"

input type="reset" value="重置" name="B2"/p

/form

/body

/html

modify_ok.php

?php

$user='root';

$password='123';

$db='guestbook';

$table='gbook';

$connect=mysql_connect('localhost',$user,$password);

mysql_select_db($db)

$sql = "UPDATE `guestbook`.`gbook` SET `name` = '$T1', `sex` = '$R1', `email` = '$T2', `info` = '$S1' WHERE `gbook`.`id` = '$id' LIMIT 1;";

$result=mysql_query($sql);

if ($result)

echo "修改成功";

else

echo "修改失败";

html

head

meta http-equiv="Content-Language" content="zh-cn"

meta http-equiv="Content-Type" content="text/html; charset=gb2312"

title新建网页 1/title

/head

body

pa href="input.htm"继续留言/a/p

/body

/html

开源里有没有留言板的源代码，JAVA的

绝对开源，绝对明了的留言板，便于学习的源码

用JAVA写的留言板原代码

* guestbookServlet.java

* */

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

import java.util.Date;

/**

* */

public class guestbookServlet extends HttpServlet {

boolean debug=false;

String sDBDriver;

Connection conn=null;

ResultSet rs=null;

/** Initializes the servlet.

public void init(ServletConfig config) throws ServletException {

super.init(config);

if(debug)

sDBDriver=new String("sun.jdbc.odbc.JdbcOdbcDriver");

else

sDBDriver=new String("org.gjt.mm.mysql.Driver");

try{

Class.forName(sDBDriver);

}

catch(java.lang.ClassNotFoundException e){

System.err.println("Driver类初始化:"+e.getMessage());

}

/** Destroys the servlet.

public void destroy() {

}

/** Processes requests for both HTTP codeGET/code and codePOST/code methods.

* @param request servlet request

* @param response servlet response

protected void processRequest(HttpServletRequest request, HttpServletResponse response)

throws ServletException, java.io.IOException {

response.setContentType("text/html;charset=gb2312");

java.io.PrintWriter out = response.getWriter();

boolean empty=true;

boolean noResult=true;

String sqlStr;

int currentPage=0;

int totalPage=0;

int reccount=0;

ResultSet myrs=null;

String username=request.getParameter("username");

String email=request.getParameter("email");

String ucontent=request.getParameter("ucontent");

String ipage=request.getParameter("ipage");

if(ipage==null||ipage.length()==0)

currentPage=1;

else

currentPage=Integer.parseInt(ipage);

if((username==null||username.length()==0)||(ucontent==null||ucontent.length()==0))empty=true;

else empty=false;

Date myDate=new Date();

//String intime=new String(String.valueOf(myDate.getYear()+1990)+String.valueOf(myDate.getMonth()));

String year=String.valueOf(myDate.getYear()+1900);

String month=String.valueOf(myDate.getMonth()+1);

if(month.length()==1)

month=new String("0"+month);

String days=String.valueOf(myDate.getDate());

if(days.length()==1)

days=new String("0"+days);

String hours=String.valueOf(myDate.getHours());

if(hours.length()==1)

hours=new String("0"+hours);

String minutes=String.valueOf(myDate.getMinutes());

if(minutes.length()==1)

minutes=new String("0"+minutes);

String intime=year+"-"+month+"-"+days+" "+hours+":"+minutes;

if(email==null||email.length()==0)

email=new String("");

if(!empty){

//username=convert(username);

//email=convert(email);

//ucontent=convert(ucontent);

sqlStr="insert into Mintegbook(Mname,Memail,Mcontent,Mtime,Mid) values("+username+","+email+","+ucontent+","+intime+",1)";

getDsnConn();

executeInsert(sqlStr);

}

sqlStr=new String("select Mname,Memail,Mcontent,Mtime from Mintegbook order by Mtime DESC");

getDsnConn();

reccount=getRecordCount("Mintegbook");

if(reccount==0)

noResult=true;

else

noResult=false;

if(!noResult){

int ipageSize=10;

totalPage=getTotalPage("Mintegbook",ipageSize);

if(currentPagetotalPage)

currentPage=totalPage;

int cursor=(currentPage-1)*ipageSize+1;

try{

myrs=executeScrollableQuery(sqlStr);

myrs.absolute(cursor);

}

catch(SQLException e){

noResult=true;

}

out.println("HTMLHEADTITLE我的Servlet留言板/TITLE");

out.println("META http-equiv="Content-Type" content="text/html; charset=gb2312"");

out.println("STYLE type="text/css"");

out.println("!--");

out.println(".mytext { font-family: "宋体"; font-size: 12px}");

out.println(" --");

out.println("/STYLE");

out.println("/HEAD");

out.println("BODY bgcolor="#FFFFFF" text="#000000"");

out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="CENTER" class="mytext"");

out.println("TRTD height="22" | a href=""我的主页/a | 我的Servlet留言板(A href="mailto:yf188@21cn.com"川石/A制作)/TD/TR");

out.println("TRTD height="1" bgcolor="#999933"/TD/TR");

out.println("/TABLE");

out.println("BR");

out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="CENTER" class="mytext"");

out.println("TRTD height="8"/TD/TR");

out.println("TRTD height="18" bgcolor="#f7f7f7"DIV align="right"");

out.println("共有 "+reccount + " 条留言 ");

out.println(" 当前第font color=#ff0000"+currentPage+"/font/共 "+totalPage+" 页 ");

if(currentPage1)

out.println(" a href=guestbookServlet?ipage=1首页/a a href=guestbookServlet?ipage="+(currentPage-1)+"上一页/a ");

else

out.println(" 首页上一页 ");

if(currentPagetotalPage)

out.println(" a href=guestbookServlet?ipage="+(currentPage+1)+"下一页/a a href=guestbookServlet?ipage="+totalPage+"末页/a ");

else

out.println(" 下一页末页 ");

out.println("/DIV/TD/TR");

out.println("/TABLE");

out.println("BR");

//这里是显示留言内容

if(!noResult){

String dname;

String demail;

String dcontent;

String dtime;

Date temptime;

try{

do{

dname=new String(myrs.getString("Mname"));

demail=new String(myrs.getString("Memail"));

dcontent=new String(myrs.getString("Mcontent"));

try{

dtime=new String(myrs.getObject("Mtime").toString());

}

catch(java.lang.NullPointerException e){

dtime=new String("2001-04-06 12:30");

}

if(dname==null)

dname=new String("川石");

if(demail==null)

demail=new String("yf188@21cn.com");

if(dcontent==null)

dcontent=new String("test");

if(dtime==null)

dtime=new String("2001-04-06 12:30");

dname=convert(dname);

dcontent=convert(dcontent);

//temptime=myrs.getDate("Mtime");

String tempyear=String.valueOf(temptime.getYear()+1900);

String tempmonth=String.valueOf(temptime.getMonth()+1);

if(tempmonth.length()==1)

tempmonth=new String("0"+tempmonth);

String tempdays=String.valueOf(temptime.getDate());

if(tempdays.length()==1)

tempdays=new String("0"+tempdays);

String tempminute=String.valueOf(temptime.getMinutes());

if(tempminute.length()==1)

tempminute=new String("0"+tempminute);

String temphours=String.valueOf(temptime.getHours());

if(temphours.length()==1)

temphours=new String("0"+temphours);

String dtime=tempyear+" 年 "+ tempmonth +" 月 "+ tempdays +" 日 " + temphours+ " 时 "+ tempminute + " 分 ";

out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext"");

out.println("TRTD姓名 A href="mailto:"+demail+"""+dname+"/A 留言时间："+dtime+"/TD/TR");

out.println("TRTD height="10"/TD/TR");

out.println("TRTD height="10""+dcontent+"/TD/TR");

out.println("/TABLE");

out.println("HR width="600" size="1"");

}while(myrs.next());}

catch(SQLException e){

out.println("error found");

}

else{

out.println("还没有留言！");

}

//结束

out.println("FORM name="form1" method="post" action="guestbookServlet"");

out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext"");

out.println("TRTD width="80"姓名:/TDTDINPUT type="text" name="username"*/TD/TR");

out.println("TRTDEmail:/TDTDINPUT type="text" name="email"*/TD/TR");

out.println("TRTD留言：/TDTDTEXTAREA name="ucontent" cols="65" rows="4"/TEXTAREA/TD/TR");

out.println("/TABLE");

out.println("TABLE width="400" border="0" cellspacing="0" cellpadding="6" align="CENTER" class="mytext"");

out.println("TRTD height="15" width="200" /TDTD /TD/TR");

out.println("TRTDDIV align="RIGHT"INPUT type="button" name="Button" value=" 提交 " style="cursor:hand" onclick="javascript:check()"/DIV/TD");

out.println("TDINPUT type="reset" name="Submit2" value=" 重置 "/TD/TR");

out.println("/TABLE");

out.println("/FORM");

out.println("TABLE width="400" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext"");

out.println("TRTD width="15" /TD/TR");

out.println("TRTDDIV align="LEFT"/DIV/TD/TR");

out.println("TRTD /TD/TR");

out.println("/TABLE");

out.println("/BODY");

out.println("/HTML");

out.println("SCRIPT language="javascript"");

out.println("function check(){");

out.println("if(form1.username.value.length1||form1.ucontent.value.length1)");

out.println("{alert(姓名和留言是必须有的!);}else{form1.submit();}}");

out.println("/SCRIPT");

out.close();

}

/** Handles the HTTP codeGET/code method.

* @param request servlet request

* @param response servlet response

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, java.io.IOException {

processRequest(request, response);

}

/** Handles the HTTP codePOST/code method.

* @param request servlet request

* @param response servlet response

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, java.io.IOException {

processRequest(request, response);

}

protected void getDsnConn(){

String sqlUrl="jdbc:mysql://10.0.0.1/你申请用户名?user=你的名字password=你的帐号";

try{

if(debug)

conn=DriverManager.getConnection("jdbc:odbc:ODBC源","用户名","密码口令");

else

conn=DriverManager.getConnection(sqlUrl);

}

catch(SQLException es){

System.err.println("和库连接时出错:"+es.getMessage());

}

protected void executeInsert(String sqlStr){

try{

Statement stmt=conn.createStatement();

stmt.executeUpdate(sqlStr);

}

catch(SQLException es){

System.err.println("执行插入时:"+es.getMessage());

}

protected void executeUpdate(String sqlStr){

try{

Statement stmt=conn.createStatement();

stmt.executeUpdate(sqlStr);

}

catch(SQLException e){

System.err.println("error in query record");

}

//查寻

protected ResultSet executeQuery(String sqlStr){

rs=null;

try{

Statement stmt=conn.createStatement();

rs=stmt.executeQuery(sqlStr);

}

catch(SQLException ex){

System.err.println("执行查寻出错："+ex.getMessage());

}

return rs;

}

protected ResultSet executeScrollableQuery(String sqlStr){

rs=null;

try{

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs=stmt.executeQuery(sqlStr);

}

catch(SQLException e){

System.err.println("执行动态查寻出错");

}

return rs;

}

//得到表记录总数

protected int getRecordCount(String sTableName){

rs=null;

int CountResult=0;

String sqlStr="select count(*) from "+sTableName;

try{

Statement stmt=conn.createStatement();

rs=stmt.executeQuery(sqlStr);

if(rs.next())

CountResult=rs.getInt(1);

rs=null;

stmt.close();

}

catch(SQLException ex){

System.err.println(ex.getMessage());

}

return CountResult;

}

//得到记录总页数

protected int getTotalPage(String sTableName,int iPageSize){

int totalPage;

int totalRecNum=getRecordCount(sTableName);

if(totalRecNum%iPageSize==0)

totalPage=totalRecNum/iPageSize;

else

totalPage=totalRecNum/iPageSize+1;

return totalPage;

}

protected String convert(String InputStr){

String converted=new String();

byte[] bytes;

try{

bytes=InputStr.getBytes("ISO8859-1");

converted=new String(bytes,"GB2312");

}

catch(java.io.UnsupportedEncodingException e){

System.out.print("error");

}

return converted;

}

/** Returns a short description of the servlet.

public String getServletInfo() {

return "Short description";

}

HTML做出来了一个留言板界面，但是想要实现功能还需要怎么操作？？？

简单易懂的就选php（因为我就懂这个哈哈~），用php的话你需要网上下载一个wamp，安装，一般安装在随便一个盘的根目录下，如D:/这样。比如你装在D盘，那么在D盘的根目录会生成一个wamp文件夹，这个文件夹里面有个www文件夹，www里面就是你要写代码放的地方，然后你打开浏览器，输入网址：localhost或者127.0.0.1，出现php界面应该就是安装成功了。你注意电脑屏幕右下角有个绿色的W标志，就是成功啦~

接下来就是编写php语言用来连接数据库啦

关于留言板html模板源代码和留言板html模板源代码怎么写的介绍到此就结束了，不知道你从中找到你需要的信息了吗？如果你还想了解更多这方面的信息，记得收藏关注本站。

标签：留言板html模板源代码 css