Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Ò³Ãæ»ñÈ¡sessionµÄÎÊÌâ - Java / Java EE

ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......

JSPÖеÄÖÐÎÄ×Ö·û´¦Àí

<%@ page contentType = "text/html;charset =gb2312"%>

<%!
    public String codeToString(String str)
  {
    String s =str;
  &nbs ......

JSP³öEXCEl±¨±íÖÐÎÄÃû³ÆÂÒÂë

ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......

¹ØÓÚjspµÄһЩСÎÊÌâ - Web ¿ª·¢ / JavaScript

ÎÊÌâ1.
 ÈçºÎͨ¹ýRandomAccessFileÀàµÄseek()·½·¨½«Ö¸ÕëÒÆ¶¯µ½Îļþĩ⣬ÔÙÓÃwriteChars(String s)½«Êý¾ÝдÈëij¸öÎĵµÎļþ
ÎÊÌâ2.
 StringTokenizerÊÇʲô¶«Î÷£¬¸ÉÂïÓõģ¿
  ÓÉÓÚСµÜ³õѧjs ......

jspÒ³Ãæ¶¯Ì¬ÇúÏßÉú³É

[color=#FF9900]ÎÒÏëÓÃÒ»¸öjspÒ³Ãæ¶¯Ì¬µØÏÔʾһЩÊý¾Ý£¬ÕâЩÊý¾ÝÔÚjspÒ³ÃæÉÏÒÔÇúÏߵķ½Ê½ÏÔʾ£¬ÒòΪÕâЩÊý¾ÝÊÇʵʱµÄ·¢Ë͹ýÀ´µÄ£¬ËùÒÔÎÒÏëÇúÏßÒ²ÊÇʵʱµÄ½øÐб仯(ÀàËÆ¹ÉƱ²é¿´µÄÄÇÖÖÇúÏß)£¬¶ø²»Êǵã»÷¡®Ë¢Ð¡¯£¬¸÷Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ