中科新闻网qq三国您的账号被屏蔽:我用JDBC连接JSP页面时老是出错，您给我看看吧！
来源：百度文库 编辑：中科新闻网 时间：2024/04/30 03:51:30
register_confirm.jsp：
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<link rel=stylesheet href="style.css" type="text/css">
</head>
<body>
<center>
<%
String name=request.getParameter("name");
String query="select * from customer_info where name='"+name+"'";
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sDBDriver);
String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Web";
String username="sa";
String pwd="";
Connection connWeb=DriverManager.getConnection(sConnStr,username,pwd);
Statement stmt=connWeb.createStatement();
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
rs.close();
session.putValue("register_message","用户名已存在，请重新注册！");
%>
<jsp.forward page="register.jsp"/>
<% }
else
{
rs.close();
}
%>
<FORM METHOD=POST ACTION="do_register.jsp">
<tr>
<td bgcolor="#F5EFE7"> <table border="0" width="100%" cellspacing="1">
<tr>
<td width="100%" ><br>
<div align="center">
<center>
<table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
-->
亲爱的<%=name%>,请检查您的注册信息<br><br>
<TABLE width="60%" border="1">
<TABLE width="60%" border="1">
</TABLE>
<br>
<INPUT TYPE="submit" value="提交注册">
<INPUT TYPE="button" value="返回修改" onclick="history.back()">
</FORM>
</CENTER>
</BODY>
</HTML>
调用register_confirm.jsp时出现的错误：
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]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
… …
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
…
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
Apache Tomcat/5.0.28
一个测试程序运行后出现的结果：
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指
定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
… …
at DbTest.main(DbTest.java:38)
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<link rel=stylesheet href="style.css" type="text/css">
</head>
<body>
<center>
<%
String name=request.getParameter("name");
String query="select * from customer_info where name='"+name+"'";
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sDBDriver);
String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Web";
String username="sa";
String pwd="";
Connection connWeb=DriverManager.getConnection(sConnStr,username,pwd);
Statement stmt=connWeb.createStatement();
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
rs.close();
session.putValue("register_message","用户名已存在，请重新注册！");
%>
<jsp.forward page="register.jsp"/>
<% }
else
{
rs.close();
}
%>
<FORM METHOD=POST ACTION="do_register.jsp">
<tr>
<td bgcolor="#F5EFE7"> <table border="0" width="100%" cellspacing="1">
<tr>
<td width="100%" ><br>
<div align="center">
<center>
<table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
-->
亲爱的<%=name%>,请检查您的注册信息<br><br>
<TABLE width="60%" border="1">
<TABLE width="60%" border="1">
</TABLE>
<br>
<INPUT TYPE="submit" value="提交注册">
<INPUT TYPE="button" value="返回修改" onclick="history.back()">
</FORM>
</CENTER>
</BODY>
</HTML>
调用register_confirm.jsp时出现的错误：
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]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
… …
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
…
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
Apache Tomcat/5.0.28
一个测试程序运行后出现的结果：
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指
定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
… …
at DbTest.main(DbTest.java:38)
我用JDBC连接JSP页面时老是出错，您给我看看吧！
用JDBC连接JSP页面时出现的错误，高手们给看看吧！
用JDBC连接JSP页面时出现的错误，高手们给看看吧！
JSP用ODBC-JDBC桥连接SQL Server
jsp如何连接数据库？JDBC的配置？
请问在JSP中连接JDBC时，如果想用windows登陆SQL，user部分要怎么写？
jdbc在jsp下不好用
有关Jsp连接Access以及JDBC,SQL的问题
用jdbc连接数据库时出现java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrive
jsp连接数据库oracle 出错