<%@page contentType="text/html"%>
<%@page language="java.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.util.Date"%>
<%@page import="java.sql.*"%>
<%@page import="java.net.*"%>
<%@page import="java.text.*"%><%!
//--------------------------
//留言删除程序rease.jsp
//---------------------------
//判断是否是管理员的IP
String WebmasterIP="192.168.0.188";//管理人员的计算机IP
String RemoteAddr=new String();
RemoteAddr=request.getRemoteAddr();
if(RemoteAddr.equals(WebmasterIP))
{
String url=new String();
url="jdbc:odbc:jspdb";
try
{
//连接数据库
Class.forName("sun.jdbc.odbc.JdbcOdbcDrier");
}
catch(java.lang.ClassNotFoundException ae)
{
System.err.println("ae:"+ae.getMessage());
} Connection conn=DriverManager.getConnection(url,"sa","");
PreparedStatement prestmt=null;
String strSQL;
try
{
strSQL="UPDATE guestbook SET flag=0 WHERE ID=?";
prestmt=conn.prepareStatement(strSQL);
prestmt.setString(1,request.getParameter("id"));
prestmt.execute Update();
}
catch(Exception de)
{
System.err.print("de.executeQuery:"+de.getMessage());
}
conn.close();
}
//将网页重定向到“游览“的网页indext.jsp
response.sendRedirect("http://localhost:8080/star/guestbook2/index.jsp")
%>
<%@page language="java.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.util.Date"%>
<%@page import="java.sql.*"%>
<%@page import="java.net.*"%>
<%@page import="java.text.*"%><%!
//--------------------------
//留言删除程序rease.jsp
//---------------------------
//判断是否是管理员的IP
String WebmasterIP="192.168.0.188";//管理人员的计算机IP
String RemoteAddr=new String();
RemoteAddr=request.getRemoteAddr();
if(RemoteAddr.equals(WebmasterIP))
{
String url=new String();
url="jdbc:odbc:jspdb";
try
{
//连接数据库
Class.forName("sun.jdbc.odbc.JdbcOdbcDrier");
}
catch(java.lang.ClassNotFoundException ae)
{
System.err.println("ae:"+ae.getMessage());
} Connection conn=DriverManager.getConnection(url,"sa","");
PreparedStatement prestmt=null;
String strSQL;
try
{
strSQL="UPDATE guestbook SET flag=0 WHERE ID=?";
prestmt=conn.prepareStatement(strSQL);
prestmt.setString(1,request.getParameter("id"));
prestmt.execute Update();
}
catch(Exception de)
{
System.err.print("de.executeQuery:"+de.getMessage());
}
conn.close();
}
//将网页重定向到“游览“的网页indext.jsp
response.sendRedirect("http://localhost:8080/star/guestbook2/index.jsp")
%>
错误是:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain~~~~~~~~~~========================index.jsp的内容如下!================================
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.net.*"%><%
//---------------------
//留言显示程序index.jsp
//------------------------//判断是否是管理员的IP
String WebmasterIP="192.168.0.188";
boolean IsWebmasterIP=false;
String RemoteAddr=new String();
RemoteAddr=request.getRemoteAddr();
if(RemoteAddr.equals(WebmasterIP))
{
IsWebmasterIP=true;
}int intPageSize;//一页显示的记录数
int intRowCount=5;//记录总数
int intPageCount;//总页数
int intPage;//特显示页码
String strPage;int i;//设置一页显示的记录数
intPageSize=5;//取得特显示页码
strPage=request.getParameter("page");
if(strPage==null)
{
//表明在QueryString中没有PAGE这个参数,此时显示第一页数据
intPage=1;
}
else
{
//将字符串转换成整型
intPage=Integer.parseInt(strPage);
if(intPage<1)intPage=1;
}//连接数据库
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException ae)
{
System.err.println("ae:"+ae.getMessage());
}
String sConnStr="jdbc:odbc:jspdb";
Connection conn=null;
conn=DriverManager.getConnection(sConnStr,"sa","");
String strSQL;//SQL语句
strSQL="selsct * from guestbook WHERE flag=1";
Statement stmt=
conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet result=null;
try
{
result=stmt.executeQuery(strSQL);
}
catch(SQLException be)
{
System.err.println("be.executeQuery:"+be.getMessage());
}result.last();
intRowCount=result.getRow();//计算总页数
intPageCount =(intRowCount+intPageSize-1)/intPageSize;//调整待显示的页码
if(intPage>intPageCount)intPage=intPageCount;%>
<html>
<head>
<meta content="text/html; charset=gb2312" http-equiv=Content-Type>
<title>留言显示</title>
</head><body bgcolor=pink>
<center>
<h4>留言列表<h4/>
<table border="1" cellspacing="2" cellpadding="5">
<tr>
<%
if(IsWebmasterIP)
{
out.println("<th>留言管理</th>");
}
%>
<th>留言者</th>
<th>留言者登录IP</th>
<th>Email地址</th>
<th>留言内容</th>
<th>留言日期</th>
</tr>
<%
out.println("<a href=addmsg.jsp>新增留言...</a><p>\n");
if(intPageCount>0)
{
//将记录指针定位到待显示的第一条记录上
try
{
result.absolute(intPage-1*intPageSize+1);
}
catch(Exception e)
{
out.println("error."+e.getMessage());
}
//显示数据
i=0;
while(i<intPageSize&&!result.isAfterLast())
{
%>
<tr>
<%
if(IsWebmasterIP)
{
out.println("<td><a href=erase.jsp?id="+result.getString(1)+">删除本篇</a></td>");
}
%>
<td><%=result.getString(2)%></td>
<td><%=result.getString(3)%></td>
<td><%=result.getString(4)%></td>
<td><%=result.getString(5)%></td>
<td><%=result.getString(6)%></td>
</tr>
<%
result.next();
i++;
}
}%>
</table>
<br>
<%
//断开数据库连结
result.close();
conn.close();
%>第<%=intPage%>页
共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="index.jsp?page=<%=intPage+1%>">下一页</a><%}%>
<%if(intPage>1){%>
<a href="index.jsp?page=<%=intPage-1%>">上一页</a><%}%>
</center>
</body>
</html>
哪来的这东西"java.*"??
删了这句话就没事了
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter检查你的classpath
出现有错误如下:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: /star/guestbook2/addmsg.jsp(1,0) jsp.error.language.nonjava
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:428)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:140)
at org.apache.jasper.compiler.Validator$PageDirectiveVisitor.visit(Validator.java:144)
at org.apache.jasper.compiler.Node$PageDirective.accept(Node.java:280)
at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:1028)
==========================addmsg.jsp================================
<%@ page contentType="text/html"%>
<%@page language="java.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.util.Date"%>
<%@page import="java.sql.*"%>
<%@page import="java.net.*"%>
<%@page import="java.text.*"%><%!
//--------------------------
//新增留言程序addmsg.jsp
//---------------------------
//中文处里函数
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
}
return "null";
}
%>
<%
if(request.getParameter("submiting")!=null)
{
String alias=null;
String email=null;
String msg=null;
alias=request.getParameter("alias");
email=request.getParameter("email");
msg=request.getParameter("msg"); String ip=request.getRemoteAddr();
String flag="1";
Date currTime=new Date();
SimpleDateFormat formatter=new SimpleDateFormat("yyyy/MM/dd a hh:mm:ss",Locale.US);
String adate=formatter.format(currTime); if((alias.length()>0)&&(msg.length()>0)&&(msg.length()>0))
{
String url=new String();
url="jdbc:odbc:jspdb";
try
{
//连接数据库
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException ae)
{
System.err.println("ae:"+ae.getMessage());
} Connection conn=DriverManager.getConnection(url,"sa","");
PreparedStatement prestmt=null;
String strSQL;
try
{
strSQL="insert into guestbook(Username,IP,Email,Comment,Mydate,flag)values(?,?,?,?,?,?)";
prestmt=conn.prepareStatement(strSQL);
prestmt.setBytes(1,alias.getBytes("GBK"));
prestmt.setBytes(2,ip.getBytes());
prestmt.setBytes(3,email.getBytes("GBK"));
prestmt.setBytes(4,msg.getBytes("GBK"));
prestmt.setBytes(5,adate.getBytes("GBK"));
prestmt.setBytes(6,flag.getBytes());
prestmt.executeUpdate();
}
catch(Exception de)
{
System.err.print("de.executeQuery:"+de.getMesssage());
}
conn.close();
//将网页重定向到“浏览留言”的网页index.jsp
response.sendRedirect("http://localhost:8080/star/guestbook2/index.jsp");
}
else
{
out.println("不能输入空白项");
return;
}
}
else
{
<%
<html>
<head>
<meat http-equiv="Content-Type"content="text/html;charset=gb2312">
<title>填写留言</title>
</head>
<body bgcolor=ffffff>
<form method=POST action="http://localhost:8080/star/guestbook2/addmsg.jsp">
<table border=0 cellpadding=2 width=395>
<tr>
<td nowrap><font color=004080>姓名:</font></td>
<td width=20><input type=text name=alias size=8></td>
<td nowrap><font color=004080>电子邮件</font></td>
<td width=50><input type=text name=email size=18></td>
</tr>
<tr>
<td nowrapvalign=top><font color=004080>留言内容</font></td>
<td width=80% colspan=3><textarea rows=5 name=msg cols=33></textarea></td>
</tr>
<tr>
<td width=100% colspan=4 align=center>
<input type=submit name=submiting value="送出留言">
<input type=reset value="擦掉留言">
</td>
</tr></table>
</form></body></html>
<%
}
%>
你怎么每一页里都有这个东西啊
<%@page language="java.*"%>要么删了
要么改成:
<%@ page language="java"%>
删了更方便些
<%@ page language="java"%>
会出现
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:139: illegal start of expression
<%
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:143: illegal character: \180
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:151: illegal character: \215
碌莽????录镁
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:151: illegal character: \188
碌莽????录镁
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:165: ';' expected
<%
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:125: cannot resolve symbol
symbol : method getMesssage ()
location: class java.lang.Exception
System.err.print("de.executeQuery:"+de.getMesssage());
^
6 errors要是删了就没有事了!就是驱动的事了·!
你问我是西电的吗??
我不是!
应该是不会出错的啊
既然出错就删了吧
那句话没什么用的classpath的设置:
(假设你的jdk是在C:\jdk下;tomcat是在C:\tomcat下,不是就自己改成你的目录)
如果是win98,把下面这句话放到autoexec.bat里
set classpath = .;C:\jdk\lib\tools.jar;C:\jdk\lib\dt.jar;C:\tomcat\common\lib\servlet.jarwin2000的话,我的电脑--属性--高级--环境变量
看看有没有classpath这个东西,没有就自己建一个,把等于号后面的哪些东西复制进去就可以了
上的<%@page language="java.*"%>全删就会是: org.apache.jasper.JasperException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
这个错误。如果把http://localhost:8080/star/guestbook2/addmsg.jsp
上的<%@page language="java.*"%>全删出现的错误是: org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:138: illegal start of expression
<%
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:142: illegal character: \180^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:150: illegal character: \215
碌莽????录镁
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:150: illegal character: \188
碌莽????录镁
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:164: ';' expected
<%
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:124: cannot resolve symbol
symbol : method getMesssage ()
location: class java.lang.Exception
System.err.print("de.executeQuery:"+de.getMesssage());
^
6 errors如果少一个.*会出现的错误是:
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
[javac] Compiling 1 source fileC:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:139: illegal start of expression
<%
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:143: illegal character: \180^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:151: illegal character: \215
碌莽????录镁
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:151: illegal character: \188
碌莽????录镁
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:165: ';' expected
<%
^An error occurred at line: 30 in the jsp file: /star/guestbook2/addmsg.jspGenerated servlet error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\star\guestbook2\addmsg_jsp.java:125: cannot resolve symbol
symbol : method getMesssage ()
location: class java.lang.Exception
System.err.print("de.executeQuery:"+de.getMesssage());
^
6 errors如果删了<%@page language="java.*"%>的话,会出现的错误的如下:
org.apache.jasper.JasperException: /star/guestbook2/addmsg.jsp(1,0) jsp.error.language.nonjava下面这个http://localhost:8080/star/guestbook2/erase.jsp
出现的情况和addmsg.jsp的一样!
帮我看一下行吗??
值是:c:\j2sdk1.4.1_01\libp 这个路径,
你说的:“把等于号后面的哪些东西复制进去就可以了”哪有等于号??
第二行开头那里
你先拷进去吧,我再看看你的jsp页面
index.jsp里,select语句的select都能写错addmsg.jsp里,
与最下面的if语句匹配的else后少东西了
else
{
%>//你少了这个东西
<html>
.....erase.jsp没有数据,没法看
你先运行看看吧
改成toString()吧还有erase.jsp里,
prestmt.execute Update();
中间多了个空格
C:\Program Files\Apache Group\Tomcat 4.1\common\lib下是.JAR的文件。我在“系统特性”下的“环境变量”中的
“Administrator的用户变量”下新建了一个变量“path”值为:
c:\j2sdk1.4.1_01\bin;c:\j2sdk1.4.1_01;c:\j2sdk1.4.1_01\bin;c:\j2sdk1.4.1_01
在“系统变量”下新建变量“classpath”值为:
C:\j2sdk1.4.1_01\lib\tools.jar;C:\j2sdk1.4.1_01\lib\dom.jar
为样对吗??
对的话再怎么样?
我不跟你说了吗,要把
.;C:\jdk\lib\tools.jar;C:\jdk\lib\dt.jar;C:\tomcat\common\lib\servlet.jar
这些改成你的配置后复制进去
算了我帮你改吧
path你以前系统里有这个变量的,删了,找到path变量,在最后加上:
;c:\j2sdk1.4.1_01\bin
classpath这样定义:
.;C:\j2sdk1.4.1_01\lib\tools.jar;C:\j2sdk1.4.1_01\lib\dt.jar
直接拷贝,不要再乱改了
都改完后,重启tomcat,然后启动你的jsp
没问题的话index.jsp应该是可以出来的
http://localhost:8080/star/guestbook2/addmsg.jsp可以出来了!但为什么看不到中文的呢?
而全是乱码呢?
classpath这样定义:
.;C:\j2sdk1.4.1_01\lib\tools.jar;C:\j2sdk1.4.1_01\lib\dt.jar
DT.JAR
好像没有哦!!可以这样写上去吗??
tomcat也已经重起了!
if(!ss.equals("")){
byte[] inputBytes = ss.getBytes("8859_1");
ss=new String(inputBytes,"GB2312");}
else
ss="";
return ss;
}//end
<%@ page contentType="text/html; charset=GBK" %>
你从哪下的jdk?
重新下一个再安一次,有可能你的jdk不全
如果上不了国外的网站,
就去www.skycn.com找找吧
按下面的加上就可以了
<%@ page contentType="text/html; charset=gb2312"%>
就加了个<%@ page contentType="text/html; charset=gb2312"%>
dt.jar有的!找到了!
你没安装tomcat,到哪启动jsp去???
你以前的jsp页面是怎么运行的??
你的tomcat启动后能看到那个dos窗口就可以了
你的addmsg可以运行,那index.jsp是不是在同一个目录下?
如果是,那应该也是可以运行的,如果不行把错误信息贴出来
你的addmsg可以运行,index.jsp是在同一个C:\Program Files\Apache Group\Tomcat 4.1\webapps\ROOT\star\guestbook2目录下
http://localhost:8080/star/guestbook2/index.jsp运行的错误如下:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
例如set java_home="C:\j2sdk"
set tomcat_home="C:\Tomcat4.1"至于500错误,我认为可能是你的ODBC数据源没有设置,去控制面板的管理工具下的数据源看看吧。
米有其他办法了
或者重新配一个数据源重新链接试试
我在我机子上随便找了个数据源都是好的(sql语句要改的),index.jsp可以出东西
还有就是要注意什么?
谢谢!
你有没有发过来呀??我怎么还收不到的呀??
要不再不行,就不发我公司的邮箱了!发私人邮箱了!
[email protected]
偶都米有注意配数据源:
管理工具--数据源ODBC
用户DSN,添加
选你的数据库(如sqlserver)
填个name,随便,要和jsp里调用的一致
选server,本机就选(local)
然后选NT认证(不要选sqlserver认证)
改默认数据库为你的数据库
然后下一步,完成,就ok了
完成后有个测试的按钮
按一下看看有没有测试成功,成功了去试试jsp看看能不能连上
ps:楼主要多补基本知识,基础太差
配数据源:
管理工具--数据源ODBC
用户DSN,添加
选你的数据库(sql server)
填个name,叫guesbook
选server,本机就选(local)
然后选NT认证(不要选sqlserver认证)
改默认数据库为你的数据库,选 guesbook
然后下一步,完成,就ok了
完成后有个测试的按钮
按一下看了测试成功了,成功了试了jsp却不能连上!
to:fft123,因为没有学过JSP现在公司要我现在开始摸索一下,就从做一个小程序开始,以小换大,因为没有人带,他们也很忙的,所以我就来问人了!书上和实际操作有点不一样的!
所以书本只能是辅带的!上手是重要的!因为没有JSP的基础,所以有点累!还好有那么多有经验热心的程序员哥哥帮我!谢谢!
String sConnStr="jdbc:odbc:guestbook";改过没有??
下填入:姓名,电子邮件,留言内容,后点击送出留言的话,
会出现错误:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)还有,index.jsp还是不行!
这句“Class.forName("sun.jdbc.odbc.JdbcOdbcDrier");”
-------------------------------------------^^^^^