| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 802 人关注过本帖
标题:[求助]数据库连接出错,谢谢
取消只看楼主 加入收藏
sy8000
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2007-7-4
收藏
 问题点数:0 回复次数:2 
[求助]数据库连接出错,谢谢

为什么我写的总是连接出错,tomcat 5.0,提示http500错误,数据库是mysql,我都是照书写的啊?代码如下,十分谢谢!!!
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Test Connect to MySQL</title>
</head>
<body>
sdkjfsladjflkasjfl;kajs
<% String Drv="org.git.mm.mysql.Driver";
String Jdbc="jdbc:mysql://localhost:3306";
String admin="root";
String pwd="fssy_118";
String sql="select * from user_info";

try{
Class.forName(Drv).newInstance();
Connection conn=DriverManager.getConnection(Jdbc);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
out.println("11111111111111111");
}else{
out.println("2222222222222222");
}
}catch(SQLException e){
e.getSQLState();
}
%>
</body>
</html>


连接部分有错吗?谢谢了,十分感谢!!

搜索更多相关主题的帖子: 数据库 
2007-07-04 16:25
sy8000
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2007-7-4
收藏
得分:0 

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>系统正在验证...</title>
</head>
<body>
<%
String username=request.getParameter("uid");
String password=request.getParameter("upwd");
if(username!=null && !username.equals("")){
try{
//开始尝试连接mssql,jssqdbo库
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://JUJUMAO:1433;DatabaseName=jssqdbo","sa","fssy_118");
Statement stmt=conn.createStatement();
//开始定义user_info表中字段与登录进行比较
String sql="select * from user_info where user_bm='"+ username +"'";
sql+= " and user_pwd='"+ password +"'";
ResultSet rs=stmt.executeQuery(sql);
///////////////////////////////////
if( rs.next() ){
session.setAttribute("login","ok"); //验证通过之后,跳转到后续页面
session.setAttribute("uname",username);
%>
<jsp:forward page="main.jsp"/>
<%
}else //错误用户名、密码的处理
out.println("错误的用户名或密码!");
out.println("<a href=index.html>返回</a>");

}catch(Exception ee){
ee.printStackTrace();
}
}else{

out.println("请先登录!");
out.println("<a href=index.html>返回</a>");
}
%>

</body>
</html>不好意思,贴错了,是tomcat5.0+sqlserver2000

2007-07-04 22:11
sy8000
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2007-7-4
收藏
得分:0 

谢谢啊,错误信息如下:
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.index_jsp._jspService(index_jsp.java:88)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)


root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.index_jsp._jspService(index_jsp.java:56)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)


note The full stack trace of the root cause is available in the Tomcat logs.


2007-07-06 11:59
快速回复:[求助]数据库连接出错,谢谢
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.011507 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved