打印

连接问题

Biancolew

初级会员

临时用户组

社区积分: 0
技术积分: 7

大中小 1楼

2007-4-12 18:42 只看该作者

连接问题

<%@ page language="java" c errorPage="err.jsp"  %>

<html>
<body>
   <%
      package demo.jdbc.utils;
      import java.sql.connection;
      import java.sql.DiverManager;
      import java.sql.SQLException;

   String da=request.getParameter("sx");
   String strURL,strSQL;
   Connection conn;
   Statement stmt;
   try{

         package demo.jdbc.utils;
         import java.sql.connection;
         import java.sql.DiverManager;
                  import java.sql.SQLException;
         String user="sa";
         String password="";
         Class.forName("com.microsoft.jdbc.sqlserver.SQLServer").newInstance();
         URL="jdbc:microsoft:sqlserver://localhost:1433; DatebaseName=web";
         con = DriverManager.getConnection(strURL,"sa","");
         stmt=conn.createStatement();
         strSQL="insert into user(id) values ('"+da+"')";
         stmt.executeUpdate(strSQL);
         out.println("<a href='www'>成功注册</a>");

         stmt.close();
         conn.close();

      } catch(Exception e) {
               System.out.println(e);
               response.sendRedirect("err.jsp");
            }

   %>
</body>
</html>

报错为:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:48: illegal start of expression
      package demo.jdbc.utils;
      ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:49: illegal start of expression
      import java.sql.connection;
      ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:50: illegal start of expression
      import java.sql.DiverManager;
      ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:51: illegal start of expression
      import java.sql.SQLException;
      ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:59: illegal start of expression
         package demo.jdbc.utils;
         ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:60: illegal start of expression
         import java.sql.connection;
         ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:61: illegal start of expression
         import java.sql.DiverManager;
         ^

An error occurred at line: 5 in the jsp file: /chuan1.jsp
Generated servlet error:
D:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\chuan1_jsp.java:62: illegal start of expression
                  import java.sql.SQLException;
         ^
8 errors

      org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
      org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
      org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
      org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
      org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
      org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
      org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
      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.28 logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.28

小弟是学jsp的新手,这个连接的问题搞了很就都没搞定,请各为大虾帮下忙....
jdbc和sqlserver安装在c盘...