Java¡¢sql server 2000¼°jdbc
ÎÒÔÚѧϰ¹ØÓÚjava±à³Ì£¬ÏÖÔÚÉæ¼°µ½µÄÊÇsqlµÄÎÊÌ⣬±ÈÈçÈí¼þÑ¡Ôñ¡¢»·¾³µÄÁ¬½ÓÉèÖõÈÎÊÌ⣬¶ÔÓÚÕâЩÎÊÌâÎÒÕæÊÇÊøÊÖÎ޲߰¡£¡ÇëÇóJava±à³Ì¸ßÊִͽ̣º
1¡¢ÎÒÓõÄJavaÊÇj2sdk-1_4_2_13-nb-5_0£¬ÎÒÓÃÁËsql server2000£¬ÎÒÓÃjdbc3.0ÐÐÂð£¿ËùÓÐÁ¬½ÓÉèÖøÃÔõôÑùÉèÖã¿
2¡¢±ÈÈçÏÂÃæ³ÌÐò£º
import java.sql.*;
public class DBConnection
{
private static String driver="com.Microsoft.jdbc.sqlserver.SQLServerDriver";
private static String url="jdbc:microsoft:sqlserver://localhost:1433:DatabaseName=wen";
private static String user="sa";
private static String password="sa";
public static Connection getConnection()
{
Connection con;
try
{
Class.forName(driver);
con=DriverManager.getConnection(url,user,password);
return con;
}catch(ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
return null;
}
}
½á¹ûÏÔʾ£ºException in thread "main" java.lang.NoSuchMethodError:mian
ÇëÎʸÃÔõô½â¾ö£¿Ð»Ð»
Ïà¹ØÎĵµ£º
1. ʲôÊÇSerialization?
´®Ðл¯(Serialization)ÊǼÆËã»ú¿ÆÑ§ÖеÄÒ»¸ö¸ÅÄËüÊÇÖ¸½«¶ÔÏó´æ´¢µ½½éÖÊ£¨ÈçÎļþ¡¢ÄÚÔÚ»º³åÇøµÈ£©ÖлòÊÇÒÔ¶þ½øÖÆ·½Ê½Í¨¹ýÍøÂç´«Êä¡£Ö®ºó ¿ÉÒÔͨ¹ý·´´®Ðл¯´ÓÕâЩÁ¬ÐøµÄλÊý¾ÝÖØÐ¹¹½¨Ò»¸öÓëÔʼ¶ÔÏó״̬ÏàͬµÄ¶ÔÏó£¬Òò´ËÔÚÌØ¶¨Çé¿öÏÂÒ²¿ÉÒÔ˵Êǵõ½Ò»¸ö¸±±¾£¬µ«²¢²»ÊÇËùÓÐÇé¿ö¶¼ÕâÑù¡£
JavaÓÐS ......
POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(cfname));
HSSFWorkbook wb = new HSSFWorkbook(fs);
......
JAVA ´úÂëÈçÏ£º
<%
// µÃµ½Òª×ª»»µÄÊý×é---µ±È»ÕâÀïÒ²¿ÉÒÔÊÇÆäËûÀàÐ͵ÄÊý×é
List jsList = (List) request.getAttribute("gczbh");
%>
JS ´úÂëÈçÏ£º
<script type="text/javascrip ......
½«ÏÂÔØºóµÄÎļþ½â°ü£¬µÃµ½jxl.jar£¬·ÅÈëclasspath£¬°²×°¾ÍÍê³ÉÁË¡£
»ù±¾²Ù×÷
Ò»¡¢´´½¨Îļþ
ÄâÉú³ÉÒ»¸öÃûΪ“²âÊÔÊý¾Ý.xls”µÄExcelÎļþ£¬ÆäÖеÚÒ»¸ö¹¤×÷±í±»ÃüÃûΪ“µÚÒ»Ò³”£¬´óÖÂЧ¹ûÈçÏ£º
´úÂ루CreateXLS.java£©£º
//Éú³ÉExcelµÄÀà
import java.io.*;
import jxl.*;
import jxl.write. ......
ÈýÖÜǰ£¬¾ÍÓëͬѧԼ¶¨ºÃÁË£¬»¨ÈýÖÜʱ¼äд¸ö̰³ÔÉߣ¬¾ÍÓÃ×Ô¼ºÏÖÔÚËùѧµÄJava£¬ÎÒÏë¿ÉÒÔ°¡¡£Ñ§Ð£Àï½Ì²»³öʲô¶«Î÷£¬ÄǾÍ×Ô¼º¸ã°É£¡ÓÚÊÇÎÒÃÇÐÅÊĵ©µ©¿ªÊ¼Á˼¸Ìì¡£²»ÁÏÎåÒ»Ò»À´£¬°ÑËùÓеͼÀÏÂÁË¡£×îºóÒ»ÖÜÁË£¬Ã»°ì·¨£¬Í¨Ïü°É£¡ÓÚÊÇÁ¬Ðø¼¸Ìì¿à¸É£¬ÖÕÓÚд³öÀ´ÁË.ËäÈ»Óеã´Ö²Ú£¬ÒòΪѧУ»¹Ã»¿ªÊ¼½ÌGUIº ......