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
ÇëÎʸÃÔõô½â¾ö£¿Ð»Ð»
Ïà¹ØÎĵµ£º
POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(cfname));
HSSFWorkbook wb = new HSSFWorkbook(fs);
......
public static String splitAndFilterString(String input, int length) {
if (input == null || input.trim().equals("")) {
&nb ......
javaÉè¼ÆÄ£Ê½Ñ§Ï°1££Singleton Pattern
¡¡¡¡Ç°Ð©Ìì°ÚŪjava£¬²Î¿¼Ò»Ð©×ÊÁÏдÁ˸öÊý¾Ý¿âÁ¬½Ó³Ø£¬¶ÔÀïÃæÖ»²úÉúÒ»¸öʵÀýµÄÄÇÖÖ×ö·¨Éî±íÅå·þ£¬½ñÌìÖÐÎçÓÖÌýµ½±ðÈËÔÚ˵Éè¼ÆÄ£Ê½£¬Êܲ»ÁËÁË£¬¾ÍÉÏÍøDownÁ˵ã×ÊÁÏÀ´¡£
¡¡¡¡Ò»À´¾Í¿´µ½ÁËSingletonģʽ£¬Ò»¿´£¬Ñ½£¬²»¾ÍÊÇÄǸöÁ¬½Ó³ØÀïÓõķ½·¨Ã´?!àÞ£¬ÔÀ´Èç´Ë¡£
¡¡¡¡Singleton Ê ......
½«ÏÂÔØºóµÄÎļþ½â°ü£¬µÃµ½jxl.jar£¬·ÅÈëclasspath£¬°²×°¾ÍÍê³ÉÁË¡£
»ù±¾²Ù×÷
Ò»¡¢´´½¨Îļþ
ÄâÉú³ÉÒ»¸öÃûΪ“²âÊÔÊý¾Ý.xls”µÄExcelÎļþ£¬ÆäÖеÚÒ»¸ö¹¤×÷±í±»ÃüÃûΪ“µÚÒ»Ò³”£¬´óÖÂЧ¹ûÈçÏ£º
´úÂ루CreateXLS.java£©£º
//Éú³ÉExcelµÄÀà
import java.io.*;
import jxl.*;
import jxl.write. ......
1. HttpSession session = request.getSession()
ÓëHttpSession session = request.getSession(true)µÄÇø±ð£¿
²Î¿¼´ð°¸£º
getSession(true)µÄº¯ÊýÔÐÍΪ:£ºHttpSession session = request.getSession (Boolean create)
Èç¹ûÓÐÓ뵱ǰµÄrequestÏȹØÁªµÄHttpSession,ÄÇô·µ»ØrequestÏà¹ØÁªµÄHttpS ......