ApacheDerbySample - mamatumo @Wiki

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"   
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0  
http://maven.apache.org/maven-v4_0_0.xsd">
 <modelVersion>4.0.0</modelVersion>
 <groupId>mamatumo</groupId>
 <artifactId>S2DaoDemo</artifactId>
 <packaging>jar</packaging>
 <version>1.0-SNAPSHOT</version>
 <name>Maven Quick Start Archetype</name>
 <url>http://maven.apache.org</url>
 <dependencies>
   <dependency>
     <groupId>junit</groupId>
     <artifactId>junit</artifactId>
     <version>3.8.1</version>
     <scope>test</scope>
   </dependency>
   <dependency>
     <groupId>org.apache.derby</groupId>
     <artifactId>derby</artifactId>
     <version>10.1.3.1</version>
   </dependency>
 </dependencies>
</project>

ｿｰｽ

package derbyDemo;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Utils {

	private Utils() {
	}

	public static Connection getCon() {
		try {
			Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
			Connection result = DriverManager
					.getConnection("jdbc:derby:derbyDB;create=true");
			result.setAutoCommit(false);
			return result;
		} catch (ClassNotFoundException e) {
			throw new RuntimeException(e);
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}

	}

	public static void main(String[] args) {
		Connection con = null;
		try {
			con = getCon();
			
//			PreparedStatement pstmt = con.prepareStatement("create table hoge (a char(10))");
//			pstmt.executeUpdate();
//			
//			PreparedStatement ins = con.prepareStatement("insert into hoge values('2')");
//			ins.executeUpdate();
			
			PreparedStatement stmt = con.prepareStatement("select * from hoge");
			ResultSet rs = stmt.executeQuery();
			while (rs.next()) {
				String str = rs.getString(1);
				System.out.println(str);
			}
			
			commitConn(con);
		} catch (Exception e) {
			rollbackConn(con);

		} finally {
			closeConn(con);

		}
	}
	
	
	
	
	
	
	

	public static void closeConn(Connection conn) {
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException ignore) {
			}
		}
	}

	public static void commitConn(Connection conn) {
		if (conn != null) {
			try {
				conn.commit();
			} catch (SQLException ignore) {
			}
		}
	}

	public static void rollbackConn(Connection conn) {
		if (conn != null) {
			try {
				conn.rollback();
			} catch (SQLException ignore) {
			}
		}
	}

}