Re: [問題] 請各位寫網頁的高手幫我解答一下
※ 引述《woo72042829 (果粒)》之銘言：
: 這是我用JSP寫的網頁
: <%@ page contentType="text/html;charset=big5" %>
: <%@ page language="java" %>
: <%@ page import="java.sql.*, java.util.*" %>
: <HTML>
: <HEAD>
: <TITLE>XXXXX</TITLE>
: </HEAD>
: <BODY>
: <%
: String DBDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
: String
: DBLocation="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=HIT-IMHB";
: //HIT-IMHB就是要連接的數據庫名
: String DBUser="sa";
: String DBPwd="sa";
: String url= DBLocation+"?user="+DBUser+"&password="+DBPwd;
: Class.forName(DBDriver);
: Connection con=DriverManager.getConnection(url);
: Statement stmt = con.createStatement();
: stmt.executeUpdate(sql);
: stmt.close();
: con.close();
: 這是我要用JSP連SQL Server 2008 的
: 請問各位高手 我這樣寫法是正確的嗎?
: 因為我執行一直有錯誤
: 謝謝
後來我參考網路上的寫法
寫法也很奇怪
String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String sConnStr =
"jdbc:sqlserver://localhost:1433;DatabaseName=HIT-IMHB";
Connection Con = null;
Statement Stmt = null;
String sql;
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.executeUpdate(sql);
stmt.close();
con.close();
以下是他的錯誤訊息
exception
org.apache.jasper.JasperException: org.apache.jasper.JasperException: Unable
to load class for JSP
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:156)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:329)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:600)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:144)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:329)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.lang.ClassNotFoundException: org.apache.jsp._41.Register_jsp
java.net.URLClassLoader$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(Unknown Source)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:134)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:598)
org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:144)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:329)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
--
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 125.230.94.105
推
06/30 08:58, , 1F
06/30 08:58, 1F
→
07/02 14:51, , 2F
07/02 14:51, 2F
推
07/05 12:43, , 3F
07/05 12:43, 3F
討論串 (同標題文章)
本文引述了以下文章的的內容：
完整討論串 (本文為第 2 之 2 篇)：