你们说得我都改了！可是还是 晕哦
第一个页面
<html>
<head>
<title>一个留言本</title>
</head>
<body>
<form method ="post" action = "foxnoteinsert.jsp">
<br>姓名:
<input name = "username" size=15 value = "">
<br>邮箱:
<input name="email" size=15 value = "">
<br>
<br>
<textarea name = "doc" rows="5" cols ="40">
</textarea>
<br>
<input type=submit value="提交">
<input type=submit value="重填">
</form>
</body>
</html>
－－－－－－－－－－－－－－－－－－－－－－
第一个jsp页面
<body bgcolor = "#ffffff">
<%@page language="java" contentType="text/html; charset=gb2312" import= "java.sql.*,import=java.util.*"%>
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page">
<jsp:setProperty name ="myutil" property="*"/>
<jsp:useBean id ="userInfo" class="com.note.UserInfo" scope ="page">
<jsp:setProperty name ="userInfo" property ="*"/>
<jsp:useBean id ="regist" class="com.note.UserRegist" scope ="page">
<jsp:setProperty name = "regist" property ="*"/>
</jsp:useBean>
<%
String username = MyUtil.gb2312ToUnicode(request.getParameter("username"));
String email=MyUtil.gb2312ToUnicode(request.getParameter("email"));
String doc = MyUtil.gb2312ToUnicode(request.getParameter("doc"));
String url = request.getRemoteAddr();
regist.setUserInfo(userInfo);
regist.regist();
out.println("添加成功");
%>
－－－－－－－－－－－－－－－－－－－－－－－－－－－－
第二个jsp页面
<html>
<body>
<%@ page contentType="text/html;charset = gb2312" language = "java" import = "java.sql.*"%>
<%
Connection con = null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://10.0.0.38:1433;DatabaseName=foxtable";
String user="sa";
String password="sasa";
Connection con= DriverManager.getConnection(url,user,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select*from foxtable");
%>
<table border="1" width="100%" cellspacing="0" cellpadding="0"align="center" bordercolorlight="#CCCCFF" bordercolordark="#FFFFFF"＞
＜tr bgcolor="#FFFFFF"＞
＜td width="15%" height="25" align="center"＞＜i＞作者＜/i＞＜/td＞
＜td width="28%" height="25" align="center"＞＜i＞发表时间＜/i＞＜/td＞
＜td width="22%" height="25" align="center"＞＜i＞Email＜/i＞＜/td＞
＜td width="35%" height="25" align="center"＞＜i＞留言内容＜/i＞＜/td＞
<%
while(rs.next()){
out.println("<TR><td align=center><font size=2 color=#999999>"+rs.getString("作者")+"</TD>");
out.println("<TD><font size=2 color=#999999>"+rs.getString("Email")+</font></TD>");
out.println("<TD><font size=2 color=#999999>"+rs.getString("留言")+</font></TD>");
out.println("<TD><font size=2 color=#999999>"+rs.getString("URL")+</font></TD></TR>");
}
rs.close();
con.close();
}catch(Exception e){
out.println(e.getMessage());
}
%>
</table>
</body>
</html>
－－－－－－－－－－－－－－－－－－－－－－－－－
下面是3个javaBean
import java.io.*;
public class MyUtil{
public static String gb2312ToUnicode(String s){
try{
return new String(s.getBytes("ISO8859_1"),"gb2312");
}catch(UnsupportedEncodingException uee){
return s;
}
}
public static String unicodeTogb2312(String s){
try{
return new String(s.getBytes("gb2312"),"ISO8859_1");
}catch(UnsupportedEncodingException uee){
return s;
}
}
}
---------------------------------------
import java.util.Date;
public class UserInfo
{
private String username;
private String email;
private String doc;
private String url;
public String getUsername()
{
return this.username;
}
public String getEmail()
{
return this.email;
}
public String getDoc()
{
return this.doc;
}
public String getUrl()
{
return this.url;
}
}
--------------------------------------------------------
import java.sql.*;
import java.io.*;
import java.util.*;
public class UserRegist
{
private UserInfo userInfo;
private Connection con;
public UserRegist()
{
String url="jdbc:microsoft:sqlserver://10.0.0.38:1433;DatabaseName=foxtable";
String user="sa";
String password="sasa";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con= DriverManager.getConnection(url,user,password);
}catch(Exception e)
{
e.printStackTrace();
} }
public void setUserInfo(UserInfo userInfo)
{
this.userInfo=userInfo;
}
public void regist()throws Exception
{
String reg="insert into foxtable values(?,?,?,?);";
try
{
PreparedStatement pstmt=con.prepareStatement(reg);
pstmt.setString(1,userInfo.getUsername());
pstmt.setString(2,userInfo.getEmail());
pstmt.setString(3,userInfo.getDoc());
pstmt.setString(4,userInfo.getUrl());
pstmt.executeUpdate(); //do the process
pstmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
throw e;
}
}
}
-----------------------------------------------------------------
错误是这样的
当我查看foxnoteinsert.jsp这页时出现错误
org.apache.jasper.JasperException: /fox/foxnoteinsert.jsp(10,2) Unterminated <jsp:useBean tag
我用的是tomcat
由于小弟初学jsp请勿耻笑
谢谢 祝好心人，万事如意！
问题点数：0、回复次数：5Top
1 楼DreamDragon_NEU（梦龙）回复于 2005-04-01 16:47:58 得分 0
在foxnoteinsert.jsp这个文件里出现了不良好的格式，应该是<>的问题
出错行在第10行~~~Top
2 楼jFresH_MaN（十一月的萧邦－夜曲）回复于 2005-04-01 16:50:48 得分 0
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page">
你的所有useBean都没有在最后加/
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page"/>
Top
3 楼jFresH_MaN（十一月的萧邦－夜曲）回复于 2005-04-01 16:51:47 得分 0
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page">
<jsp:setProperty name ="myutil" property="*"/>
<jsp:useBean id ="userInfo" class="com.note.UserInfo" scope ="page">
<jsp:setProperty name ="userInfo" property ="*"/>
<jsp:useBean id ="regist" class="com.note.UserRegist" scope ="page">
<jsp:setProperty name = "regist" property ="*"/>
</jsp:useBean>
-------------------------修改成
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page"/>
<jsp:setProperty name ="myutil" property="*"/>
<jsp:useBean id ="userInfo" class="com.note.UserInfo" scope ="page"/>
<jsp:setProperty name ="userInfo" property ="*"/>
<jsp:useBean id ="regist" class="com.note.UserRegist" scope ="page"/>
<jsp:setProperty name = "regist" property ="*"/>
Top
4 楼pigo（）回复于 2005-04-01 17:00:12 得分 0
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page">
==>
<jsp:useBean id="myutil" class ="com.note.MyUtil" scope ="page"/>
注意看这两行的最后。
如果不是高手的话，还是用 jbuilder等开发工具写程序吧。
让开发工具来帮忙检查语法。Top
5 楼pigo（）回复于 2005-04-01 17:00:48 得分 0
jFresH_MaN(ＴＭ)
动作够快，早知道就不来了 ：（
Top
