derby的使用

public class DBConnection {
	private final static String driver = "org.apache.derby.jdbc.EmbeddedDriver";
    public static Connection getConnection(){
        String dbName="D:/workdb";
        Connection conn=null;
        try {
            Properties props = new Properties(); 
            Class.forName(driver).newInstance();
            System.out.println("Loaded the appropriate driver");
            conn = DriverManager.getConnection("jdbc:derby:"+dbName+";create=true", props);
            System.out.println("Connected to and created database " + dbName);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return conn;
    }
    
    public static void shutdwon(){
        try {
            DriverManager.getConnection("jdbc:derby:;shutdown=true");
        } catch (SQLException se) {
            if (( (se.getErrorCode() == 50000)
                         && ("XJ015".equals(se.getSQLState()) ))) {
                     System.out.println("Derby shut down normally");
                 } else {
                     System.err.println("Derby did not shut down normally");
                     se.printStackTrace();
                 }
        }
    }
}

public class MyTableDao {
 
 public int save(String Id,String DisName,int IsOpen,String CreateUser, String CreateDate,String UpdateUser,String UpdateDate){
   Connection conn = DBConnection.getConnection();
         int result=0;
         try {
             conn.setAutoCommit(false);
    
             PreparedStatement pstm = conn.prepareStatement("insert into t_tag values (?,?,?,?,?,?,?)");
             pstm.setString(1, Id);
             pstm.setString(2, DisName);
             pstm.setInt(3, IsOpen);
             pstm.setString(4, CreateUser);
             pstm.setString(5,CreateDate);
             pstm.setString(6, UpdateUser);
             pstm.setString(7, UpdateDate);
             result=pstm.executeUpdate();
             System.out.println("execute...");
             conn.commit();
             if(pstm != null){
                 pstm.close(); pstm = null;
             }
             if (conn != null) {
                 conn.close();conn = null;
             }
         } catch (SQLException ex) {
             ex.printStackTrace();
         }
         return result;
     }
  public List<String> query(){
         Connection conn = DBConnection.getConnection();
         List<String> list=null;
         try {
             PreparedStatement pstm = conn.prepareStatement("SELECT Id FROM t_tag");
             ResultSet rs = pstm.executeQuery();
             list = new ArrayList<String>();
             while (rs.next())
             {
                list.add(rs.getString(1));
             }
             if(rs != null){
                 rs.close(); rs = null;
             }
             if(pstm != null){
                 pstm.close(); pstm = null;
             }
             if (conn != null) {
                 conn.close();conn = null;
             }
         } catch (SQLException ex) {
             ex.printStackTrace();
         }
         return list;
     }
  
}

public static void main(String[] args) {
     MyTableDao myTableDao=new MyTableDao();
     myTableDao.save("001", "001", "aa", "aa", 0, null, "2014-02-18 16:58:37", null, "2014-02-18 16:58:37");
     List idList=myTableDao.query();
     DBConnection.shutdwon();
     }