tangzlboy
- 浏览: 90056 次
- 性别:
- 来自: 南京
-
最新评论
-
aoyoo111：
很好谢谢以保存嘿嘿嘿嘿嘿嘿嘿
java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB -
cuisuqiang：
标题很新颖，可是没看懂说的什么
时间控件的设计
文章列表
<script type="text/javascript">
function isValidate(form)
{
//取得用户登录信息
username = form.username.value;
userpass = form.userpass.value;
//判断用户名长度
if(!minLength(username,6))
{
alert("用户名长度小于6位！");
form.username.focus();
return ...
1.停止mysql
kill -9 `ps -ef | grep mysqld_safe| grep -v grep| awk '{print $2}'`
kill -9 `ps -ef | grep 'mysqld' | grep -v grep| awk '{print $2}'`
2.启动mysql
cd /usr/local/mysql-5.4.1-beta-linux-x86_64-glibc23
/bin/sh bin/mysqld_safe --user=mysql &
3.启动apache
cd /usr/local/apache-tomcat-5.5.27/bi ...
第一句：
1.添加字段
alter table versionManage add cr varchar(20) null;
2.在指定的字段后，添加字段
alter table versionManage add column cr varchar(20) after RDPM; X
alter table versionManage add cr varchar(20) after RDPM;
第二句：删除字段
alter table versionManage drop column cr;
第三句：修改字段
alter table versionManage alter colum ...
function function_Name(exp1,exp2,exp3,exp4){
Number =function_Name.arguments.length;
if (Number>1)
document.wrile(exp2);
if (Number>2)
document.write(exp3);
if(Number>3)
document.write(exp4);
浏览了很多的页面，就这种方法，
还有其他方法吗，请大家帮帮忙？
第一步：页面设计
<script type="text/javascript" src="<%=request.getContextPath()%>/js/Calendar.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/getDate.js"></script>
<td class="tdtitle"& ...
1.java_web知识:http://syhu100200.iteye.com/blog/837042
2.javaScript知识:http://blog.csdn.net/satellite0818ok/article/details/2124037
3.oracle知识：http://hi.baidu.com/%CE%D2%B0%AE%D5%C5%D3%B1/blog/item/43df79fbe5166d6e024f56b2.html
http://dongycumt.blog.sohu.com/109807161.html
4.spring知识：http://ruilinrui ...
第一步：导dwr.jar,commons-logging-1.0.4.jar,
commons-logging-adapters-1.1.jar,
commons-logging-api-1.1.jar
第二步：写web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns: ...
难读，易改 (java 代码)
- 博客分类：
- Java代码
int a = 4;
int b = 7;
int c = 10;
String a_columns="substr(to_char(a.createTime,'yyyy-mm-dd'),1,";
String a_columns1 = ") as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsName ";
...
Mysql数据库，Oracle数据库分别取得年，月，日。 年月，年月日。
Mysql语句：
select substr(a.createtime, 1, 4) as statisticsName from defect1 a;
select substr(a.createtime, 1, 7) as statisticsName from defect1 a;
select substr(a.createtime, 1, 10) as statisticsName from defect1 a;
Oracle语句一：
select cn.statisticsID, cn.statis ...
1.条件查询主任务数据异常:ORA-01861: 文字与格式字符串不匹配
开始时间格式：to_date(t.beginDate,'yyyy-mm-dd')
结束时间格式：to_date(t.endDate,'yyyy-mm-dd')
if(beginDate != null && !"".equals(beginDate))
{
if("1".equals(dateType)) // 按预期启动时间查询 1 预期启动 2 预期结束
{
sqlBuilder.append( ...
if(Utility.isNotEmpty(taskVo.getSiteId()) && !"0".equals(taskVo.getSiteId()))
{
String si[] = taskVo.getSiteId().split("-");
build.append(" and st.siteId ='").append(si[0]).append("'");
}
if(beginDate != null && !"".equals( ...
1.条件查询主任务数据异常:ORA-01861: 文字与格式字符串不匹配
开始时间格式：to_date(t.beginDate,'yyyy-mm-dd')
结束时间格式：to_date(t.endDate,'yyyy-mm-dd')
if(beginDate != null && !"".equals(beginDate))
{
if("1".equals(dateType)) // 按预期启动时间查询 1 预期启动 2 预期结束
{
sqlBuilder.append( ...
select * from sitepro_attr where site_id ='CHN0224'and rownum <= 1 order by product_id
select data_name from dataBank where rownum <= 1 order by id;
select id , site_name from site1 where site_name = '塔吉克';
select * from site1 where site_id = 'TJK0003'
union
select * from site1 where sit ...
mysql语句改成oracle语句
- 博客分类：
- Oracle数据库
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x left join site1 s on x.siteName = s.site_id
group by x.id ,x.siteName ,s.site_name , x.flg, x.product
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product ...
package com.huawei.socketstudy;
import java.net.ServerSocket;
import java.net.Socket;
import java.io.*;
public class Server
{
static BufferedReader socketReader = null;
static PrintWriter socketWriter = null;
public static void main(String[] args) throws Exception
{
//创建服务 ...