添加数据总是不成功!数据代码如下:<%@ page contentType="text/html;Charset=gb2312"%>
<%@ include file="common.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@ include file="header.jsp"%>
<%
String userid=new String(request.getParameter("userid").trim().getBytes("ISO-8859-1"));
String password=new String(request.getParameter("password").trim().getBytes("ISO-8859-1"));
String username=new String(request.getParameter("username").trim().getBytes("ISO-8859-1"));
String address=new String(request.getParameter("address").trim().getBytes("ISO-8859-1"));
String phone=new String(request.getParameter("phone").trim().getBytes("ISO-8859-1"));
String email=new String(request.getParameter("email").trim().getBytes("ISO-8859-1"));
//加载驱动器
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDrvier");
//bookshop为数据库名
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookshop";String user="sa";String psword="sa";Connection conn=DriverManager.getConnection(url,user,psword);//与驱动程序建立连接
//conn为一个Connection对像的实例.用conn的方法来创建一个Statement对像的实例Statement stmt=conn.createStatement();String sql="insert into T_user values('"+userid+"','"+password+"','N','"+username+"','"+address+"','"+phone+"','"+email+"')";stmt.executeUpdate(sql);stmt.close();conn.close();
%>
<br>
已经注册成功!请
<a href="index.jsp">
登录
</a>
</a>
<br>
<%@ include file="footer.jsp"%>
</body>
</html>
提示问题如下:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: com.microsoft.jdbc.sqlserver.SQLServerDrvier
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
--------------------------------------------------------------------------------谢谢各位大侠了!
<%@ include file="common.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@ include file="header.jsp"%>
<%
String userid=new String(request.getParameter("userid").trim().getBytes("ISO-8859-1"));
String password=new String(request.getParameter("password").trim().getBytes("ISO-8859-1"));
String username=new String(request.getParameter("username").trim().getBytes("ISO-8859-1"));
String address=new String(request.getParameter("address").trim().getBytes("ISO-8859-1"));
String phone=new String(request.getParameter("phone").trim().getBytes("ISO-8859-1"));
String email=new String(request.getParameter("email").trim().getBytes("ISO-8859-1"));
//加载驱动器
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDrvier");
//bookshop为数据库名
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookshop";String user="sa";String psword="sa";Connection conn=DriverManager.getConnection(url,user,psword);//与驱动程序建立连接
//conn为一个Connection对像的实例.用conn的方法来创建一个Statement对像的实例Statement stmt=conn.createStatement();String sql="insert into T_user values('"+userid+"','"+password+"','N','"+username+"','"+address+"','"+phone+"','"+email+"')";stmt.executeUpdate(sql);stmt.close();conn.close();
%>
<br>
已经注册成功!请
<a href="index.jsp">
登录
</a>
</a>
<br>
<%@ include file="footer.jsp"%>
</body>
</html>
提示问题如下:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: com.microsoft.jdbc.sqlserver.SQLServerDrvier
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
--------------------------------------------------------------------------------谢谢各位大侠了!
解决方案 »
- [提问]nginx 的rewrite 规则书写问题
- 有个方法不是太懂,希望大家指点下!!
- 一个页面~!为什么有时候可以执行~!有时候就提示出错呢?什么都没改过???帮忙看一下~!
- 求 batch update returned unexpected row count from update[0] 的解决方案
- 为什么我创建servlet是灰色,哪里没有配置呀
- 页面checkbox参数传入javascript和javabean的处理问题,谢谢
- 用jsp怎么把图片插入到数据库中啊?
- 怎么我的数据传递不过去呀?
- 在jsp中连接oracle报错,请高手帮我分析原因(100分)
- jsp如何实现刷新某页???
- JSP验证码
- 关于ACTION的一个问题
看看驱动的几个jar包是不是都在?
有没有给ms sql server打到最新的补丁?
拜托各位,帮我再看看
谢谢了啊
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookshop";
看一下端口号是不是对应的1433