gissn.dev

2016년 11월 5일 토요일

MySql

// database作成
create database myspring;

// database 参照
select database();

// database使用
use myspring;

// テーブル参照;
show tables;

//fileから sql実行
source c:\work\dev\mysql\myspring\user.sql ;
---------------------------------------------------------------
CREATE TABLE myspring.user
(
user_id VARCHAR(12) NOT NULL,
user_password VARCHAR(12) NOT NULL,
first_name VARCHAR(45) ,
last_name VARCHAR(45) ,
last_update TIMESTAMP(0),
CONSTRAINT PRIMARY KEY (user_id)
);
----------------------------------------------------------------

eclipse
実行構成
Mavenビルド
基底ディレクトリ →　　　${workspace_loc:/MySpring}
ゴール →　mybatis-generator:generate

MySql

test add

<html>
<head>
<title>TODO supply a title</title>

<style>
body{
color: gray;
}
table {
border:1px solid red;
}

td{
background: white;
border:1px solid black;
}
</style>
<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.1.1.min.js"></script>
</head>
<body>
<div id="ddd1" style="display: display;">

<table>
<tr>
<td>test1</td>
</tr>
<tr>
<td>
<button id="delBtn1" name="delBtn">DEL</button>
</td>
</tr>
</table>
</div>
<div id="ddd2" style="display: none;">

<table>
<tr style="display: display;">
<td>test2</td>
</tr>
<tr>
<td>
<button id="delBtn2" name="delBtn">DEL</button>
</td>
</tr>
</table>
</div>
<div id="ddd3" style="display: none;">

<table>
<tr style="display: display;">
<td>test3</td>
</tr>
<tr>
<td>
<button id="delBtn3" name="delBtn">DEL</button>
</td>
</tr>
</table>
</div>
<div id="ddd4" style="display: none;">

<table>
<tr style="display: display;">
<td>test4</td>
</tr>
<tr>
<td>
<button id="delBtn4" name="delBtn">DEL</button>
</td>
</tr>
</table>
</div>
<div id="ddd5" style="display: none;">

<table>
<tr style="display: display;">
<td>test5</td>
</tr>
<tr>
<td>
<button id="delBtn5" name="delBtn">DEL</button>
</td>
</tr>
</table>
</div>
<table>
<tr>
<td>
<button name="addBtn">ADD</button>
</td>
</tr>
</table>
<script type="text/javascript">
$(function () {
var maxSize = 5;
var cntOfDisplayddd;
var idxValOfDisplayddd;
ctlDisplayOfDelBtn();

// DELボタン表示制御
function ctlDisplayOfDelBtn() {
// delボタン制御
cntOfDisplayddd = 0;
for (var idx = 1; idx <= maxSize; idx++) {
var idVal = "ddd" + idx;
// 削除ボタン表示判定
if ($('div[id=' + idVal + ']').css('display') !== 'none') {
cntOfDisplayddd++;
idxValOfDisplayddd = idx;
}
}
// 削除ボタンが1個の場合は、表示させない
if (cntOfDisplayddd === 1) {
$('button[id=delBtn' + idxValOfDisplayddd + ']').css('display', 'none');
}
}

// ADDボタン制御
$('button[name=addBtn]').on('click', function () {
// 最大追加数分の処理
for (idx = 1; idx <= maxSize; idx++) {
var idVal = "ddd" + idx;

// 削除ボタン表示
$('button[id=delBtn' + idx + ']').css('display', '');

// ddd領域が非表示の領域を表示させる
if ($('div[id=' + idVal + ']').css('display') === 'none') {
// ddd情報表示
$('div[id=' + idVal + ']').css('display', '');
// ddd領域がMaxの場合、ADDボタンを非表示設定
if (idx === maxSize) {
$('button[name=addBtn]').css('display', 'none');
}
break;
}
}
});

// DELボタン押下時処理
$('button[name=delBtn]').on('click', function () {
//alert('hello');
for (var idx = 1; idx <= maxSize; idx++) {
var idVal = "ddd" + idx;

// 削除対象のddd領域の非表示設定
if (event.target.id === 'delBtn' + idx) {
$('div[id=' + idVal + ']').css('display', 'none');
var divEl = $('div[id=' + idVal + ']');
divEl.find('input').val('');
divEl.find('input:checked').prop('checked', false);
divEl.find('select option:selected').prop('selected', false);
divEl.find('textarea').val('');
}
}

// ADDボタン表示設定
if (!$('button[name=addBtn]').css('display', '')) {
$('button[name=addBtn]').css('display', '');
}

// DELボタン表示制御
ctlDisplayOfDelBtn();
});
});

</script>
</body>
</html>

2016년 8월 5일 금요일

html　テスト

test:

2016년 6월 20일 월요일

memo

create table schema1.user (id varchar(12) not null, pw varchar(12) not null,name varchar(24) not null, address varchar(100), primary key(id))

insert into schema1.user values ('admin','admin','adminName','in japan')

spring

1. 動的Webプロジェクト生成
(tomcat 1.8選択)

2. プロジェクトの構成からMavenに変更

3. pom.xmlの依存関係設定
spring-web
spring-webmvc
jstl
commons-logging

4. プロジェクトの実行 --> Maven Install

5. index.jsp
Webcontent/index.jsp
---------------------------------------------------------------------------
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<script type="text/javascript">
function send(ele){
ele.submit;
}
</script>
<h3>login</h3>
<form name="frm" action="login.do" method="post">
id <input type="text" maxlength="6" size="6" name="id">
pw <input type="password" maxlength="6" size="6" name="pw">

<button onclick="send('frm');">login</button>
</form>
</body>
</html>
----------------------------------------------------------------------------

6. web.xml
Webcontent/WEB-INF/web.xml
---------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
<display-name>SpringTest</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>

<servlet>
<servlet-name>springTest</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springTest</servlet-name>
<url-pattern>/welcome.jsp</url-pattern>
<url-pattern>*.do</url-pattern>
</servlet-mapping>

</web-app>
----------------------------------------------------------------------------

7.springTest-servlet.xml
Webcontent/WEB-INF/springTest-servlet.xml
----------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
<display-name>SpringTest</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>

<servlet>
<servlet-name>springTest</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springTest</servlet-name>
<url-pattern>/welcome.jsp</url-pattern>
<url-pattern>*.do</url-pattern>
</servlet-mapping>

</web-app>
----------------------------------------------------------------------

8.logon.jsp
Webcontent/WEB-INF/jsp/logon.jsp
----------------------------------------------------------------------
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
${id}, welcome!!!!
</body>
</html>
--------------------------------------------------------------------

9.TestController.java
javaリソース/src/com/controller/TestController.java
-------------------------------------------------------------------
package com.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

/**
* <pre>
* 〖概要〗
* テストコントローラ
* 〖説明〗
*
* </pre>
* @author user
*
*/
@Controller
public class TestController {

@RequestMapping(value="/login", method=RequestMethod.POST)
public ModelAndView method1(@RequestParam("id") String id){
return new ModelAndView("logon", "id", id);
}

@RequestMapping("/request2")
public ModelAndView method2(){
return new ModelAndView();
}

}
-------------------------------------------------------------------

2016년 6월 19일 일요일

eclipse　DBツリービュー設定

eclipse　DBツリービュー設定

mysql

データベース定義名　sakila

path

C:\Users\user\.m2\repository\mysql\mysql-connector-java\5.1.33\mysql-connector-java-5.1.33.jar

JDBC DRIVER: com.mysql.jdbc.Driver

接続文字列： jdbc:mysql://localhost:3306/sakila

接続 user gissn

接続 password *****

接続スキーマ sakila

DB2の場合
<classPathEntry location="C:\work\tools\IBM\SQLLIB\java\db2jcc.jar" />

JDBC DRIVER: com.ibm.db2.jcc.DB2Driver
JDBC TYPE : typye4

接続文字列： jdbc:db2://localhost:50000/TEST1

接続 user user

接続 password *****

接続スキーマ SHEMA1

※接続エラーの場合↓
管理者権限でDB2 Command windowを開いて、下記実施
db2set DB2COMM=tcpip
db2stop
db2start

=====================================================================================
package MyBatisSample.MyBatisSample;
import java.sql.Connection;
import java.sql.DriverManager;

public class Test {
public static void main(String[] args) {
String url = "jdbc:db2://localhost:50000/TEST1";
String user = "user";
String pass = "1234";
String name = "";
String id="admin";
Connection con = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
con = DriverManager.getConnection(url, user, pass);
PreparedStatement pre = con.prepareStatement("select * from schema1.user where id = ?");
pre.setString(1, id);
ResultSet rs = pre.executeQuery();
while (rs.next()) {
name = rs.getString("name");
System.out.printf("name: %s",name);
}

} catch (Exception e) {
// TODO 自動生成された catch ブロック
e.printStackTrace();
}
con.close();
// public static void main(String[] args) {
// try {
// String url = "jdbc:mysql://localhost/sakila";
// String user = "gissn";
// String pass = "admin";//
// Class.forName("com.mysql.jdbc.Driver");//
// Connection con = DriverManager.getConnection(url, user, pass);
// con.close();//
// System.out.println("接続成功");
//
// } catch (Exception e) {
// e.printStackTrace();
// }
// }

}

===============================================================