[B! java][jdbc] yassã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yass id:yass

javaã¨jdbcã«é–¢ã™ã‚‹yassã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (28)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

GitHub - arnaudroger/SimpleFlatMapper: Fast and Easy mapping from database and csv to POJO. A java micro ORM, lightweight alternative to iBatis and Hibernate. Fast Csv Parser and Csv Mapper
yass 2016/06/11
java

ORM

csv

jdbc

jooq

sql2o

sql
ãƒªãƒ³ã‚¯
Fluent JDBC Decorator
String name = new JdbcSession(source) .sql("SELECT name FROM employee WHERE id = ?") .set(1234) .select(new SingleOutcome<String>(String.class)); Simple and straight forward, isnâ€™t it? The library simplifies interaction with relational databases via JDBC, avoiding the need to use ORM. jcabi-jdbc is a lightweight wrapper of JDBC. It is very convenient to use when you donâ€™t need a full-scale ORM (li
yass 2015/12/26
database

java

jdbc

orm
ãƒªãƒ³ã‚¯
log4jdbc ã¯ logback ã®è¨å®šã‚’ãƒŸã‚¹ã£ã¦ã‚‹ã¨ã™ã’ãƒ¼é…ã„ - tokuhirom's blog
log4j dbc ã¯ logback ã®è¨å®šã‚’ãƒŸã‚¹ã£ã¦ã‚‹ã¨ã™ã’ãƒ¼é…ã„ log4j dbc ã‚’ä½¿ã†ã¨ jdbc ã§ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸã‚¯ã‚¨ãƒªã®ãƒã‚°ãŒç°¡å˜ã«ã¨ã‚Œã¦ä¾¿åˆ©ãªã®ã ãŒã€è¨å®šã‚’èª¤ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¶…çµ¶åŠ£åŒ–ã•ã›ã¦ãã‚‹ã®ã§æ³¨æ„ãŒå¿…è¦ã§ã‚ã‚‹ã€‚ log4j dbc ã¯ãƒ‡ãƒãƒƒã‚°ãƒ¬ãƒ™ãƒ«ã ã¨ Throwable ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’å–å¾—ã—ã¦ã‚¹ã‚¿ãƒƒã‚¯ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã£ã¦ã€å‘¼ã³å‡ºã—å…ƒã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ã€‚ ã“ã‚ŒãŒæ¥µã‚ã¦é…ã„ã€‚æœ¬å½“ã«é©šãã»ã©é…ã„ã€‚ â†“å…·ä½“çš„ã«ã¯ã“ã®ã¸ã‚“ã§ã‚ã‚‹ã€‚ private static String getDebugInfo() { Throwable t = new Throwable(); t.fillInStackTrace(); StackTraceElement[] stackTrace = t.getStackTrace(); if (stackTrace != null) https://git
yass 2015/08/16
java

jdbc

log
ãƒªãƒ³ã‚¯
Querying Your Database from Millions of Fibers (Rather than Thousands of Threads)
Java, SQL and jOOQ. Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.
yass 2015/06/27
JDBC

quasar

java

thread

concurrency

database
ãƒªãƒ³ã‚¯
brettwooldridge/SansOrm Â· GitHub - A "No-ORM" sane SQL <-> Java object mapping library
SansOrm is not an ORM. SansOrm library will... Massively decrease the boilerplate code you write even if you use pure SQL (and no Java objects) Persist and retrieve simple annotated Java objects, and lists thereof, without you writing SQL Persist and retrieve complex annotated Java objects, and lists thereof, where you provide the SQL SansOrm will never... Perform a JOIN for you Persist a graph of
yass 2015/02/14
java

orm

jdbc

sql

jdbi
ãƒªãƒ³ã‚¯
GitHub - brettwooldridge/HikariCP: å…‰ HikariCPãƒ»A solid, high-performance, JDBC connection pool at last.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
yass 2015/02/14
Java

JDBC

connection pooling

connection
ãƒªãƒ³ã‚¯
jcabi-jdbc â€“ Fluent JDBC Wrapper
JdbcSession is a convenient fluent wrapper around JDBC. Read this blog post: Fluent JDBC Decorator. import com.jcabi.jdbc.JdbcSession; public class Main { public static void main(String[] args) throws SQLException { String name = new JdbcSession(source) .sql("SELECT name FROM foo WHERE id = ?") .set(123) .select(new SingleOutcome<String>(String.class)); } }
yass 2014/11/02
" Fluent JDBC Wrapper / String name = new JdbcSession(source) .sql("SELECT name FROM foo WHERE id = ?") .set(123) .select(new SingleOutcome<String>(String.class)); "

jdbc

java

fluent
ãƒªãƒ³ã‚¯
Introducing JDBCMetrics
22 May 2013 I've been working with different Java web applications since the late 90's and when there have been performance issues, I would say that 99% of the time, the probl em is the database, or rather how it is used. At my last company (Josh) we had a really good connection pool wrapper, that collected data and made us know exactly what happens to the database. But that code isn't Open Source
yass 2014/10/10
java

jdbc

metrics

monitoring

log
ãƒªãƒ³ã‚¯
Write SQL in Java 8 using ResultSet Streams.
SQL in Java 8: ResultSet Streams. With Java 8, writing SQL will change fundamentally, no matter what API you're using. List<Schema> result = new ArrayList<>(); try (Connection c = getConnection()) { String sql = "select schema_name, is_default " + "from information_schema.schemata " + "order by schema_name"; try (PreparedStatement stmt = c.prepareStatement(sql); ResultSet rs = stmt.executeQuery())
yass 2014/03/04
java

java8

sql

jdbc

jooq

DbUtils

comparison
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
yass 2014/02/15
" Vibur DBCP is a concurrent,Â fastÂ and fully-featured JDBC connection pool based on JavaÂ dynamic proxies. It supports a fairness parameter, statement caching, SQL queries logging, and Hibernate integration, among other features. "

jdbc

java

connection

pooling

database
ãƒªãƒ³ã‚¯
DBCP ã‚ˆã‚Š 50å€æ—©ã„ï¼ï¼Ÿ BoneCP ã‚’ä½¿ã£ã¦é«˜é€Ÿã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ã™ã‚‹æ–¹æ³• : NETBUFFALO
import java.sql.Connection; import java.sql.SQLException; import com.jolbox.bonecp.BoneCP; import com.jolbox.bonecp.BoneC PConfig; public class MyBoneCPApp { private BoneCP bcp = null; private String driverClassName = "com.mysql.jdbc.Driver"; private String username = "root"; private String password = ""; private String url = "jdbc:mysql://localhost/test"; public void init() throws ClassNotFoundExc
yass 2013/11/08
java

database

jdbc

connection

pooling
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
yass 2013/04/27
database

JDBC

async

java
ãƒªãƒ³ã‚¯
Jdbi 3 Developer Guide
Release 3.51.0 - 2025-12-09 Release 3.50.0 - 2025-11-04 Release 3.49.6 - 2025-10-02 - This is the last release of Jdbi to support Java 11! Release 3.49.5 - 2025-06-13 Release 3.49.4 - 2025-05-16 Release 3.49.3 - 2025-05-01 Release 3.49.2 - 2025-04-27 Release 3.49.1 - 2025-04-22 Release 3.49.0 - 2025-03-26 Release 3.48.0 - 2025-02-12 Release 3.47.0 - 2024-10-25 Release 3.46.0 - 2024-10-15 Release 3
yass 2012/08/13
java

jdbc

orm

database

sql

yammer

jdbi
ãƒªãƒ³ã‚¯
JNDIã‚’ã•ã‚‰ã£ã¨æŒ¯ã‚Šè¿”ã‚‹ - nekop's blog
JBoss Advent Calendar 2011ã®12æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ JNDIã¯Java EEã‚µãƒ¼ãƒã®EJBã€JDBCãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã‚„JMSã®ConnectionFactoryãªã©ã€å„ç¨®ã‚µãƒ¼ãƒ“ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ã‚¨ãƒ³ãƒˆãƒªãƒã‚¤ãƒ³ãƒˆã¨ãªã‚‹éƒ¨åˆ†ãªã®ã§ã™ãŒã€ã‚ã¾ã‚Šã‚¨ã‚ã‚µã‚¤ãƒ†ã‚£ãƒ³ã‚°ãªæŠ€è¡“ã§ã¯ãªã„ã®ã§æ³¨ç›®ã•ã‚Œã‚‹ã“ã¨ã¯ãªã„ã§ã™ã—ã€ã©ã®ã‚ˆã†ãªã‚‚ã®ãªã®ã‹ã‚’èª¿ã¹ãŸã‚Šã™ã‚‹æ©Ÿä¼šã‚‚ãªã‹ãªã‹ãªã„ã§ã—ã‚‡ã†ã€‚ã¨ã„ã†ã‚ã‘ã§ã•ã‚‰ã£ã¨æŒ¯ã‚Šè¿”ã‚Šã¾ã™ã€‚ ã¾ãšåŸºæœ¬çš„ãªæ©Ÿèƒ½ã¯ãƒªãƒ¢ãƒ¼ãƒˆã‚¢ã‚¯ã‚»ã‚¹ã‚‚ã§ãã‚‹ã‚µãƒ¼ãƒä¸Šã®ã‚°ãƒãƒ¼ãƒãƒ«HashMapã¿ãŸã„ãªã‚‚ã®ã§ã™ã€‚ãƒ¡ã‚½ãƒƒãƒ‰åãŒã¡ã‚‡ã£ã¨é•ã„ã€get()ã§ã¯ãªãlookup()ã€put()ã§ã¯ãªãrebind()ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã‚’å–å¾—ã™ã‚‹ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã¯ã“ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ InitialContext context = new InitialContext(); DataSou
yass 2011/12/15
JNDI

java

jdbc
ãƒªãƒ³ã‚¯
JPAã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ã§ãƒã‚¤ãƒ³ãƒˆã¨ãªã‚‹æ°¸ç¶šã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã«ã¤ã„ã¦ - é”äººãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã‚’ç›®æŒ‡ã—ã¦
å…ˆé€±æ›¸ã„ãŸã‚¨ãƒ³ãƒˆãƒªJava EE6æ¨™æº–ã®ç¯„å›²ã§ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«ä½œæˆã§ãã‚‹ã“ã¨ã‚’ç¢ºã‹ã‚ã¦ã¿ã¾ã—ãŸã€‚ - é”äººãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã‚’ç›®æŒ‡ã—ã¦ã§ã€Java EE6ã®æ¨™æº–ä»•æ§˜ã‚’ä½¿ã†ã ã‘ã§ã€ã‹ãªã‚Šã‚·ãƒ³ãƒ—ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã®CRUDå‡¦ç†ã‚’è¡Œã†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä½œæˆã§ãã‚‹ã“ã¨ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ãŸã ã—ã€å‰å›žã¯å…¨ä½“ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ãŸã ã‘ãªã®ã§ã€ç´°ã‹ã„ä»•æŽ›ã‘ã«ã¤ã„ã¦ã¯è§£èª¬ã—ãã‚Œã¾ã›ã‚“ã§ã—ãŸã€‚ä»Šå›žã¯ã€å‰å›žã«å¼•ãç¶šãç‰¹ã«JPAã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã®éƒ¨åˆ†ãŒã©ã†ãªã£ã¦ã„ã‚‹ã®ã‹ã‚’ã‚‚ã†å°‘ã—æŽ˜ã‚Šä¸‹ã’ã¦è§£èª¬ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãªãŠã€ã“ã®å ´ã§å®£ä¼ã§ã™ãŒã€8æœˆ10æ—¥ï¼ˆæ°´ï¼‰ã«Glassfishãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚°ãƒ«ãƒ¼ãƒ—ã®å‹‰å¼·ä¼šã«ã¦ãŠè©±ã‚’ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ GlassFish Japan Users Group å‹‰å¼·ä¼š 2011 Summer : ATND ç§ã¯Java EE6ã‚’ä½¿ã£ãŸé–‹ç™ºã«ã¤ã„ã¦
yass 2011/12/04
java

jpa

jdbc

database

ORM
ãƒªãƒ³ã‚¯
Commons DBCPã‚’è¶…ãˆã‚‹Tomcat JDBC Poolã¨ã¯
Commons DBCPã‚’è¶…ãˆã‚‹Tomcat JDBC Poolã¨ã¯ï¼šTomcat 7ã®æ–°æ©Ÿèƒ½ã§ä½•ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã‹ï¼Ÿï¼ˆç•ªå¤–ç·¨ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ Tomcatã®DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã¯2ã¤ã‚ã‚‹ ï¼ ITèªè€…ã®çš†ã•ã‚“ã¯ã€ŒTomcat JDBC Connection Poolã€ã‚’ã”å˜ã˜ã§ã™ã‹ï¼Ÿ é€šå¸¸ã€Tomcatã®DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã¨ã„ãˆã°Apache Commonsãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã€ŒCommons DBCPã€ã‚’æƒ³åƒã™ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€Tomcatã«ã¯ã€ŒCommons DBCPã€ä»¥å¤–ã«ã‚‚DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã®å®Ÿè£…ãŒå˜åœ¨ã—ã¾ã™ã€‚ãã‚ŒãŒã€ã€ŒTomcat JDBC Connection Poolã€ï¼ˆä»¥ä¸‹ã€Tomcat JDBC Poolï¼‰ã§ã™ã€‚ Tomcat JDBC Poolã¨ã¯ã€Apache Tomcatãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒç‹¬è‡ªã«ä½œæˆã—ãŸDBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒ¼ãƒ«ã®å®Ÿè£…ã®ã“ã¨ã§ã™ã€‚
yass 2011/11/08
jdbc

connection

java

tomcat

tomcat7

database
ãƒªãƒ³ã‚¯
MyBatis â€“ JDBC â€“ Amazon RDS (MySQL)ã§æ—¥ä»˜ã‚’æ‰±ã†å ´åˆã®æ³¨æ„ç‚¹ Â« ãƒã‚¸ã‚«ãƒ«ã«ã‚¢ãƒŠãƒã‚°ã§ã€‚
ä»Šã¾ã§ã¯PostgreSQLæ´¾ã ã£ãŸã®ã§ã™ãŒã€Amazon RDSãŒMySQLã ã¨è¨€ã†äº‹ã‚‚ã‚ã‚Šã€æœ€è¿‘ã¯ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®RDBMSã¨ã—ã¦MySQLã‚’ä½¿ã†æ©Ÿä¼šãŒå¤šããªã£ã¦ãã¾ã—ãŸã€‚ ã“ã®é–“ã€ä½•æ°—ãªãDATETIMEåž‹ã®ã‚«ãƒ©ãƒ ã‚’ä½œã£ã¦ã€Javaå´ã§ new Date()ã—ã¦ MyBatisã§ã•ãã•ãã¨ INSERTã—ã¦ã¿ãŸã®ã§ã™ãŒã€ãªã‚“ã‹ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ãŒãšã‚Œã¦æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ãªã€ã€ã€ã¨ã„ã†å•é¡Œã«éé‡ã—ã¾ã—ãŸã€‚ ä»¥ä¸‹ã€ãã®éš›ã®æ ¼é—˜ãƒ¡ãƒ¢ã§ã™ã€‚ ã¾ãšã€Amazon RDS (MySQL) ã¯ UTCã§å‹•ã„ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ã®SQLã§ç¢ºèªã—ã¾ã—ãŸã€‚ mysql> SELECT @@global.time_zone, @@session.time_zone; +--------------------+---------------------+ | @@global.time_zone | @@session
yass 2011/08/22
jdbc

java

timezone

aws

RDS

utc

MyBatis
ãƒªãƒ³ã‚¯
ORãƒžãƒƒãƒ‘ãƒ¼ãªã‚‰DomaãŒä¸€ç•ªã€‚ - newta(ã«ã‚…ãƒ¼ãŸ)ã®æ—¥è¨˜
ã™ã£ã‹ã‚Šæ˜Žã‘ã¦ã¾ã™ãã€‚ ã¾ã‚ã€å¤ãã‚‰ã„ã‹ã‚‰æ›´æ–°ã—ã¦ãªã„ã§ã™ãŒã€‚ã€‚ ã¨ã‚‚ã‹ãã€ä»Šå¹´ã‚‚ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ ã§ã€Domaãªã‚“ã§ã™ã‘ã©ã€ å®Ÿè·µæŠ•å…¥ã™ã”ãã—ã¦ã¾ã™ã€‚ã„ã£ã±ã„ä½¿ã£ã¦ã¾ã™ã€‚æ„Ÿè¬ã€‚ ä»Šã®ã¨ã“ã‚ã€ORãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½¿ã†ãªã‚‰DomaãŒä¸€ç•ªã®é¸æŠžè‚¢ã§ã™ã€‚ ç†ç”± å°è±¡ã¯S2Daoã®ã‚ˆã†ã§ã€ S2Daoã‚ˆã‚Šã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹éƒ¨åˆ†ã§ã‹ã‚†ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šã„ã¦ã‚‹æ„Ÿã˜ã€‚ selectã¯å¤–ã ã—SQLã®ã¿ã«ã™ã‚‹ã“ã¨ã§å®Ÿè¡Œã•ã‚Œã‚‹SQLãŒåˆ†ã‹ã‚Šã‚„ã™ã å®šç¾©ç®‡æ‰€ãŒsqlãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã®ã¿ãªã®ã§ç®¡ç†ã—ã‚„ã™ã„ã€‚ SQLãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¯SQLã‚³ãƒ¡ãƒ³ãƒˆå†…ã«è¨å®šæ§‹æ–‡ã‚’æ›¸ãã®ã§ SQLã‚’ãã®ã¾ã¾å®Ÿè¡Œã—ã¦è©¦ã™ã“ã¨ãŒå‡ºæ¥ã‚‹ã€‚ aptã«ã‚ˆã‚‹ãƒã‚§ãƒƒã‚¯ã§ã€sqlãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¨æ¡ä»¶ã‚„valueã®å®šç¾©ã« é–“é•ã„ãŒã‚ã‚‹å ´åˆã€ã™ãã«åˆ†ã‹ã‚‹ã€‚ã“ã‚Œã¨ã£ã¦ã‚‚é‡è¦ã€‚ S2Daoä½¿ã£ã¦ãŸã‚‰å®Ÿè¡Œã—ãªã„ã¨åˆ†ã‹ã‚‰ãªã„äº‹ãŒã™ãåˆ†ã‹ã‚‹ã€‚ æ¡ä»¶ã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã®å®šç¾©å¿˜ã‚Œ
yass 2011/01/27
java

jdbc

ORM

database

Doma

seasar
ãƒªãƒ³ã‚¯
MockRunnerã®JDBC Mockã‚’ä½¿ã£ã¦ã¿ãŸ - ãŸã‘ãžã†ç€•æ»ãƒ–ãƒã‚°
S2Unitã¯DBã‚’ä½¿ã£ãŸãƒ¦ãƒ‹ãƒƒãƒˆãƒ†ã‚¹ãƒˆã®æ”¯æ´æ©Ÿèƒ½ã¨ã—ã¦Excelãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰DBã«ãƒ†ã‚¹ãƒˆç”¨ãƒ‡ãƒ¼ã‚¿ã‚’æŠ•å…¥ã—ãŸã‚Šã€Excelãƒ•ã‚¡ã‚¤ãƒ«ã¨DBã®å†…å®¹ã‚’æ¯”è¼ƒã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãŸã ã€å®Ÿéš›ã«ã‚„ã£ã¦ã¿ã‚‹ã¨ã‚ã‹ã‚‹ã®ã§ã™ãŒã“ã®Excelãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé¦¬é¹¿ã«ãªã‚Šã¾ã›ã‚“ã€‚ ãã“ã§ã€å®Ÿéš›ã«DBã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã®ã§ã¯ãªãã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚„JDBCãƒ‰ãƒ©ã‚¤ãƒã®ãƒ¬ã‚¤ãƒ¤ã§ç™ºè¡Œã•ã‚ŒãŸSQLã‚’æ¨ªå–ã‚Šã—ã€æœŸå¾…é€šã‚Šã®SQLãŒç™ºè¡Œã•ã‚ŒãŸã®ã‹ã©ã†ã‹ã‚’ç¢ºèªã™ã‚‹ã¨ã„ã†æ–¹æ³•ã¯ã©ã†ã ã‚ã†ï¼Ÿã¨è€ƒãˆã¾ã—ãŸã€‚ãã†ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’è‡ªä½œã—ã‚ˆã†ã‹ã¨ã‚‚æ€ã£ãŸã®ã§ã™ãŒï¼ˆå®Ÿéš›é€”ä¸ã¾ã§ä½œã£ã¦ã„ãŸã®ã§ã™ãŒï¼‰ã€ä¸–ã®ä¸åŒã˜ã“ã¨ã‚’è€ƒãˆã‚‹äººã¯ã„ã‚‹ã‚‚ã®ã§ã€MockRunnerã®JDBC Mockã¨ã„ã†æ©Ÿèƒ½ã‚’ä½¿ã†ã¨ãã®ã‚‚ã®ã‚ºãƒãƒªãªã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ http://mockrunner.sourceforge.net/examplesjdbc.html
yass 2010/12/29
å®Ÿéš›ã«DBã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã®ã§ã¯ãªãã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚„JDBCãƒ‰ãƒ©ã‚¤ãƒã®ãƒ¬ã‚¤ãƒ¤ã§ç™ºè¡Œã•ã‚ŒãŸSQLã‚’æ¨ªå–ã‚Šã—ã€æœŸå¾…é€šã‚Šã®SQLãŒç™ºè¡Œã•ã‚ŒãŸã®ã‹ã©ã†ã‹ã‚’ç¢ºèªã™ã‚‹ã¨ã„ã†æ–¹æ³•

java

test

jdbc

sql

mock
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
å®¶ã®ãªã‹ã‚’æ£®ã«ã—ãŸã„ã€ã¨ã„ã†æ¬²æœ› ä»Šå¹´ã¯ãªã‚“ã ã‹è¦³è‘‰æ¤ç‰©ã®è¦³å¯ŸãŒæ¥½ã—ã„ã€‚æœ¬æ—¥ã¯æ¤ç‰©ã«ã¤ã„ã¦ã®è¨˜äº‹ã§ã™ãŒã€åœŸã‚„æ ¹ã£ã“ãªã©ã®ç”»åƒã‚‚ã‚ã‚‹ã®ã§è‹¦æ‰‹ãªæ–¹ã¯é¿ã‘ã¦ãã ã•ã„ãã€‚ ãƒ•ã‚£ã‚«ã‚¹ãƒ»ã‚¦ãƒ³ãƒ™ãƒ©ãƒ¼ã‚¿ ã†ã¡ã®ãƒ¡ã‚¤ãƒ³çš„å˜åœ¨ã¯ãƒ•ã‚£ã‚«ã‚¹ãƒ»ã‚¦ãƒ³ãƒ™ãƒ©ãƒ¼ã‚¿ã€‚ã‚¦ãƒ³ãƒ™æ®¿ãŒæˆ‘ãŒå®¶ã«ã‚„ã£ã¦ããŸã®ã¯2020å¹´5æœˆã€‚ã‚³ãƒãƒŠç¦åˆâ€¦
yass 2010/07/17
java

jdbc

Doma

sql

database

ORM

seasar
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸