SQL恢复XP_CMDSHLL,以及XPLOG70.DLL被删,直接用SQL连接器开启3389:
用sql连接器恢复xp_cmdshlle的命令

 

作者: lovezy 来源：http://www.wrsky.com/

用sql连接器恢复xp_cmdshlle的命令

（1）sql query analyzer
sp_addextendedproc xp_cmdshell,@dllname=xplog70.dll

（2）首先在sqlexec sunx version的format选项里填上%s，在cmd选项里输入

sp_addextendedproc xp_cmdshell,xpsql70.dll

去除

sp_dropextendedproc xp_cmdshell

（3）mssql2000

sp_addextendedproc xp_cmdshell,xplog70.dll

修改sa密码 sp_password @old = null, @new = complexpwd, @loginame =sa
这个很简单,自己堵后门用:)

查看全文    

Configuring Database Access in Eclipse 3.0 with SQLExplorer :

configuring database access in eclipse 3.0 with sqlexplorer

by java.com/pub/au/1723">deepak vohra
05/11/2005

sqlexplorer is an eclipse ide database plugin that may be used to connect to a database from eclipse. the sqlexplorer plugin adds a graphical user interface (gui) to access a database with sql. with sqlexplorer, you can display the tables, table structure, and data in the tables, and retrieve, add, update, or delete table data. sqlexplorer can also generate sql scripts to create and query tables. thus, using sqlexplorer may be preferable to using a command-line sql client. in this tutorial, we shall establish a jdbc connection with the open source mysql database from eclipse 3.0 with the sqlexplorer plugin.

查看全文    

eclipse下tanghan plugin连mssql实战 :

最近一个项目要在eclipse下用tanghan plugin插件连mssql数据库，开始时怎么也连不上，下载了microsoft sql server 2000 driver for jdbc后，有三个包分别为msbase.jar,mssqlserver.jar,msutil.jar,有些教程说把这三个包都写进classpath里，但tanghan连数据库的驱动只能选一个，所以这种方法不行。
现有一可行的方法，就是把上面三个包分别解压，再把里面的com文件夹合并，合并方法可采用覆盖形式，即把第二个和第三个com文件分别放到与第一个com文件夹同一目录下，系统会提示是覆盖，选是，再在命令行下用jar把这个文件夹做成mssql.jar包，命令为：jar cvf mssql.jar com。
配置如下：
在database access view下，如图中1所示，
驱动的配置为：
驱动名称：microsoft mssql server jdbc driver
驱动程序包名：c:\dev\mssql.jar     //为mssql.jar的路径
程序驱动类：com.microsoft.jdbc.sqlserver.sqlserverdriver
驱动程序前缀：jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=databasename
数据库的配置为：
数据库连接名：test
驱动名称：microsoft mssql server jdbc driver
程序驱动类：com.microsoft.jdbc.sqlserver.sqlserverdriver
数据库连接：jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=databasename
用户名：sa
密码：
配好后如图中2所示，圈起来处的红划线已不见了，连接一下，成功的话会如图所示，确定。
如图中3所示，表示已连上了数据库了。

查看全文    

A REVIEW OF SQLEXPLORER PLUG-IN :

plug-in overview
sqlexplorer perspective contains the following views: drivers, aliases (in a tabbed dialog to the top left), connections (by itself in the bottom left), sql results (again, by itself in the bottom middle), database structure view, connection info, and sql history (in the right-hand tabbed panel). the middle of the sqlexplorer perspective is reserved for editors. note that you enter sql statements by editing files with the .sql suffix.

to start using sqlexplorer, you need to select your database in the drivers view. (when it is selected, it will have a red x beside it.) next, click your right mouse button and select change selected driver. the modify driver panel will pop up. next, youll need to click on the extra class path tab, click the add button, and then search and select your jdbc drivers jar file. note the jdbc driver name you already be qualified.

查看全文    

OSWORKFLOW-将Osworkflow+MYSQL持久化之一：布置osworkflow-2.7.0-example实例 :

/*
 *author: meanson wang
 *date: 2005-01-15
 *email: meansonw@hotmail.com
*/

osworkflow-将osworkflow+mysql持久化之一：布置osworkflow-2.7.0-example实例

【环境】
win2000
osworkflow 2.7.0
tomat 5.0.25
mysql 4.1.7-nt + mysql-connector-java-3.0.15-ga-bin.jar

hani做了个很好的demo叫osworkflow-2.7.0-example.war，就放在oswf的压缩文件下。如果你要学习oswf，毫无疑问，你首先接触的就是它了。

布置oswf实例很简单，把war文件放到tomcat\webapps下，启动tomcat，再访问一下网址：

http://localhost:8080/osworkflow-2.7.0-example

查看全文