它的79行是指你的JSP文件生成的servlet类的79行,可以到tomcat\work\里找到这个文件
你想知道什么错误得贴出你的代码
你想知道什么错误得贴出你的代码
解决方案 »
- SSH 实现单点登录
- 关于request前台jsp页面设置 后台获取的问题
- struts2多语言咋个实现?
- hibernate 和 struts兄弟们帮我看看,这个问题我想哭~~!
- 求教:想做个JSP小型网站练练手,大家知道哪里有免费的空间吗?
- 哪位帮我看下这段代码
- 超级菜鸟问题,jsp公共方法(.class文件)应该放到哪儿啊~
- 让我们一起成为高手!
- 做的项目在本地访问正常,上传到远程服务器后所有servlet跳转路径都报404
- 类似QQ右下角弹出消息框代码
- 想问问:jdbc的驱动要怎么装的?我写的一个java程序连接不了db2数据库.我想用纯jdbc的方法连接db2数据库,哪位高手会?请指教.谢谢!
- 【请问】如何用jsp画饼图,在论坛上搜索了半天也没找到满意的答案,分不够再开贴给,谢...
1.index.html
<html>
<head>
<title>糺ìÁ÷ÑÔ°æ</title>
</head>
<body bgcolor="#ccccff" vlink="#000000" alink="#666666">
<div align="center">
<p><font size="7">
<b><font size="+6">糺ìæäÕ¾</font></b>
</font></p>
<form method="post" action="index.jsp">
<table widt="%75" align="center" border=1>
<tr>
<td width="30%">
<div align="right">ÐÕÃû:</div>
</td>
<td width="70%">
<input type="text" name="name">
</td>
</tr>
<tr>
<td width="30%">
<div align="right">µç×ÓÓʼþ:</div>
</td>
<td width="70%">
<input type="text" name="email">
</td>
</tr>
<tr>
<td width="30%">
<div align="right">¸öÈËÖ÷Ò³µØÖ·:</div>
</td>
<td width="70%">
<input type="text" name="url" value="http://">
</td>
</tr>
<tr>
<td width="%30">
<p>ÇëÄãÁôÑÔ:</p>
</td>
<td width="70%" >
<textarea name="body" rows="5" cols="30"></textarea>
</td>
</tr>
<tr>
<td width="30%"> </td>
<td width="70%"> </td>
</tr>
<tr>
<td width="30%"> </td>
<td width="70%">
<table width="75%">
<tr>
<td>
<input type="submit" name="send" value="Ìá½»">
</td>
<td>
<input type="reset" name="reset" value="ÖØÖÃ">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<hr>
</div>
</body>
</html>
<html>
<head>
</head>
<body>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="sqldata.SqlData;" %>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="sqlbean" class="SqlData" scope="session">
<jsp:setProperty name="sqlbean" property="*" />
</jsp:useBean>
<%! String name,email,url,body,sql;%>
<%
name=request.getParameter("name");
email=request.getParameter("email");
url=request.getParameter("url");
body=request.getParameter("body");
if(name!=""&&email!=""&&body!="")
{ sql="insert into guestbook(name,email,url,body)values('"+name+"','"+email+"','"+url+"','"+body+"')";
sqlbean.executeInsert(sql);
}
else
{
out.print("<b><font color=red>Sorry,please enter your name,email and body!!!</font></b>");
}
%>
<%
ResultSet RScount = sqlbean.executeQuery("select * from guestbook");
int i = 0;
while(RScount.next())
{
i++;
}
%>
<%-- <p><a name=see><b>Now, <%= RScount %> Records.</b></a></p> --%>
<p><b>ÏÖÔÚÓÐ<%= i %> Ìõ¼Ç¼</b></p>
<%
RScount.close();
i=0;
%>
<p> </p>
<%
ResultSet RS=sqlbean.executeQuery("Select * from guestbook");
while(RS.next())
{
name=RS.getString("name");
email=RS.getString("email");
url=RS.getString("url");
body=RS.getString("body");
%>
<table border=1 width=80% >
<tr>
<td width=30% >ÄسÆ:</td><td width=70% ><%=name%>
</tr>
<tr>
<td width=30%>µç×ÓÓʼþ:</td><td width=70%>
<a href="mailto:<%=email%>"><%=email%></a></td>
</tr>
<tr>
<td width=30%>¸öÈËÖ÷Ò³µØÖ·:</td><td width=70%>
<a href="<%=url%>"><%=url%></a></td>
</tr>
<tr>
<td width=30% >ÄÚÈÝ:</td><td width=70%><%=body%></td>
</tr>
</table>
<hr>
<%
}
RS.close();
%>
</body>
</html>
package sqldata;
import java.sql.*;public class SqlData
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnstr = "jdbc:odbc:guestbook";
Connection conn = null;
ResultSet rs = null;
public SqlData(){ try {
Class.forName(sDBDriver);
System.out.println("Success loading JDBC-ODBC Bridge Driver...\n");
} catch(ClassNotFoundException e ) {
System.out.println("Error loading JDBC-ODBC Bridege Driver...\n");
}
} public void executeInsert(String sql) {
try {
conn = DriverManager.getConnection(sConnstr);
System.out.println("Success eastabllishing the Connection...\n");
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
} catch(SQLException e) {
System.err.println("sql_data.executeUpdate:" + e.getMessage());
}
} public ResultSet executeQuery(String sql) { rs = null;
try {
conn = DriverManager.getConnection(sConnstr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch(SQLException e) {
System.err.println("sql_data.executeQuery:" + e.getMessage());
} return rs;} public void executeDelete( String sql) { try {
conn = DriverManager.getConnection(sConnstr);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
} catch(SQLException e) {
System.err.println("sql_data.executeDelete:" + e.getMessage());
}
}}