各種讀取的方法

        //將傳入的textFile檔案轉成字串
public String fileToString(String textFile, String charEncoding) throws Exception {
String msg = "";
try (
InputStream fis = context.getResourceAsStream(textFile);
InputStreamReader isr = new InputStreamReader(fis, charEncoding);
CharArrayWriter caw = new CharArrayWriter();
) {
char[] c = new char[8192];
int len = 0;
while ((len = isr.read(c)) != -1) {
caw.write(c, 0, len);
}
msg = caw.toString();
}
return msg;
}

Spring串聯Hibernate

原先以Hibernate建立好Java專案，

因為有導入Spring的需求，所以要改成Spring框架，怎麼做呢？

SQL server如何在有pk或fk的情況下重設識別種子

一般來說，

工程師建立資料表後會先嘗試新增資料看看。

日漸熟悉SQL之後，一定會頻繁使用到Primary Key及Foreign Key。

測試完資料後想要重設附加識別種子的欄位初始值時，

即使Drop and Create或是Drop都沒辦法成功。

此時可以使用下列語法重設欄位初始值：

Hibernate Web JNDI+DataSource+Listener+Filter

1、更改Servers內的context.xml

 <Resource
  name="jdbc/Jason" type="javax.sql.DataSource"
  auth="Container" username="sa" password="passw0rd"
  driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
  url="jdbc:sqlserver://localhost:1433;databaseName=Jason">
 </Resource>

2、修改hibernate.cfg.xml

    <session-factory>
    <!--  
        <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
        <property name="hibernate.connection.password">passw0rd</property>
        <property name="hibernate.connection.url">jdbc:sqlserver://localhost:1433;databaseName=Jason</property>
        <property name="hibernate.connection.username">sa</property>
        <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
    -->
        <property name="hibernate.connection.datasource">java:comp/env/jdbc/Jason</property>
        <property name="hibernate.current_session_context_class">thread</property>
        
        <property name="hibernate.show_sql">true</property>
                
    </session-factory>

3、撰寫ServletContextListener.java

 package util;

 import javax.servlet.ServletContextEvent;
 import javax.servlet.ServletContextListener;

 public class SessionFactoryListener implements ServletContextListener {
  @Override
  public void contextInitialized(ServletContextEvent sce) {
   HibernateUtil.getSessionFactory();
   System.out.println("Session Factory Created");
  }
 
  @Override
  public void contextDestroyed(ServletContextEvent sce) {
   HibernateUtil.closeSessionFactory();
   System.out.println("Session Factory Destroyed");
  }
 }

4、撰寫OpenSessionViewFilter.java

package util;

 import java.io.IOException;

 import javax.servlet.Filter;
 import javax.servlet.FilterChain;
 import javax.servlet.ServletException;
 import javax.servlet.ServletRequest;
 import javax.servlet.ServletResponse;

 import org.hibernate.SessionFactory;

 public class OpenSessionViewFilter implements Filter {

  @Override
  public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
    throws IOException, ServletException {
  
   SessionFactory sessionfactory = HibernateUtil.getSessionFactory();
  
   try {
    sessionfactory.getCurrentSession().beginTransaction();
    System.out.println("Transaction Begin");
   
    chain.doFilter(request, response);
   
    sessionfactory.getCurrentSession().getTransaction().commit();
    System.out.println("Transaction Commit");
   }catch(Exception e) {
    sessionfactory.getCurrentSession().getTransaction().rollback();
    System.out.println("Transaction Rollback");
    chain.doFilter(request, response);
   }finally {
    sessionfactory.getCurrentSession().close();
    System.out.println("Session Closed");
   }

  }

 }

5、WEB-INF/web.xml內註冊ServletContextListener

 <resource-ref>
  <description>HibernateSQLServerJDBCConnection</description>
  <res-ref-name>jdbc/Jason</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>

 <listener>
  <listener-class>util.SessionFactoryListener</listener-class>
 </listener>

 <filter>
  <filter-name>OpenSessionViewFilter</filter-name>
  <filter-class>util.OpenSessionViewFilter</filter-class>
 </filter>
 <filter-mapping>
  <filter-name>OpenSessionViewFilter</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>