K
kiki19
Unregistered / Unconfirmed
GUEST, unregistred user!
看程序
<%@ page contentType="text/html;
charset=gb2312" %>
<HTML><BODY bgcolor="#FFFFFF" text="#0000C0">
<FORM method="POST" action=gb.jsp>
<INPUT type="text" name="name" size="21" value="姓名和留言" onFocus="this.value=''">
<BR><TEXTAREA rows="4" name="content" cols="20"></TEXTAREA>
<INPUT type="submit" value="提交">
</FORM>
<%
// 初始化
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection sqlConn
= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/gb","root","111111");
java.sql.Statement sqlStmt = sqlConn.createStatement();
// 写入数据
sqlStmt.executeUpdate("insert into gb(name,content,time)"
+ "values('" + request.getParameter("name")+ "','" + request.getParameter("content")
+ "','" + new java.util.Date() + "');"
);
// 读取数据
java.sql.ResultSet sqlRst = sqlStmt.executeQuery("select * from gb;");
while (sqlRst.next()) {
out.println("<B STYLE='FONT-SIZE:9pt'>" + sqlRst.getString("name")
+ ":</B><FONT STYLE='FONT-SIZE:9pt;COLOR:#C00000'> " + sqlRst.getString("content")
+ "</FONT><FONT STYLE='FONT-SIZE:9pt;COLOR:#CCCCCC'> @ " + sqlRst.getString("time")
+ "</FONT><BR>");
}
sqlStmt.close();
sqlConn.close();
%>
</body></html>
提交后全是？？？？？？？。
求救？
<%@ page contentType="text/html;
charset=gb2312" %>
<HTML><BODY bgcolor="#FFFFFF" text="#0000C0">
<FORM method="POST" action=gb.jsp>
<INPUT type="text" name="name" size="21" value="姓名和留言" onFocus="this.value=''">
<BR><TEXTAREA rows="4" name="content" cols="20"></TEXTAREA>
<INPUT type="submit" value="提交">
</FORM>
<%
// 初始化
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection sqlConn
= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/gb","root","111111");
java.sql.Statement sqlStmt = sqlConn.createStatement();
// 写入数据
sqlStmt.executeUpdate("insert into gb(name,content,time)"
+ "values('" + request.getParameter("name")+ "','" + request.getParameter("content")
+ "','" + new java.util.Date() + "');"
);
// 读取数据
java.sql.ResultSet sqlRst = sqlStmt.executeQuery("select * from gb;");
while (sqlRst.next()) {
out.println("<B STYLE='FONT-SIZE:9pt'>" + sqlRst.getString("name")
+ ":</B><FONT STYLE='FONT-SIZE:9pt;COLOR:#C00000'> " + sqlRst.getString("content")
+ "</FONT><FONT STYLE='FONT-SIZE:9pt;COLOR:#CCCCCC'> @ " + sqlRst.getString("time")
+ "</FONT><BR>");
}
sqlStmt.close();
sqlConn.close();
%>
</body></html>
提交后全是？？？？？？？。
求救？