javaÓësql server 2005µÄÏà¹Ø²Ù×÷
//±¾³ÌÐòÁ¬½ÓµÄÊÇsql server 2005£¬ÓëÁ¬½Ósql server 2000Óе㲻ͬ£ºdriverNameºÍURL¶¼²»Í¬
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class create{
public void getConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
{
Statement stmt = null;
Connection dbConn;
ResultSet rs;
String user="sa";
String pass="";
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=tempdb";
try{
Class.forName(driverName).newInstance();
System.out.println("ok");
dbConn = DriverManager.getConnection(URL,user,pass);
System.out.println("Connection Successful!");
stmt = dbConn.createStatement(); // »ñµÃÖ´ÐÐSQLÓïÑÔµÄÈÝÆ÷
rs=dbConn.getMetaData().getTables(null, null, "testTb", null);
if(rs.next()){
System.out.println("testTb´æÔÚ!ÔÛÏÖÔÚ°ÑËüɾÁË°É£¡");
stmt.executeUpdate("drop table testTb");
System.out.println("»ØÍ·ÔÙ¿´¿´£¬Ã»ÁË°É£¿");
&nb
Ïà¹ØÎĵµ£º
ѹËõÎļþ¼Ð´úÂ룺
import java.io.File;
import org.apache.tools.zip.ZipOutputStream; //Õâ¸ö°üÔÚant.jarÀҪµ½¹Ù·½ÍøÏÂÔØ
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.zip.ZipInputStream;
import java.util.zip.ZipEntry;
......
Ñ¡ÔñÁËjava£¬Ò²¾ÍÊÇÑ¡ÔñÁËÒ»Ìõ¹âÃ÷¶ø¿²¿ÀµÄµÀ·¡£ËµËû¹âÃ÷ÊÇÒòΪӦÓõĵط½ÈÕÒæ¹ã·º£¬È«ÇòÓкܴóµÄ¿ª·¢ÈºÌåÔÚΪ֮æµ£¬¿ªÔ´ÏîÄ¿Ó¦Óо¡ÓУ»ËµËû¿²¿À£¬ÊÇÒòΪËæ×ÅjavaµÄ·¢Õ¹£¬ÏÖÔÚÓÐÁËÌ«¶àµÄ·ÖÖ§¼¼Êõj2ee 13ÖÖ¼¼Êõ£¬Ì«¶àµÄ¿ò¼Ü(´Óµ×²ãµ½Ò³Ãæ)Èç¹ûÒªÕÆÎÕ»¹Õæ²»ÊǼþÈÝÒ×µÄÊÂÇ飬¶øÇÒ¿ªÔ´µÄ¶«Î÷ÓÀÎÞÖ¹¾¡µÄÔÚÉý¼¶£¬ÔÚÍƳ ......
18.×öÒ»¸öµ¥×ÓģʽµÄÀֻ࣬¼ÓÔØÒ»´ÎÊôÐÔÎļþ
package com.softeem.demo;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
/**
*@authorleno
*µ¥×Óģʽ£¬±£Ö¤ÔÚÕû¸öÓ¦ÓÃÆÚ¼äÖ»¼ÓÔØÒ ......
ÖÚËùÖÜÖª£¬StringÊÇÓÉ×Ö·û×é³ÉµÄ´®£¬ÔÚ³ÌÐòÖÐʹÓÃƵÂʺܸߡ£JavaÖеÄStringÊÇÒ»¸öÀ࣬¶ø²¢·Ç»ù±¾Êý¾ÝÀàÐÍ¡£ ²»¹ýËýÈ´²»ÊÇÆÕͨµÄÀàŶ£¡£¡£¡
¡¾¾µÍ·1¡¿ String¶ÔÏóµÄ´´½¨
1¡¢¹ØÓÚÀà¶ÔÏóµÄ´´½¨£¬ºÜÆÕͨµÄÒ»ÖÖ·½Ê½¾ÍÊÇÀûÓù¹ÔìÆ÷£¬StringÀàÒ²²»ÀýÍ⣺
& ......