Çójsp´óÅ£°ïÎÒ½â´ðÒ»ÏÂ
СµÜÊdzõѧÕߣ¬°´ÕÕÊéÉÏÁ·Ï°Á˸öÊý¾Ý¿âÁ´½ÓµÄÀý×Ó £¬ ¿ÉÊÇ»¹Êdzö´íÁË
СµÜµÄÊý¾Ý¿âÊÇSQL2005 IDE ÊÇEclipse ²¢ÇÒ´Ó΢ÈíµÄ¹ÙÍøÉÏÏÂÔØÁËÕë¶ÔSQL2005Êý¾Ý¿âµÄJDBCÇý¶¯³ÌÐò£¬Ò²½«sqljdbc.jarÇý¶¯°ü¹¹½¨µ½ÁËÕâ¸öÏîÄ¿ÖÐÈ¥ÁË ¿ÉÊÇ»¹Êdzö´íÁË ÏÂÃæÊÇ´úÂëºÍ´íÎó °ïÎÒ¿´¿´ÊÇÕ¦»ØÊÂ
import java.sql.*;
public class S1 {
/**
* @param args
*/
public static void main(String[] args) throws ClassNotFoundException,SQLException {
// TODO ×Ô¶¯Éú³É·½·¨´æ¸ù
String url="jdbc:sqlserver//localhost;instanceName=SQLEXPRESS;databasename=lzc";
String username="sa";
String password="000";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection(url,username,password);
if(conn!=null)
System.out.println("success!!!");
else
System.out.println("error!!!!");
}
}
´íÎó£º
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545) <
Ïà¹ØÎÊ´ð£º
ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
Ò»¸öÃû³Æ,ÐèÒªÊäÈëµÄ£¬Ò»¸öÏÂÀ²Ëµ¥£¬Ñ¡ÔñµÄ£¬¸ù¾ÝÕâÁ½¸ö½øÐÐÄ£ºý²éѯ¡£ÔÚ·þÎñÆ÷¶ËÎÞÂÛÊäÈëÓë·ñ£¬¶¼Äܵóö²éѯ½á¹û¡£
µ«ÊÇ·ÃÎʵϰ£¬Ö»ÓÐÔÚÊäÈëÃû³ÆµÄʱºò£¬ÔÙÑ¡ÔñÏÂÀ²Ëµ¥²ÅÄܲéѯ£¬Èô²»ÊäÈëÃû³Æ£¬Ö»Ñ¡ÔñÏÂÀ²Ëµ ......