PostgreSQL

1.テーブルを作成する場合
CREATE TABLE PointUser(
— ユーザID
userid varchar(20),
— ユーザ名
username var ...

Java

Javaコード:
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
impor ...

Java

Javaコード:
String sql = “select * from user where name = ? and age < ?”;
PreparedStatement pstmt = connectio ...

Java

Javaコード

package itstudy;

public class SearchlastString {

public static void main(String[] args) {

MySQL

サンプル:
SELECT
str_to_date(
concat (left(date_str,10) , right(date_str,10)),
‘%Y/%m/%d %H:%i:%s&# ...

Java

Javaコード:
import java.util.Date;
import java.text.DateFormat;

public class DateDemo{
public static v ...

Java

Javaコード
try {
ZipOutputStream out = new ZipOutputStream(new FileOutputStream(outfilePath));
byte;
int ...

Java

javaコード
class DemoCft {

public static Object mapToObject(Map<String, Object> map, Class<?> bean ...

Java

Javaコード:
class IntrospectorDemo {

public static Object mapToObject(Map<String, Object> map, Class< ...

DataBase

サンプル
select *
from tableName t
start with t.columnName_A = ‘value’
connect by prior t.col ...