java-spring with mssql

Step 1 books.sql

CREATE TABLE 'BOOKS' (
'bookID' int(11) NOT NULL auto_increment,
'bookName' varchar(255),
price double,
PRIMARY KEY ('bookID')
)

Step 2 BooksDAOImpl.java
package com.samqing.dao;
import java.sql.*;
imprt.java.util.*;
import.com.sanqing.util.DBConnection;
public class BooksDAOImpl implements BooksDAO{
public List selectBooksByName(String bookName){
List booksList=new ArrayList();
Connection conn DBConnection.getConnection();
String sql="select * from books where bookName like ?";
PreparedStatement pstmt=null;
ResultSet rs=null;
try {
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,"%"+bookName+"%");
rs.pstmt.executeQuery();
while.next()) {
String name=rs.getString("bookName");
booksList.add(name);}
}
} catch (SQLException e) {e.printStackTrace();
}finally {
DBConnection.close(rs);
DBConnection.close(pstmt);
DBConnection.close(conn);
}
return booksList;
}
}

Step 3 BooksServiceImpl.java
package com.sanqing.service;
import.java.util.List;
import com.sanqing.dao.BooksDAO;
public class BooksServiceImpl implements BooksService{
private BooksDAO booksDAO;
}
public List findBooks(String bookName){
return booksDAO.selectBooksByName(bookName);
}
}

Step 4 applicationContext.xml
<bean id="booksDAOImpl" class="com.sanqling.dao.BooksDAOImpl">
</bean>
<bean id="booksServiceImpl" class="com.sanqing.service.BooksServiceImpl">
<property name="booksDAO">
<ref bean="bookDAOImpl"/>
</property>
</bean>

Step 5 BooksClient.java

package com.sanqing.client;
import.java.util.List;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.sanqing.service.BopoksServiceImpl;
public classBooksClient{
public static void main(String[] args){
BeanFactory factory=new ClassPathXmlApplicationContext("bookServiceImpl");
String bookName="Java";
List booksList=booksServiceImpl.findBooks(bookName); //
for(int i=0;i<booksList.size();i++){
String name=(STring)booksList.get(i);
System.out.println(name+":");
}

}