注册 登录
编程论坛 J2EE论坛

[求助]数据库连接出错,谢谢

sy8000 发布于 2007-07-04 16:25, 811 次点击

为什么我写的总是连接出错,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>


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

9 回复
#2
enlangs2007-07-04 18:28
把错误信息贴出来看下。。
#3
风月_无边2007-07-04 20:12
用户名和密码呢 !?
#4
sy80002007-07-04 22:11

<%@ 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

#5
しΟν∈→鱈2007-07-05 09:27
错误代码呢?
#6
SamQ2007-07-05 09:32

错误代码用红色贴出来!
#7
食恶不色2007-07-05 11:33
你鏈接的應該沒錯。。你的包有導入嗎?
還有錯誤的代碼帖出來,,才能知道什么錯誤。
#8
sy80002007-07-06 11:59

谢谢啊,错误信息如下:
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.


#9
hardes2007-07-06 14:51
先调试下吧
那什么.."jdbc:microsoft:sqlserver://JUJUMAO:1433;DatabaseName=jssqdbo","sa","fssy_118"
就别弄这东西了,赶紧换了啊107.0.0.1或localhost.
还有啊,那什么
String sql="select * from user_info where user_bm='"+ username +"'";
sql+= " and user_pwd='"+ password +"'";
ResultSet rs=stmt.executeQuery(sql);
///////////////////////////////////
if( rs.next() ){
我怎么看着有点象asp里头的写发啊,正规点搞事情好不好老大!参数换了全部用?表示,在拿那什么stm.setxx()方法进行参数绑定啊,不怕别人数据库注入吗?
唉!!





#10
しΟν∈→鱈2007-07-06 17:56
Unable to connect. Invalid URL
E文不明白,就是说你的URL也就是jdbc:microsoft:sqlserver://JUJUMAO
:1433;DatabaseName=jssqdbo","sa","fssy_118"这些东西有问题
1