tomcat6.0 + myeclipse6.5 under tomcat data source configuration

Mar 3 posted in Java (RSS), comments.

Advertisements

(1) Environment: such as a very important question! Different environment, different configurations!

(2) struts package loaded: My MyEclipse6.5 bring him under the load of the struts jar package Error occurred "collections can not find under quickHashMap" abnormal (perhaps meaning, forget the record), then bring him to remove the STRUTS JAR, together with an independent Jar, and will all have to copy added to STRUTS jar works in WEB-INF/lib.

(3) the database connection JAR file COPY separately to the project under WEB-INF/lib and under lib under tomcat.

(4) in the tomcat's conf / under Context.xml changes at one of the <Context> </ Context> add the following code (according to their own situation to be slightly amended):

Wrote

<Resource name = "sdemo" auth = "Container" type = "javax.sql.DataSource"
maxActive = "100" maxIdle = "30" maxWait = "10000"
username = "sa" password = "xxxxxx" driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
url = "jdbc: sqlserver: / / localhost: 1433; databaseName = afdDemo" />

(5) In the works cited in web.xml:

<!-- A reference to the data source -->
	<resource-ref>
       <res-ref-name>sdemo</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
    </resource-ref>

(6) in the projects to use the DBCP had:)

public static Connection getConnection(){
		Connection conn = null;
		try {
			Context initContext = new InitialContext();
			 // Context envContext  = (Context)initContext.lookup("java:/comp/env");      
			  DataSource ds = (DataSource)initContext.lookup("java:/comp/env/sdemo"); 
			
			 conn = ds.getConnection();
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	     return conn;
	}

(7) at dao class can be directly connected to the call:)

public List<User> selectAll(){
		List<User> list = new ArrayList<User>();
		Connection conn = DBUtil.getConnection();
		if(conn == null){
			System.out.println("conn is null!");
		}
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			pstmt = conn.prepareStatement("select * from [User]");
			rs = pstmt.executeQuery();
			User user = new User();
			while(rs.next()){
				user.setUserID(rs.getInt(1));
				user.setUserName(rs.getString(2));
				System.out.println(user.getUserName());
				list.add(user);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(rs != null){
					rs.close();
				}
				if(pstmt != null){
					pstmt.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}