想出来了但不对，哎，还是得请教高手！！！帮帮我吧！！！！

Question

就是没人回答呢，CSDN的人这么不愿意帮助新人吗

Answer 1

假如你想插入一条记录的话如果你的表结构是这样的：
tablename: contact
cols:username,password那么，你的sql语句应该这样写：inset into contact values(?,?)传值应该这样写：
pstmt.setSting(1,username);
pstmt.setSting(2,password);

Answer 2

PreparedStatement pstmt=con.prepareStatement("inset into contact values(?)");
//============================================================================//
pstmt.setSting(1,username);
//============================================================================//
pstmt.setSting(1,password);什么意思？？
是否应该是
PreparedStatement stmt = con.preparedStatement("insert into contact values(?, ?)");
stmt.setString(1, username);
stmt.setString(2, password);

Answer 3

不对呀：type Exception reportmessage Internal Server Errordescription The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
An error occurred between lines: 13 and 39 in the jsp file: /kkkk.jspGenerated servlet error:
D:\tomcat\work\Standalone\localhost\_\kkkk$jsp.java:101: Method setSting(int, java.lang.String) not found in interface java.sql.PreparedStatement.
                pstmt.setSting(1,username);
                              ^
An error occurred between lines: 13 and 39 in the jsp file: /kkkk.jspGenerated servlet error:
D:\tomcat\work\Standalone\localhost\_\kkkk$jsp.java:102: Method setSting(int, java.lang.String) not found in interface java.sql.PreparedStatement.
                pstmt.setSting(1,password);
                              ^
2 errors, 1 warning at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:548)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:176)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:188)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
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:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:536)

Answer 4

setSting
这个是错的。
应该是setString
^_^

Answer 5

学JSP两天 就已经做数据库了？？？我搞了两天才刚刚把JSP环境建好
可以的话我们交个朋友吧
一起学习 一起进步我QQ 22334229