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
Ïà¹ØÎÊ´ð£º
ÔÚjspÀïÃæ£¬Óøöselect¼ÈÄÜÊäÈë×Ô¶¯Æ¥ÅäÓÖÄÜÏÂÀÑ¡ÔñµÄ£¬ÔõôʵÏÖ£¿
²»»á¡£¡£¡£¡£¡£¡£°ï¶¥ ѧϰ¡£¡£
×Ô¶¯Æ¥ÅäʲôÒâ˼£¿¾ßÌåµã
¾ÍÊÇÄãÊäÈëÄÚÈݺ󣬺ÍÄãÄÚÈÝÏàͬѡÏîµÄ¶¼ÁгöÀ´
ÄãselectÊÇÏÂÀ¿ò¡£¡£ ......
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
ÈçÌ⣬ÎÒÊÇÓÃstruts2×öµÄÍøÒ³£¬ÓÃÁËradio±êÇ©£¬Ã¿¸öÑ¡Ïîǰ¶¼ÓÐÒ»¸öСԲȦ£¬ÎÒÐèÒª°ÑСԲȦȥµô£¬µ¥»÷×־ͺ㬱»Ñ¡ÖеÄÑ¡Ïî±³¾°±äÉ«¡£
¾ÍÏñ´ó¶àÊýÍøÕ¾µÄ·ÖÀà¼ìË÷£¬±ÈÈçÕâ¸öÍøÕ¾µÄÄÇÑùµÄ¸ù¾Ý¸÷ÖÖÌõ¼þµÄʵʱËÑË÷£º
ht ......
ÎÒµãºóÍËʱÊǿհ×Ò³Ãæ
ÐèˢвÅÄÜÏÔʾ
Õâ¸öÔõô´¦Àí°¡
Çë´ó¼Ò°ï°ïæ
°ÑÎÊÌâ˵µÄÏêϸһЩ£¬ÕâÑùÓÐÖúÓÚÎÊÌâµÄ»Ø¸´£¬¼°´ð°¸µÄ׼ȷÐÔ£¡
ÎÒ¾õµÃÊÇÄãµÄä¯ÀÀÆ÷Æ÷µÄÎÊÌâ°É£¬ÎÒÒÔǰÓöµ½¹ýÕâÑùµÄÎÊÌ⣬°ÑIEµÄËùÓÐÊôÐÔÖ ......
//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......