JDBCÁ¬½ÓsqlserverÊý¾Ý¿â´íÎó
ÓÃJDBCÁ¬½Ósqlserver2005Êý¾Ý¿â½øÐвéѯʱ£¬³öÏÖÏÂÃæµÄ´íÎóʱʲôÔÒò¡¡
Error occurred
Error:java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
1. ¿ÉÄÜÊÇÇý¶¯ÀàµÄÃû×Öд´íÁË
2. Ö¸¶¨µÄÀࣨ°üº¬Õâ¸öÀàµÄjar°ü£©²»ÔÚclass-pathÉÏ¡£
ÇëÎÊÈçºÎ½â¾ö¡¡
ÔÚµ±Ç°ÏîÄ¿Öе¼Èë sqljdbc.jar
Java code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBCon {
private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String url="jdbc:sqlserver://localhost:1433;databasename=xx";
private static String user="sa";
private static String pwd="sa";
public static Connection getConnection(){
try {
Class.forName(driver);
Connection con=DriverManager.getConnection(url, user, pwd);
System.out.println("con success");
return con;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
Ïà¹ØÎÊ´ð£º
Çë½Ì¸÷λ£º
ÔÚ³¬ÊеÄÊÕÒøÏµÍ³ÖУ¬Èç¹ûÓÐ20¶à¸ö¿Í»§¶Ë£¬ÓпÉÄÜͬʱ¶Ôij×Ö¶ÎÊý¾Ý½øÐÐÐ޸쬻ò½øÐÐɾ³ý£¬¾ÍÓпÉÄܾͻáÔì³ÉijЩ¿Í»§¶Ë³öÏÖ´íÎó£¬Ó¦¸ÃÈçºÎÈ¥±ÜÃâÄØ£¿ÄÜ·ñÌṩ¾ßÌåÊÂÀý£¬Ð»Ð»
Ôõô»áͬʱÐÞ¸ÄÄØ£¿
......
flash ÔõÑùÌáÈ¡ms sqlserverÊý¾Ý¿âµÄÊý¾Ý¡£×îºÃ¸ø¸öÍêÕû´úÂë¿´¿´
flash²»ÄÜÖ±½Ó¶ÁÈ¡Êý¾Ý¿âµÄÊý¾Ý ÓëÊý¾Ý¿âͨѶ¿ÉÒÔ½èÖúxml»òÕßÒ³ÃæÖ®ÀàµÄ
¾ßÌåÊÇÔõÑùÌáÈ¡µÄ£¿
ÈçLZÊìϤ·þÎñÆ÷¶Ë¿ª·¢¿É¿´ÎÒµÄBLOGhttp:/ ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
php¸ßÊÖ½ø ÎÒÔÚºǫ́µÃµ½Ç°Ì¨ÓÃXMLHttpRequest·¢Ë͹ýÀ´µÄJSONÊý¾Ý£¬½âÎöºóÊÇÕý³£µÄ£¬Ìí¼Óµ½SQLServer2000Êý¾Ý¿âÖÐÖ®ºó£¬ÖÐÎľͱäÁË¡£
(´ó¼Ò°ïæ°¡£¬¾ÍÊÇÔÚǰ̨ÓÃajax·¢ËÍJSONÊý¾Ýµ½ºǫ́£¨php´úÂ룩£¬ÔÚͨ¹ýº ......
ȷʵ£¬Êý¾Ý¿âµÄά»¤³£³£½»¸øÄÇЩרҵµÄÊý¾Ý¿â¹ÜÀíÔ±£¬µ«ÊÇ×÷Ϊһ¸ö¿ª·¢Õߣ¬ÄãÒ²Ðíż¶ûÐèÒªÔÝʱ´ÓÊÂÕâ¸ö¹¤×÷¡£ËùÒÔ£¬ÊÔÒ»ÊÔÕâÁ½¸öSQL·þÎñÆ÷ά»¤¼¼ÇÉ£ºÇáËɸıäÊý¾Ý¿âÓµÓÐÕß¡¢ÕûÀíË÷ÒýË鯬¡£Ë»áÏëµ½ÄãÉ ......