- 博客(9)
- 资源 (1)
- 收藏
- 关注
原创 java利用dom/jdom解析XML
xml:<?xml version="1.0" encoding="UTF-8"?><beans> <bean id="v" class="com.bjsxt.spring.factory.Train"> </bean></beans>jdom:package com.bjsxt.spring.factor...
2019-08-23 21:49:24 95
原创 poi读取excel文件
package cn.appkit.cpm.importor;import java.io.FileInputStream;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org...
2019-08-18 15:25:49 91
原创 SQLSERVER实现多列IN的几种方法
1. EXISTSSELECT a.OBJECT_ID,ROW_NUMBER() OVER (PARTITION BY a.FHMDDM,a.SHMDDM,a.SJQJRJ ORDER BY a.HH) ,a.YDH,a.FHMDDM,a.SHMDDM,a.SJQJRJFROM dbo.CBZD a WHERE a.JFZL IS NOT NULL AND EXISTS (S...
2019-08-04 10:57:46 3304
原创 c#非工作日计算
/* 2019.7.25,计算扣除非工作日天数*/ using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using CpmBigDataImportService;namespace GT{ /// <s...
2019-08-03 21:47:57 188
原创 C#浮点数doublue比较
public class THKK : DealDR { public DataRow DealDataRow(DataRow dr) { double jfzl = double.Parse(dr["jfzl"].ToString()); double sz = double.Parse(dr["s...
2019-08-03 21:44:13 886
原创 C#更新sqlserver数据库方法
1. DataAdapter+SqlCommandBuilder(效率低,适用于少量数据) /// <summary> /// 更新数据 /// </summary> public void UpdateData() { for (int i = 0; i < ...
2019-08-03 20:25:32 2278
原创 SQLSERVER修改primarykey,unique
ALTER TABLE dbo.CBZD ADD PRIMARY KEY (OBJECT_ID)GOALTER TABLE dbo.CBZD ALTER COLUMN WJM NVARCHAR(100) NOT NULLGOALTER TABLE dbo.CBZD ALTER COLUMN HH INT NOT NULLGOALTER TABLE dbo.CBZD ADD UN...
2019-08-03 15:07:19 244
原创 c#设置sqlserver用户sa为10位数随机密码并输出文本
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Text.RegularExpressions;using System.IO;using CpmBigDataImportServi...
2019-08-02 16:06:44 267
原创 C#生成指定位数包含字母与数字随机密码
public static string GetPassword(int length) { string code = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; Random rand = new Random(); ...
2019-08-02 09:26:23 441
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人