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
log4jdbc 㯠logback ã®è¨å®ããã¹ã£ã¦ãã¨ããã¼é ã log4jdbc ã使ã㨠jdbc ã§ã¢ã¯ã»ã¹ããã¯ã¨ãªã®ãã°ãç°¡åã«ã¨ãã¦ä¾¿å©ãªã®ã ããè¨å®ã誤ãã¨ããã©ã¼ãã³ã¹ãè¶ çµ¶å£åããã¦ããã®ã§æ³¨æãå¿ è¦ã§ããã log4jdbc ã¯ãããã°ã¬ãã«ã 㨠Throwable ã®ã¤ã³ã¹ã¿ã³ã¹ãåå¾ãã¦ã¹ã¿ãã¯ãã¬ã¼ã¹ãåã£ã¦ãå¼ã³åºãå ã®æ å ±ã表示ããã ãããæ¥µãã¦é ããæ¬å½ã«é©ãã»ã©é ãã âå ·ä½çã«ã¯ãã®ã¸ãã§ããã private static String getDebugInfo() { Throwable t = new Throwable(); t.fillInStackTrace(); StackTraceElement[] stackTrace = t.getStackTrace(); if (stackTrace != null) https://git
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
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)); } }
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 problem 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
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())
import java.sql.Connection; import java.sql.SQLException; import com.jolbox.bonecp.BoneCP; import com.jolbox.bonecp.BoneCPConfig; 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
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
JBoss Advent Calendar 2011ã®12æ¥ç®ã®ã¨ã³ããªã§ãã JNDIã¯Java EEãµã¼ãã®EJBãJDBCãã¼ã¿ã½ã¼ã¹ãJMSã®ConnectionFactoryãªã©ãå種ãµã¼ãã¹ã«ã¢ã¯ã»ã¹ããããã®ã¨ã³ããªãã¤ã³ãã¨ãªãé¨åãªã®ã§ããããã¾ãã¨ããµã¤ãã£ã³ã°ãªæè¡ã§ã¯ãªãã®ã§æ³¨ç®ããããã¨ã¯ãªãã§ãããã©ã®ãããªãã®ãªã®ãã調ã¹ããããæ©ä¼ããªããªããªãã§ããããã¨ããããã§ããã£ã¨æ¯ãè¿ãã¾ãã ã¾ãåºæ¬çãªæ©è½ã¯ãªã¢ã¼ãã¢ã¯ã»ã¹ãã§ãããµã¼ãä¸ã®ã°ãã¼ãã«HashMapã¿ãããªãã®ã§ããã¡ã½ããåãã¡ãã£ã¨éããget()ã§ã¯ãªãlookup()ãput()ã§ã¯ãªãrebind()ã¨ãªã£ã¦ãã¾ãã ãã¼ã¿ã½ã¼ã¹ãåå¾ãããããªã³ã¼ãã¯ãã®ããã«ãªãã¾ãã InitialContext context = new InitialContext(); DataSou
å 鱿¸ããã¨ã³ããªJava EE6æ¨æºã®ç¯å²ã§ãã«ã¹ã¿ãã¯ã®Webã¢ããªã±ã¼ã·ã§ã³ãç°¡åã«ä½æã§ãããã¨ã確ããã¦ã¿ã¾ããã - é人ããã°ã©ãã¼ãç®æãã¦ã§ãJava EE6ã®æ¨æºä»æ§ã使ãã ãã§ãããªãã·ã³ãã«ã«ãã¼ã¿ã®CRUDå¦çãè¡ãã¢ããªã±ã¼ã·ã§ã³ã使ã§ãããã¨ãç´¹ä»ãã¾ããããã ããååã¯å ¨ä½ã®ã¢ããªã±ã¼ã·ã§ã³ãç´¹ä»ããã ããªã®ã§ãç´°ãã仿ãã«ã¤ãã¦ã¯è§£èª¬ãããã¾ããã§ãããä»åã¯ãååã«å¼ãç¶ãç¹ã«JPAã使ã£ããã¼ã¿ãã¼ã¹ã¢ã¯ã»ã¹ã®é¨åãã©ããªã£ã¦ããã®ããããå°ãæãä¸ãã¦è§£èª¬ãã¦ã¿ããã¨æãã¾ãã ãªãããã®å ´ã§å®£ä¼ã§ããã8æ10æ¥ï¼æ°´ï¼ã«Glassfishã¦ã¼ã¶ã¼ã°ã«ã¼ãã®åå¼·ä¼ã«ã¦ã話ãããã¦ããã ããã¨ã«ãªãã¾ããã GlassFish Japan Users Group åå¼·ä¼ 2011 Summer : ATND ç§ã¯Java EE6ã使ã£ãéçºã«ã¤ãã¦
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ã³ãã¯ã·ã§ã³ã»ãã¼ã«ã®å®è£ ã®ãã¨ã§ãã
ä»ã¾ã§ã¯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
ãã£ããæãã¦ã¾ããã ã¾ããå¤ãããããæ´æ°ãã¦ãªãã§ãããã ã¨ããããä»å¹´ããããããé¡ããã¾ãã ã§ãDomaãªãã§ããã©ã å®è·µæå ¥ããããã¦ã¾ãããã£ã±ã使ã£ã¦ã¾ããæè¬ã ä»ã®ã¨ãããORãããã¼ã使ããªãDomaãä¸çªã®é¸æè¢ã§ãã çç± å°è±¡ã¯S2Daoã®ããã§ã S2Daoãããµãã¼ããã¦ããé¨åã§ãããã¨ããã«æãå±ãã¦ãæãã selectã¯å¤ã ãSQLã®ã¿ã«ãããã¨ã§å®è¡ãããSQLãåããããã å®ç¾©ç®æãsqlãã³ãã¬ã¼ããã¡ã¤ã«ã®ã¿ãªã®ã§ç®¡çããããã SQLãã³ãã¬ã¼ãã¯SQLã³ã¡ã³ãå ã«è¨å®æ§æãæ¸ãã®ã§ SQLããã®ã¾ã¾å®è¡ãã¦è©¦ããã¨ãåºæ¥ãã aptã«ãããã§ãã¯ã§ãsqlãã³ãã¬ã¼ãã¨æ¡ä»¶ãvalueã®å®ç¾©ã« ééããããå ´åãããã«åãããããã¨ã£ã¦ãéè¦ã S2Dao使ã£ã¦ããå®è¡ããªãã¨åãããªãäºãããåããã æ¡ä»¶ã®ããããã£ã®å®ç¾©å¿ã
S2Unitã¯DBã使ã£ãã¦ããããã¹ãã®æ¯æ´æ©è½ã¨ãã¦Excelãã¡ã¤ã«ããDBã«ãã¹ãç¨ãã¼ã¿ãæå ¥ããããExcelãã¡ã¤ã«ã¨DBã®å å®¹ãæ¯è¼ããããããã¨ãã§ãã¾ãããã ãå®éã«ãã£ã¦ã¿ãã¨ãããã®ã§ãããã®Excelãã¡ã¤ã«ã®ã¡ã³ããã³ã¹ã³ã¹ãã馬鹿ã«ãªãã¾ããã ããã§ãå®éã«DBã«ã¢ã¯ã»ã¹ããã®ã§ã¯ãªãããã¬ã¼ã ã¯ã¼ã¯ãJDBCãã©ã¤ãã®ã¬ã¤ã¤ã§çºè¡ãããSQLãæ¨ªåãããæå¾ éãã®SQLãçºè¡ãããã®ãã©ããã確èªããã¨ããæ¹æ³ã¯ã©ãã ããï¼ã¨èãã¾ãããããããã©ã¤ãã©ãªãèªä½ããããã¨ãæã£ãã®ã§ããï¼å®ééä¸ã¾ã§ä½ã£ã¦ããã®ã§ããï¼ãä¸ã®ä¸åããã¨ãèãã人ã¯ãããã®ã§ãMockRunnerã®JDBC Mockã¨ããæ©è½ã使ãã¨ãã®ãã®ãºããªãªãã¨ãã§ããããã§ãã http://mockrunner.sourceforge.net/examplesjdbc.html
å®¶ã®ãªããæ£®ã«ããããã¨ããæ¬²æ ä»å¹´ã¯ãªãã ãè¦³èæ¤ç©ã®è¦³å¯ã楽ãããæ¬æ¥ã¯æ¤ç©ã«ã¤ãã¦ã®è¨äºã§ãããåãæ ¹ã£ããªã©ã®ç»åãããã®ã§è¦æãªæ¹ã¯é¿ãã¦ãã ãããã ãã£ã«ã¹ã»ã¦ã³ãã©ã¼ã¿ ãã¡ã®ã¡ã¤ã³çåå¨ã¯ãã£ã«ã¹ã»ã¦ã³ãã©ã¼ã¿ãã¦ã³ã殿ãæãå®¶ã«ãã£ã¦ããã®ã¯2020å¹´5æãã³ããç¦åâ¦
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}