昨天刚刚学习php,今天给人家写了个留言本,该收多少钱? http://219.233.121.233:8888/index.php 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不支持空格.....没法缩进下面是我刚学JSP时写的,支持缩进,可以贴源代码,自动根据IP判断管理权限....交流一下.... 不过美工我实在是太差..............望大家指正<%@ page contentType="text/html; charset=gb2312"%><%@ page import="java.sql.*"%><% String strDSN = "jdbc:odbc:dsnMSG"; Connection cnct = null; Statement stmt = null; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); cnct = DriverManager.getConnection(strDSN,"",""); stmt = cnct.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);%><% request.setCharacterEncoding("gb2312"); String strName = request.getParameter("name"); String strInfo = request.getParameter("info"); java.text.DateFormat dfNow = java.text.DateFormat.getDateTimeInstance(java.text.DateFormat.MEDIUM, java.text.DateFormat.MEDIUM); String strDate = dfNow.format(new java.util.Date()); String strIP = request.getRemoteAddr(); String strSQLRun = request.getParameter("SQL"); String strUpdate = "INSERT INTO msg1 VALUES(" + "\'"+ strName +"\'," + "\'"+ strDate +"\'," + "\'"+ strIP +"\'," + "\'"+ strInfo +"\')"; if (strName!=null && strInfo!=null && strName.trim().length()!=0 && strInfo.trim().length()!=0) stmt.executeUpdate(strUpdate); if (strSQLRun!=null) stmt.executeUpdate(strSQLRun);%><HTML><HEAD><TITLE>工作组留言板</TITLE></HEAD><BODY><TABLE WIDTH="754" BORDER="0" ALIGN="CENTER"><TR><TD><DIV ALIGN="CENTER"><STRONG><FONT SIZE="7">工作组留言板</FONT></STRONG></DIV><FONT FACE="Tahoma"><% String strSQL = "select * from msg1"; ResultSet rs = stmt.executeQuery(strSQL); while (rs.next()) { out.println("<HR WIDTH=\"100%\" ALIGN=\"CENTER\">"); out.println("<FONT COLOR=\"#0000FF\">" + "留言名: " + rs.getString(1) + " "+ "具体时间: "+ rs.getString(2) + " "+ "IP: " + rs.getString(3) + "<BR>"+ "</FONT>" + "<STRONG>" + rs.getString(4).replaceAll("\r\n", "<BR>").replaceAll(" "," ") + "</STRONG>"); if(strIP.trim().compareTo("127.0.0.1")==0) { out.print("<FORM ACTION=\"\" METHOD=\"POST\">"); out.print("<INPUT NAME=\"SQL\" TYPE=\"hidden\" VALUE=\"DELETE FROM msg1 WHERE name= \'"+rs.getString(1) +"\' AND date=\'"+ rs.getString(2) +"\' AND ip=\'"+rs.getString(3) + "\'\">"); out.print("<INPUT NAME=\"submit\" TYPE=\"submit\" VALUE=\"删除\">"); out.println("</FORM>"); } } rs.close();%></FONT><HR WIDTH="100%" ALIGN="CENTER"></TD></TR><TR><TD><FORM ACTION="" METHOD="POST" > 留言名: <INPUT NAME="name" TYPE="text" SIZE="20" MAXLENGTH="20"><BR> 留言内容: <TEXTAREA NAME="info" COLS="100" ROWS="5"></TEXTAREA> <INPUT NAME="submit" TYPE="submit" VALUE="留言"> <INPUT NAME="reset" TYPE="reset" VALUE="重写"></FORM></TD></TR></TABLE></BODY></HTML><% stmt.close(); cnct.close();%> Delphi如何控制扫描仪多页扫描 入门级问题(两个数的值是怎么传递得) 文件流不能读到动态数组?. 问一个简单的问题 数据库连接异常问题 印度为什么可怕[从李建忠兄处转载,原出处不可考] 在线急等-50分. 一个MDI窗体宽度的问题。 query的动态sql如何赋值? 定义自己的组件编辑器,TComponentEditor的哪些方法必须覆盖?回答全面一些,举例不给分 delphi制作媒体播放器的若干问题? 帮不帮进来看看弄了半天了只好到这里来求教了!提示也送分。有关MDI 。 错误提示:'array type requied'怎么回事呢?
没法缩进
下面是我刚学JSP时写的,支持缩进,可以贴源代码,自动根据IP判断管理权限
....交流一下.... 不过美工我实在是太差..............望大家指正
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
String strDSN = "jdbc:odbc:dsnMSG";
Connection cnct = null;
Statement stmt = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cnct = DriverManager.getConnection(strDSN,"","");
stmt = cnct.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
%>
<%
request.setCharacterEncoding("gb2312");
String strName = request.getParameter("name");
String strInfo = request.getParameter("info");
java.text.DateFormat dfNow = java.text.DateFormat.getDateTimeInstance(java.text.DateFormat.MEDIUM, java.text.DateFormat.MEDIUM);
String strDate = dfNow.format(new java.util.Date());
String strIP = request.getRemoteAddr();
String strSQLRun = request.getParameter("SQL");
String strUpdate = "INSERT INTO msg1 VALUES(" + "\'"+ strName +"\'," + "\'"+ strDate +"\'," + "\'"+ strIP +"\'," + "\'"+ strInfo +"\')";
if (strName!=null && strInfo!=null && strName.trim().length()!=0 && strInfo.trim().length()!=0) stmt.executeUpdate(strUpdate);
if (strSQLRun!=null) stmt.executeUpdate(strSQLRun);
%>
<HTML>
<HEAD>
<TITLE>工作组留言板</TITLE>
</HEAD><BODY>
<TABLE WIDTH="754" BORDER="0" ALIGN="CENTER"><TR><TD>
<DIV ALIGN="CENTER"><STRONG><FONT SIZE="7">工作组留言板</FONT></STRONG></DIV>
<FONT FACE="Tahoma"><%
String strSQL = "select * from msg1";
ResultSet rs = stmt.executeQuery(strSQL);
while (rs.next()) {
out.println("<HR WIDTH=\"100%\" ALIGN=\"CENTER\">");
out.println("<FONT COLOR=\"#0000FF\">" +
"留言名: " + rs.getString(1) + " "+
"具体时间: "+ rs.getString(2) + " "+
"IP: " + rs.getString(3) + "<BR>"+
"</FONT>" +
"<STRONG>" + rs.getString(4).replaceAll("\r\n", "<BR>").replaceAll(" "," ") + "</STRONG>");
if(strIP.trim().compareTo("127.0.0.1")==0) {
out.print("<FORM ACTION=\"\" METHOD=\"POST\">");
out.print("<INPUT NAME=\"SQL\" TYPE=\"hidden\" VALUE=\"DELETE FROM msg1 WHERE name= \'"+rs.getString(1) +"\' AND date=\'"+ rs.getString(2) +"\' AND ip=\'"+rs.getString(3) + "\'\">");
out.print("<INPUT NAME=\"submit\" TYPE=\"submit\" VALUE=\"删除\">");
out.println("</FORM>");
}
}
rs.close();
%>
</FONT>
<HR WIDTH="100%" ALIGN="CENTER">
</TD></TR>
<TR><TD>
<FORM ACTION="" METHOD="POST" >
留言名: <INPUT NAME="name" TYPE="text" SIZE="20" MAXLENGTH="20"><BR>
留言内容: <TEXTAREA NAME="info" COLS="100" ROWS="5"></TEXTAREA>
<INPUT NAME="submit" TYPE="submit" VALUE="留言">
<INPUT NAME="reset" TYPE="reset" VALUE="重写">
</FORM>
</TD></TR></TABLE>
</BODY>
</HTML>
<%
stmt.close();
cnct.close();
%>