23,404
社区成员
发帖
与我相关
我的任务
分享
CREATE OR PEPLACE PROCEDURE 存储过程名 IS
BEGIN
NULL;
END;
Calender c=Calender.getInstance();
System.out.println("年:"+c.get(Calender.YEAR));
System.out.println("月:"+c.get(Calender.MONTH)+1);
System.out.println("日:"+c.get(Calender.DAY_OF_MONTH));
System.out.println("24小时:"+c.get(Calender.HOUR_OF_DAY));
System.out.println("12小时:"+c.get(Calender.HOUR));
System.out.println("分:"+c.get(Calender.MNUTE));
System.out.println("秒:"+c.get(Calender.SECOND));
CREATE VIEW abc AS
SELECT a.aname,c.cname FROM a,b,c WHERE b.aid=a.aid AND c.bid=b.bid
SELECT aname,COUNT(*) FROM abc GROUP BY aname
SELECT s.* FROM (
(SELECT s1.* FROM 表名 AS s1 ORDER BY s1.列名 DESC LIMIT 3)
UNION
(SELECT s2.* FROM 表名 AS s2)
) AS s
public static void main(String[] args) throws Exception{
DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
DocumentBuilder db=dbf.newDocumentBuilder();
Document doc=db.parse("pet.xml"); //解析根目录下的pet.xml文件
NodeList dogList=doc.getElementByTagName("dog"); //dog根节点
for(int i=0;i<dogList.getLength();i++){
Node dog=dogList.item(i);
Element ele=(Element)dog;
String id=ele.getAttribute("id"); //得到dog节点的id属性
System.out.println(id);
for(Node node=dog.getFirstChild();node!=null;node=node.getNextSibling()){ //循环dog节点中的子节点
if(node.getNodeType()=node.ELEMENT_NODE){
String name=node.getNodeName(); //得到节点名称
String value=node.getFirstChild().getNodeValue(); //得到值
System.out.println(name+"——"+value);
}
}
}
}
public class JDBC{
private static String driver="Oracle.jdbc.Driver.OracleDriver";
private static String url="jdbc:Oracle:this:@127.0.0.1:1532:数据库名称";
private static String user="账号";
private static String password="密码";
public Connection getConn(){
Connection conn=null;
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
}catch(Exception e){
e.printStackTrace();
}
}
}
public static void main(String[] args){
int iCount=100/5;
int jCount=100/3;
for(int i=1;i<=iCount;i++){
for(int j=i;j<=jCount;j++){
int k=100-i-j;
if(i*5+j*3+k*0.5==100){
System.out.println(i+"-------"+j+"-------"+k);
}
}
}
}
public void sort(int[] data){
for(int i=0;i<data.length:i++){
for(int j=data.length-1;j>i;j--){
if(data[j]<data[j-1]){
int temp=data[j];
data[j]=data[j-1];
data[j-1]=temp;
}
}
}
}
public void sort(int[] data){
int temp;
for(int i=1;i<data.length;i++){
for(int j=i;(j>0)&&(data[j]<data[j-1]);j--){
int temp=data[j];
data[j]=data[j-1];
data[j-1]=temp;
}
}
}
public void sort(int[] data){
int temp;
for(int i=0;i<data.length;i++){
int lowIndex=i;
for(int j=data.length-1;j>i;j--){
if(data[j]<data[lowIndex]){
lowIndex=j;
}
}
int temp=data[i];
data[i]=data[lowIndex];
data[lowIndex]=temp;
}
}