Cara menggunakan JSP+MySQL untuk membuat buku tamu (3)

Penulis：Eve Cole Waktu Pembaruan：2009-07-02 17:13:14

下面我们开始建立留言的页面！
<%@halaman
impor = "java.util.*"
impor = "java.teks.*"
impor="java.sql.*"
impor = "java.io.*"
impor = "java.lang.*"
contentType="teks/html; rangkaian karakter=gb2312"
%>
<%
kelas CommentError// melempar java.lang.NullPointerException
{ public String Nama Pengguna="",Jenis Kelamin="",Alamat="",Pos="",Oicq="",Icq="",Tel="",Komentar="";
boolean publik NoError=benar;//salah;
publik int Jumlah Kesalahan=0;
boolean pribadi IsNumber(String s1) {}
font String publik (String se) {}
String publik Comment_Er(String se) {}
public void Nama Pengguna (String se) {}
kekosongan publik Seks (String se) {}
Alamat kekosongan publik (String se) {}
Komentar kekosongan publik (String se) {}
public void Telp (String se) {}
pos kekosongan publik (String se) {}
kekosongan publik Oicq (String se) {}
kekosongan publik Icq (String se) {}
}
kelas FormatKomentar
{ Penggantian String publik(Sumber string, String oldString, String newString) {}
format String publik(String se) {}
String publik dari komentar(String se) {}
String publik toHtmlInput(String str) {}
String publik toHtml(String str) {}
Public String toSql(String str) {}//转换为可以加入Myqal的格式
}

%>
<html>
<kepala>
<meta http-equiv="Jenis Konten" content="teks/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>使用MYsql数据库</title>
</kepala>

<tubuh>

<p align="center"><center><font style="WARNA: biru; KELUARGA FONT: 方正舒体,华文行楷,隶书,宋体; UKURAN FONT: 16pt">萍慧jsp留言薄</font ></pusat></p>
<p menyelaraskan="tengah">

<%! String nama pengguna,jenis kelamin,alamat,posting,oicq,icq,nomortel,komentar,email,url.urltitle;
%>
<%
coba{ nama pengguna=permintaan.getParameter("nama");
}tangkap (NullPointerException e){ nama pengguna="";}

coba{ comment=request.getParameter("komentar");
}tangkap (NullPointerException e){ komentar="";}

coba{ sex=request.getParameter("sex");
}tangkap (NullPointerException e){ seks="";}

coba{ alamat=permintaan.getParameter("alamat");
}menangkap (NullPointerException e){ alamat="";}

coba{ post=request.getParameter("postal");
}tangkap (NullPointerException e){ post="";}

coba{ oicq=request.getParameter("oicq");
}tangkap (NullPointerException e){ oicq="";}

coba{ icq=request.getParameter("icq");
}menangkap (NullPointerException e){ icq="";}

coba{ telnumber=request.getParameter("telepon");
}tangkap (NullPointerException e) { telnumber= ""; }
coba{ email=request.getParameter("email");
}tangkap(NullPointerException e) { email= ""; }
coba{ url=request.getParameter("url");
}menangkap (NullPointerException e) { url= ""; }
coba{ urltitle=request.getParameter("urltitle");
}tangkap (NullPointerException e) { urltitle= ""; }

String ip=request.getRemoteAddr();//得到IP地址
String time=(new SimpleDateFormat ("yyyy-MM-dd hh:mm:ss", Locale.US )).format(new java.util.Date());
String userid="";
String Kueri Saya="";
layanan asuransi kesehatan
CommentError testcomment= baru CommentError();
testcomment.Nama Pengguna(nama pengguna);
testcomment.Postal (posting);
testcomment.Sex(seks);
komentar tes.Alamat(alamat);
testcomment.Tel(nomor telp);
komentar tes.Komentar(komentar);
komentar tes.Oicq(oicq);
komentar tes.Icq(icq);

if (testcomment.NoError) //留言中没有错误,写数据库
coba {//写数据库成功
java.sql.Koneksi sqlConn; //数据库连接对象
java.sql.Pernyataan sqlStmt; //语句对象
java.sql.ResultSet sqlRst; //结果集对象
//登记JDBC驱动对象
Kelas.forName("org.gjt.mm.mysql.Driver").newInstance();
//连接数据库
sqlConn= java.sql.DriverManager.getConnection ("jdbc:mysql://localhost/pinghui","test","");
//创建语句对象
sqlStmt=sqlConn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
//执行Sql语句
sistem operasi MySQL, sistem operasi MySQL,
FormatKomentar FC= FormatKomentar baru();
oicq=FC.formatint(oicq);
icq=FC.formatint(icq);
post=FC.formatint(posting);
nomortel=FC.formatint(nomortel);
nama pengguna=FC.toSql(nama pengguna);
komentar=FC.toSql(komentar);
MyQuery="masukkan ke dalam komentar (nama pengguna, jenis kelamin, alamat, ip, posting, oicq, icq, nomor telepon, komentar, waktu, url, email) nilai ('"+nama pengguna+"','"+jenis kelamin+"','"+ alamat+"','"+ip+"',"+post+","+oicq+","+icq+",'"+nomortel+"','"+komentar+"',sekarang(),'"+url+"' ,'"+email+"');";
sqlRst=sqlStmt.executeQuery (Permintaan Saya); //向数据库中加入数据
sqlRst.close();//关闭结果集对象
sqlStmt.close();//关闭语句对象
sqlConn.close(); //关闭数据库连接
out.print (waktu);

%>
<font size="5" face="华文行楷">留言成功,谢谢!</font>
<tabel perbatasan = "0" cellpadding = "0" sel spasi = "0" lebar = "100%">
<tubuh>
<tr>
<td width="25%">昵称：<%=nama pengguna%></td>
<td width="25%">性别：<%=sex%></td>
<td colspan="2" width="50%">地址：<%=alamat %></td>
</tr>
<tr>
<td width="25%">Penggunaan：<%=telnumber%></td>
<td width="25%">邮编：<%=post%></td>
<td width="25%">OICQ：<%=oicq%></td>
<td width="25%">ICQ：<%=icq%></td>
</tr>
<tr>
<td colspan="2" width="50%">Email：<a href="mailto:" title="写信给留言者"></a></td>
<td colspan="2" width="50%">Penggunaan：<a href target="_blank"></a></td>
</tr>
<tr>
<td colspan="4"><font style="COLOR: green; LINE-HEIGHT: 150%">留言：</font><%=comment%><font style="COLOR: green; LINE-HEIGHT: 150%"><br>
    -</font><%=time %><font style="COLOR: green; LINE-HEIGHT: 150%">（来自</font><%=ip %><font style="WARNA: hijau; TINGGI GARIS: 150%">）</font></td>
</tr>
</tbody>
</tabel>
<hr color="#0080c0" noshade size="1" width="100%">

<%
} catch (SQLException e) //写数据库失败
{ out.print ("<font color=merah>留言失败</font>");
keluar.print (MyQuery);
keluar.print (userid);
}
kalau tidak
{
out.print ("<font color=red>总共有"+testcomment.ErrorCount+"条错误数据,请修改!</font>");
%>

<bahasa skrip="JavaScript">

<tabel>
<tr>
<td>
<tabel cellpacing="0" cellpadding="0">
<tr>
<td>
<form action="addmysql.jsp" method="POST" name="all_comments" onsubmit="javascript:return (test_comments(this))">
<tabel border="0" width="100%" Cellspacing="0" cellpadding="0">
<tr>
<td width="60%">昵 称：<input name="name" size="20" value="<%if (nama pengguna != null) out.print (nama pengguna);%>">< %=testcomment.Comment_Er("nama pengguna")%></td>
<td nowrap width="40%">性 别：<pilih nama="sex" size="1">
<opsi dipilih value="男" <%if(sex=="男") out.print("pilih"); %>>男</option>
<option value="女" <%if(sex=="女") out.print("pilih"); %>>女</option>
<option value="保密" <%if(sex=="保密") out.print("pilih"); %>>保密</option>
</select><%=testcomment.Comment_Er("seks")%></td>
</tr>
<tr>
<td colspan="2">地 址：<input name="address" size="40" value="<%if (address!=null) out.print(address);%>"><% =testcomment.Comment_Er("alamat")%></td>
</tr>
<tr>
<td>电 话：<input name="telphone" size="15" value="<%if(telnumber!=null)out.print(telnumber);%>"><%=testcomment.Comment_Er( "telp")%></td>
<td>邮 编：<input name="postal" size="6" value="<%if(post!=null) out.print(post);%>"><%=testcomment.Comment_Er( "pos")%></td>
</tr>
<tr>
<td> OICQ：<input name="oicq" size="10" value="<%if(oicq!=null) out.print (oicq);%>"><%=testcomment.Comment_Er(" oicq")%></td>
<td> ICQ ：<input name="icq" size="15" value="<%if(icq!=null)out.print(icq);%>"><%=testcomment.Comment_Er( "icq")%></td>
</tr>
<tr>
<td colspan="2">Email：<input name="email" size="25" value="<%if(email!=null) out.print(email);%>"><%//= komentar tes.Comment_Er("")%></td>
</tr>
<tr>
<td colspan="2">网 址：<input name="url" size="40" value="<%if(url!=null)out.print(url);%>"><% //=testcomment.Comment_Er("")%></td>
</tr>
<tr>
<td colspan="2"><textarea cols="80" name="comment" row="10" wrap="physical"><%if (comment!=null)out.print (comment);%>< /area teks>
<tr>
<td align="right"><input name="put_submit" type="submit" value="确定" ?></td>
<td align="left"><input name="r" type="reset" value="重置"></td>
</tr>
</tabel>
</bentuk>

</td>
<td><%=testcomment.Comment_Er("comment")%>请注意：你所输入的内容中，昵称和留言为必须输入的项目！<br>
不支持html标志</td>
</tr>
</tabel>
</td>
</tr>
</tabel>
<%
}
%>
</tubuh>