Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

ÓÃjavaѹËõÎļþ¼Ð/Îļþ

 Ñ¹ËõÎļþ¼Ð´úÂ룺
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ÓÅ»¯±à³Ì

1.       ÔÚCÓïÑÔÖУ¬ÎÒÃÇͨ³£Ï°¹ß°ÑÐèÒªµÄ¶ÔÏóÉêÃ÷·ÅÔÚº¯ÊýµÄ¿ªÍ·£¬µ«ÆäʵÕâÊǰװ×ÀË·ÑÁËÄڴ棬ÔÚJavaÖУ¬²»µ½ÐèÒªµÄʱºò£¬Çë²»Òª´´½¨¶ÔÏó¡£
2.       À¬»ø»ØÊջ᲻¶¨ÆÚµÄËÑË÷ÒѾ­Ã»ÓÐÓõĶÔÏó£¬È»ºóÊͷŶÔÏóµÄÄڴ棬µ«ÕâÖÖËÑË÷ÊDZȽϺÄ×ÊÔ´µÄ¡£ÎªÌá¸ßЧÂÊ£ ......

[vb]ʹÓÃvbͳ¼Æ.javaµÄÐÐÊý

 ¹¤×÷ÐèÒª£¬Õë¶ÔjavaÎļþ£¬×÷ÁËÒ»¸öÐÐÊýͳ¼ÆµÄ¹¤¾ß¡£Í³¼ÆµÄÖ÷Òª´úÂëÈçÏ£º
    Set srcIn = fso.OpenTextFile(fileNm, ForReading)
    
    Do While Not srcIn.AtEndOfStream
        buf = srcIn.ReadLine
 &nbs ......

ä¯ÀÀLINQ to SQL¹ØÏµ

±êÇ©£ºÊý¾Ý·ÃÎÊ     LINQ     LINQ to SQL ²¿·Ö
ä¯ÀÀLINQ to SQL¹ØÏµ      Á½¸ö¹ØÁªµÄ±í£º
 & ......

SQL SERVERÒìµØ±¸·Ý·½·¨(1)

д³É´æ´¢¹ý³Ì£¬½¨Á¢×÷Òµ¶¨Ê±±¸·Ý~~~
--ÔÚsqlÖÐÓ³ÉäһϾͿÉÒÔÁË
exec master..xp_cmdshell 'net use z: \\yizhi\D$ "ÃÜÂë" /user:yizhi\administrator'
/*--˵Ã÷:
exec master..xp_cmdshell 'net use z: \\xz\c$ "ÃÜÂë" /user:xz\administrator'
z:ÊÇÓ³ÉäÍøÂç·¾¶¶ÔÓ¦±¾»úµÄÅÌ·û,ÓëÏÂÃæµÄ±¸·Ý¶ÔÓ¦
\\xz\c$ÊÇÒªÓ³ÉäµÄÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ