jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop", "sa", "123");
sql=con.createStatement();
String s="'"+logname+"'"+","+"'"+realname+"'"+","+"'"+password+"'"+","+"'"+email+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
String condition="insert into user values"+"("+s+")";
sql.executeUpdate(condition);
message="×¢²á³É¹¦ÁË";
con.close();
}
catch(Exception e){
e.printStackTrace();
}
´íÎóÌáʾ£º
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Ôڹؼü×Ö 'user' ¸½½üÓÐÓï·¨´íÎó¡£
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.proces
Ïà¹ØÎÊ´ð£º
ÏÂÃæcategoryTreeCont.jsp ´úÂë
----------------------------------------
Java code:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
< ......
ÎÊÌâ1.
ÈçºÎͨ¹ýRandomAccessFileÀàµÄseek()·½·¨½«Ö¸ÕëÒÆ¶¯µ½Îļþĩ⣬ÔÙÓÃwriteChars(String s)½«Êý¾ÝдÈëij¸öÎĵµÎļþ
ÎÊÌâ2.
StringTokenizerÊÇʲô¶«Î÷£¬¸ÉÂïÓõģ¿
ÓÉÓÚСµÜ³õѧjs ......
ÈçÌ⣬ÎÒÊÇÓÃstruts2×öµÄÍøÒ³£¬ÓÃÁËradio±êÇ©£¬Ã¿¸öÑ¡Ïîǰ¶¼ÓÐÒ»¸öСԲȦ£¬ÎÒÐèÒª°ÑСԲȦȥµô£¬µ¥»÷×־ͺ㬱»Ñ¡ÖеÄÑ¡Ïî±³¾°±äÉ«¡£
¾ÍÏñ´ó¶àÊýÍøÕ¾µÄ·ÖÀà¼ìË÷£¬±ÈÈçÕâ¸öÍøÕ¾µÄÄÇÑùµÄ¸ù¾Ý¸÷ÖÖÌõ¼þµÄʵʱËÑË÷£º
ht ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
jsÖеķ½·¨£¬²»ÄÜÔÚjspÖе÷ÓÃÔõô½â¾ö£¿¼±£¡£¡!
²»Ã÷°×Òâ˼
ºÃºÃ¼ì²éÊDz»ÊÇ·¾¶µÄÎÊÌ⣬ºÜÓпÉÄÜ·¾¶²»¶Ôµ¼Öµ÷Óò»µ½
Ìùһϵ÷ÓõĴúÂë¿´¿´°¡~~
ÓÐûÓÐÕýÈ·ÒýÓÃjs£¿º¯ÊýÓÐûÓгõʼ»¯£¿....
jsp´úÂë±¾À´¾ ......