学步园

下载个oracle JDBC驱动class12.jar，百度去吧，拷贝到tomcat/lib目录下。

oracle：

创建一个用户db，然后创建一个表userlist(username,password)

myeclipse:

1、设置数据源。编辑struts-config.xml,添加如下内容：

<data-sources><br /> <data-source type="oracle.jdbc.pool.OracleDataSource"><br /> <set-property property="autoCommit" value="true"></set-property><br /> <set-property property="description" value="oracle datasource"></set-property><br /> <set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver"></set-property><br /> <set-property property="URL" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"></set-property><br /> <set-property property="readOnly" value="false" /><br /> <set-property property="loginTimeout" value="" /><br /> <set-property property="user" value="kylin" /><br /> <set-property property="password" value="a1b2c3d4e5" /><br /> </data-source><br /> </data-sources> 

2、链接数据库。编辑LoginAction.java，将 ActionForward方法改写为：

public ActionForward execute(ActionMapping mapping, ActionForm form,<br /> HttpServletRequest request, HttpServletResponse response) {<br /> //将ActionForm强制转换为LoginForm<br /> LoginForm loginForm = (LoginForm)form;<br /> String username = loginForm.getUsername();<br /> String password = loginForm.getPassword();<br /> DataSource dataSource = null;<br /> Connection conn = null;<br /> dataSource = getDataSource(request);<br /> boolean flag = false;<br /> String sql = "select * from userlist where username='" + username+ "' and password='" + password + "'";<br /> try {<br /> conn = dataSource.getConnection();<br /> Statement stmt=conn.createStatement();<br /> ResultSet rs = stmt.executeQuery(sql);<br /> while (rs.next()) {<br /> flag = true;<br /> }<br /> }catch (Exception e) {<br /> e.printStackTrace();<br /> }<br /> String actionpath = "";<br /> if (flag) {<br /> request.setAttribute("username", username);<br /> actionpath = "success";<br /> } else {<br /> actionpath = "error";<br /> }<br /> return mapping.findForward(actionpath);<br /> } 

OK！