java闲扯淡

<br />20100304——一台windows 2003 server (enterprise edition sp1)启动的时候出现“visual studio just-in-time debugger”错误对话框。如图：<br /> <br />内容如下：“An unhanled win32 exception occurred in explorer.exe[2548]. just-in-time debuenabled. in visual studio,just-in-debugging c

<br />select * from  (select a1.*,rownum rn from (select * from 表) 表别名 where rownum <上限) where rn>= 下线<br /> <br />select * from employe  where employeid in (select employeid from (select employeid,rownum rn from (select employeid from employe) where rownu

<br />解决的方法其实很简单，如下：<br /><br />1、开户MSDTC服务：“开始-运行”，输入"cmd"后回车，在命令提示行中输入"msdtc -install"并回车。<br /><br />2、开启COM+ System Application服务：“开始-运行”，输入"Services.msc"后回车，打开服务和应用程序，并在服务列表里面找到"COM+ System Application"，鼠标右键单击，点击“属性”，然后更改启动方式为“自动”，最后点击下面的“启动”开启此服务。<br

<br /> Properties properties=new Properties();           //读取properties文件<br />//    InputStream inputStream=new FileInputStream(new File("src/property.properties"));   文件在src目录下<br />    InputStream inputStream=JdbcUtil.class.getClassLoader().getResourceA

<br />System.out.println(new Date().toLocaleString());<br />  System.out.println(new java.sql.Date(new Date().getTime()));

<br />import java.sql.Connection;<br />import java.sql.DriverManager;<br />import java.sql.SQLException;<br />/**<br /> * @author Administrator<br /> * <br /> */<br />public class JdbcUtil<br />{<br /> private String url = "jdbc:sqlserver://localhost:1433;

<br />1.分页方案一：(利用Not In和SELECT TOP分页) <br /> <br /> 语句形式：  SELECT TOP 10 *  FROM TestTable  WHERE (ID NOT IN            (SELECT TOP 20 id           FROM TestTable           ORDER BY id))  ORDER BY ID      SELECT TOP 页大小 *  FROM TestTable  WHERE (ID NOT IN 

<br />在META-INF中配置context.xml文件：<br /><?xml version='1.0' encoding='utf-8'?><br /><Context><br />    <Resource name="jdbc/jinda"   <br />       auth="Container"       <br />       type="javax.sql.DataSource"   <br />       driverClassName="com.microsoft.sq

<br />方法一、直接在开始栏---运行----输入cmd----回车 <br />然后 输入<br />1)<br />cd /d C:/Program Files/Microsoft SQL Server/90/Shared <br />2)mofcomp "C:/Program Files/Microsoft SQL Server/90/Shared/sqlmgmproviderxpsp2up.mof" <br />方法二、如果输入cmd命令符，没有用,就用这个试下<br />1)在C:/WINDO

<br />分页存储过程：<br />Create or replace procedure fenye  (tablename in varchar2,<br />Pagesize int number,t_cursor testPackage.test_cursor,<br />Pagenow in number,rowscount out number<br />) is<br />V_sql varchar2(1000);<br />V_begin number :=(pagenow-1)*page