分析函数学习1 level
level is a pseudo column used with CONNECT BY and denotes the node level of the tree structure.[@more@]For example, given the following department/sub-department layering architecture, we have an Accounting department within a Financials department within a Software department, that is,Software OS Financials Spreadsheets AccountingThe existence of a valid "parent" department can be enforced with a foreign key constraint on a department name column. This constraint ensures
一个经典的查询及其SQL语句
查询所有班级中每个部门薪水前5名的员工姓名,应该怎样写查询语句?第一次遇到这个问题还是在JDZ的时候,省支撑的XY(kevin,我校友)提供的答案,非常好很精练。后来在ITPUB上见到有人问同样的问题,也见到一些不错的答案。我知道的方法一共有这么三种:[@more@]是根据 hr 用户下的 employees 写的,实现的功能类似代码:---------------------------------------------------------------------select department_id, last_name, salary, rnfrom (select e.last_name, e.salary, e.department_id, rank() over(partition by e.department_i
使用ant发布系统
1.配置ant2.配置build.properties3.配置build.xml[@more@]设置ant路径 path重启cmd测试ant启动 c:/ antcmd到project目录下执行ant cleanant webapp配置project下的build.properties:type build.properties-----------------------------------------------------------windows-show view添加ant-----------------------------------------------------------build.properties形如:tomcat.home=d:/tomcat55webFolder=d:/tomcat55/webapps/demobuild.xml形如:<?xml version="1.0"?><project name="DemoProject&quo
SerializableRE
import java.io.Serializable; public class Greeting implements Serializable { public void greeting() { System.out.println("你好!"); } }[@more@]import java.io.*;import java.net.*;import java.awt.*;import java.applet.*;import java.awt.event.*;//设计类ReadURL,既可以applet运行也可以application运行public class ReadURL extends Applet implements ActionListener { TextField tfURL; TextArea taContext; Label lbMsg; public void init() { setLayout(new BorderLayout()); tfURL=new TextField(&quo
objectserializable
import java.io.Serializable; public class Greeting implements Serializable { public void greeting() { System.out.println("你好"); } }[@more@]import java.io.*;public class SerializingDemo { public static void main(String[]args) { FileOutputStream objectFile; ObjectOutputStream objectout; Greeting greetingObject = new Greeting(); try { //创建文件输出流对象 objectFile = new FileOutputStream("e:toolsmyobject"); //创建对象输出流对象 objectout = new ObjectOutputSt
spring学习
framework tech app ------------------------------------ 事务是一个典型的切面 spring.jar beansfactory applicationcontext webapplicationcontext -----------------------------------=- account user1 = new account java赋值方法:构造函数初始值 set 动态字节码asm reflect --------------------------------------- -------------------- protected ---------------------------------------------step 1: initialize spring factory or bean factory step2:[@more@]package com.test.spring;import java.sql.Timestamp;import
设置不输入密码直接登陆系统
单击“开始/运行”,输入“rundll32 netplwiz.dll,UsersRunDll”,按回车键后弹出“用户帐户”窗口,然后取消选定“要使用本机,用户必须输入用户名和密码”选项,单击确定,在弹出的对话框中输入你想让电脑每次自动登录的账户和密码即可。[@more@]
hibernate学习
现将资料整理出来,过几天不要忘记了1.启动java自带的数据库2.对关系表test进行对象化处理3.试创建类Test 向表插入一条数据4对对象化的表进行配置,配置Account.hbm.xml5.配置hibernate.cfg.xml进行ORMapping6.创建使用hibernate的类AccountTest[@more@]现将资料整理出来,过几天不要忘记了1.启动java自带的数据库startHsql.bat内容如下:start java -classpath ../lib/hsqldb.jar org.hsqldb.Server可以通过db brower查看相关信息,然后配置HSQL驱动----------------------driver:HSQLDB添加驱动libhsqldb.jarjdbc:hsqldb:hsql://localhos