jsp连接数据库,出现异常:[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
Microsoft SQL Server 2000 Driver for JDBC已经装好了,sp3的补丁也打了,问题还是一样,
真不知道怎么搞了,哪位大侠帮一下忙啊?课程设计就要交了啊!!谢谢了啊!
Microsoft SQL Server 2000 Driver for JDBC已经装好了,sp3的补丁也打了,问题还是一样,
真不知道怎么搞了,哪位大侠帮一下忙啊?课程设计就要交了啊!!谢谢了啊!
说是“由于登陆失败无法启动服务”
“发生错误1069-(由于登陆失败无法启动服务),此时正在MSSQLServer服务上执行该服务操作”
这个又是怎么回事啊!!大侠快来啊!!
就是:[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
这个怎么解决啊?
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" import="java.util.*" import="java.lang.*"%>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>准备答题</title>
<link href="img/cssexamin.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript" src="/myside/examin/img/youno.js"></script>
<style type="text/css">
<!--
.style1 {color: #FF0000}
.unnamed1 {
font-size: 12px;
color: #FF0000;
text-decoration: none;
}
-->
</style>
</head><body>
<div align="center">
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%
String userNow = request.getParameter("userid");String password=request.getParameter("password");
System.out.print(password);
%>
<%linejdbc.setdrivername();%>
<%
//通过传来的ID提取学生资料
Connection conn = linejdbc.getopenConnection();
PreparedStatement s = conn.prepareStatement
("select * from student where S_id=? and S_psw=?"); s.setString(1,userNow);
s.setString(2,password);
ResultSet result = s.executeQuery();
if (result.next())
{
String S_id = result.getString("S_id");
String S_name = result.getString("S_name");
String Sex=result.getString("sex");
String Major=result.getString("major");
String Grade=result.getString("grade");
%>
<%/*
//随机在学生所要考的科目中提取题库的ID
int romad = 0;
int t = 0;
int i = 0;Connection connn = linejdbc.getopenConnection();
PreparedStatement p = connn.prepareStatement
("select MAX(id) from quiz "); ResultSet resultp = p.executeQuery();
resultp.next();
t = resultp.getInt(1);
Random rand = new Random();
i = rand.nextInt(t);
romad = i + 1;
*/
%>错误报告如下:
500 Servlet Exception
java.lang.NullPointerException
at _jsp._onlineexam._reading__jsp._jspService(onlineExam/reading.jsp:34)
at com.caucho.jsp.JavaPage.service(JavaPage.java:63)
at com.caucho.jsp.Page.pageservice(Page.java:570)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:159)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:259)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:341)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
at java.lang.Thread.run(Thread.java:536)