JavaÄÜ£¬jsp²»ÄÜÁ¬½Ósql sever2005 - Java / Web ¿ª·¢
×¢£ºÎÒÒѾ°ÑÇý¶¯³ÌÐò·ÅÔÚÍøÕ¾µÄ£×£Å£Â—INFOµÄlibÏÂÁË
tomcat ±¨´í£ºThe server encountered an internal error () that prevented it from fulfilling this request.
Java´úÂ룺
*************************************************************************
import java.sql.*;
import java.util.*;
public class test {
public static void main(String[] srg) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //¼ÓÔØJDBCÇý¶¯
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=test"; //Á¬½Ó·þÎñÆ÷ºÍÊý¾Ý¿âtest
String userName = "sa"; //ĬÈÏÓû§Ãû
String userPwd = "yjs"; //ÃÜÂë
String dbName="test";
String tableName="student";
Connection dbConn;
try {
Class.forName(driverName).newInstance();
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!"); //Èç¹ûÁ¬½Ó³É¹¦ ¿ØÖÆÌ¨Êä³öConnection Successful!
Statement stmt=dbConn.createStatement();
String sql="select StuId,StuName from student;";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{ String id=rs.getString("StuId"); //È¡³öidÁеÄÄÚÈÝ
String name=rs.getString("StuName");
Ïà¹ØÎÊ´ð£º
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
tableÔõô°ó¶¨Êý¾Ý¿â£¬²¢ÇÒÓÃJavaScriptʵÏÖ·Ò³¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£JavaScriptÄÜÏòJSPÒ³Ãæ´«µÝ²ÎÊýÂð
Äã˵µÄÎÊÌâÓеãÄǸö¡£¡££¬²»ºÃ»Ø´ð¡£¡£¡£¡£
jspÖÐtableÊÇÐèÒªhtml´úÂëÓëÒ³Ãæ¶Ë»ñÈ¡Êý¾Ý¿â²éѯºóµÄÐÅÏ¢½øÐÐ ......