jsp连接mysql数据库404报错

guo_xiao_lei221124 2015-07-23 09:56:34
代码

<pre class="html" name="code"><%@ page import ="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.mysql.jdbc.Driver" %>


<%@ page contentType="text/html; charset=GB2312" language="java" import="java.sql.*" errorPage="/WEB-INF/errorPage.jsp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>conn.jsp</title>
</head>
<body>
<%

String server="********";
String dbname="******";
String user="******";
String pass="******";
String port="3306";
String url=="jdbc:mysql://"+server+":"+port+"/"+dbname+"?user="+user+"&password="+pass+"&useUnicode=true&characterEncoding=GB2312"
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="SELECT * FROM shops_tbl;";
ResultSet rs=stmt.executeQuery(sql); //rs.first();
while(rs.next()){
out.print("用户ID:");
out.print(rs.getString("id")+" 名称:");
out.println(rs.getString("nname")+"<br>");
}
rs.close();
stmt.close();
conn.close();


错误信息
HTTP Status 404 - /connetmysql.jsp

type Status report

message /connetmysql.jsp

description The requested resource is not available.

Apache Tomcat/7.0.57


web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">


<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1"
metadata-complete="true">

<servlet>
<servlet-name>HelloWorld</servlet-name>
<servlet-class>HelloWorld</servlet-class>
</servlet>

<servlet>
<servlet-name>TKSearch</servlet-name>
<servlet-class>TKSearch</servlet-class>
</servlet>
<servlet>
<servlet-name>TKSearchFolder</servlet-name>
<servlet-class>TKSearchFolder</servlet-class>
</servlet>
<servlet>
<servlet-name>TKSearchHeadline</servlet-name>
<servlet-class>TKSearchHeadline</servlet-class>
</servlet>
<servlet>
<servlet-name>TKSearchItem</servlet-name>
<servlet-class>TKSearchItem</servlet-class>
</servlet>
<servlet>
<servlet-name>TKSearchShop</servlet-name>
<servlet-class>TKSearchShop</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>HelloWorld</servlet-name>
<url-pattern>/HelloWorld</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>TKSearch</servlet-name>
<url-pattern>/TKSearch</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>TKSearchFolder</servlet-name>
<url-pattern>/TKSearchFolder</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>TKSearchHeadline</servlet-name>
<url-pattern>/TKSearchHeadline</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>TKSearchItem</servlet-name>
<url-pattern>/TKSearchItem</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>TKSearchShop</servlet-name>
<url-pattern>/TKSearchShop</url-pattern>
</servlet-mapping>

</web-app>



请教高手如何解决
...全文
399 2 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
huoxin4415 2015-07-23
  • 打赏
  • 举报
回复
404错误应该是资源未找到,检查下访问路径是否正确或web配置
qqw6789567 2015-07-23
  • 打赏
  • 举报
回复
首先404和你的JSP暂时没关系,因为,你访问的东西,服务器更笨找不到东西,所以就谈不到连接数据库的问题! 先看下你的路径配置吧!

81,122

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧