jdk,tomcat,sql server2000都已经装好并测试成功.
我在另一个测试中却碰到了问题,我是菜鸟,请各位师兄指教.
程序如下:<%@ page contentType="text/html; charset=gb2312" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<!--导入结束-->
<html>
<head>
<title>数据库连接实验</title>
</head>
<body>
<%
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "Jdbc:Odbc:try";//“try”的意思就是与刚才设置的数据源名对应;
Connection Con = null;
Statement Stmt = null;
try
{
try /*加载驱动程序*/
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try /*建立连接*/
{ Con = DriverManager.getConnection(sConnStr,"sa","sa");
}
catch(SQLException e)
{
out.print(e.toString());
}
Stmt = Con.createStatement();/*创建JDBC声明*/
String query="CREATE TABLE GUEST" + /*在数据库中创建新的表*/
"(NUM VARCHAR(32),"+
"USERNAME TEXT,"+
"CONTENT TEXT,"+
"PASSWORD INTEGER,"+
"TOTAL INTEGER,"+
"REALNAME TEXT)";
Stmt.executeUpdate(query); /*更新数据库*/
}
catch (Exception e) {}
out.println("恭喜,表连接创建成功!");
Stmt.close();
Con.close();
%>
</body>
</html>
可是却出现如下问题:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.dbprogram_jsp._jspService(dbprogram_jsp.java:104)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
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.30 logs.请高手多多指教,急!!!
我在另一个测试中却碰到了问题,我是菜鸟,请各位师兄指教.
程序如下:<%@ page contentType="text/html; charset=gb2312" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<!--导入结束-->
<html>
<head>
<title>数据库连接实验</title>
</head>
<body>
<%
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "Jdbc:Odbc:try";//“try”的意思就是与刚才设置的数据源名对应;
Connection Con = null;
Statement Stmt = null;
try
{
try /*加载驱动程序*/
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try /*建立连接*/
{ Con = DriverManager.getConnection(sConnStr,"sa","sa");
}
catch(SQLException e)
{
out.print(e.toString());
}
Stmt = Con.createStatement();/*创建JDBC声明*/
String query="CREATE TABLE GUEST" + /*在数据库中创建新的表*/
"(NUM VARCHAR(32),"+
"USERNAME TEXT,"+
"CONTENT TEXT,"+
"PASSWORD INTEGER,"+
"TOTAL INTEGER,"+
"REALNAME TEXT)";
Stmt.executeUpdate(query); /*更新数据库*/
}
catch (Exception e) {}
out.println("恭喜,表连接创建成功!");
Stmt.close();
Con.close();
%>
</body>
</html>
可是却出现如下问题:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.dbprogram_jsp._jspService(dbprogram_jsp.java:104)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
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.30 logs.请高手多多指教,急!!!
解决方案 »
- struts 2中action取页面request对象中的对象能取出来么?
- 这个是什么错误.
- 关于span
- 一个jdbc连接SQL数据库问题,安装配置好了SQL的JDBC驱动 起大哥们帮忙在线等
- jsp:入门--对数据库的操作
- SSH启动报错
- JSP中如何快速地显示服务器上的文件?详细过程,在线等待。。。。。。。
- fckeditor 上传图片动态返回问题
- 想学java,选择工具,不知jbuilder和eclipse哪个好,有优势
- 登录页面登录成功后如何让其他页面访问到用户名,我把用户名放入session但读取时为null?希望大家能给点建议啊
- 想找java web方面开发的实习机会
- 朋友们:帮个忙!!!(有关jsp的问题)
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<!--导入结束-->
<html>
<head>
<title>数据库连接实验</title>
</head>
<body>
<%
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "Jdbc:Odbc:try";//“try”的意思就是与刚才设置的数据源名对应;
Connection Con = null;
Statement Stmt = null;
try
{
try /*加载驱动程序*/
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Load driver error " + e.getMessage());
throw e ;
}
try /*建立连接*/
{ Con = DriverManager.getConnection(sConnStr,"sa","sa");
}
catch(SQLException e)
{
out.print("Connect error"+e.toString());
throw e ;
}
Stmt = Con.createStatement();/*创建JDBC声明*/
String query="CREATE TABLE GUEST" + /*在数据库中创建新的表*/
"(NUM VARCHAR(32),"+
"USERNAME TEXT,"+
"CONTENT TEXT,"+
"PASSWORD INTEGER,"+
"TOTAL INTEGER,"+
"REALNAME TEXT)";
Stmt.executeUpdate(query); /*更新数据库*/
out.println("恭喜,表连接创建成功!");
}
catch (Exception e) {
out.println(e.toString());
out.println(":( ,数据库操作失败!");
} finally{
if(Stmt!=null){
Stmt.close();
Stmt = null ;
}
if(Conn!=null){
Conn.close();
Conn = null ;
}
}
%>
</body>
</html>
"运行我的这个试试,看有什么异常"我运行了,抛出异常, Connect errorjava.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 :( ,数据库操作失败!
安装jdbc驅動包驱动的三个包放在你项目的WEB-INF/lib/下,最好放common/lib/下
dt.jar;
msbase.jar;
mssqlserver.jar;
-----------------------------------------------------
在环境变量里设置CLASSPATH:
.;C:\jdk1.5\lib\tools.jar;C:\jdk1.5\lib\dt.jar;
C:\jdk1.5\jre\lib\rt.jar;C:\jdk1.5\lib\msbase.jar;
C:\jdk1.5\lib\msutil.jar;C:\jdk1.5\lib\mssqlserver.jar;
%Tomcat_Home%\common\lib\servlet-api.jar;
-------------------------------------------------------
在控制面板--->管理工具-->数据源 (ODBC)-->系统DSN-->设置的数据源名try