struts2读数据库

来源：互联网发布：ai软件作品编辑：程序博客网时间：2024/04/27 20:48

CREATE TABLE `struts_tutorial`.`login` (   `user` VARCHAR( 10 ) NOT NULL ,   `password` VARCHAR( 10 ) NOT NULL ,   `name` VARCHAR( 20 ) NOT NULL ,   PRIMARY KEY ( `user` )) ENGINE = InnoDB;INSERT INTO `struts_tutorial`.`login` (`user`, `password`, `name`) VALUES ('scott', 'navy', 'Scott Burgemott');

package com.tutorialspoint.struts2;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import com.opensymphony.xwork2.ActionSupport;public class LoginAction extends ActionSupport {private String user;private String password;private String name;public String execute() {String ret = ERROR;Connection conn = null;try {String URL = "jdbc:mysql://localhost/struts_tutorial";Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection(URL, "root", "HuaDi5");String sql = "SELECT name FROM login WHERE";sql += " user = ? AND password = ?";PreparedStatement ps = conn.prepareStatement(sql);ps.setString(1, user);ps.setString(2, password);ResultSet rs = ps.executeQuery();while (rs.next()) {name = rs.getString(1);ret = SUCCESS;}} catch (Exception e) {ret = ERROR;} finally {if (conn != null) {try {conn.close();} catch (Exception e) {}}}return ret;}public String getUser() {return user;}public void setUser(String user) {this.user = user;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getName() {return name;}public void setName(String name) {this.name = name;}}

index.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"pageEncoding="ISO-8859-1"%><%@ taglib prefix="s" uri="/struts-tags"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><title>Login</title></head><body><form action="loginaction" method="post">User:<br /><input type="text" name="user" /><br /> Password:<br /><input type="password" name="password" /><br /> <input type="submit"value="Login" /></form></body></html>

success.jsp

<%@ page contentType="text/html; charset=UTF-8"%><%@ taglib prefix="s" uri="/struts-tags"%><html><head><title>Successful Login</title></head><body>Hello World,<s:property value="name" /></body></html>

error.jsp

<%@ page contentType="text/html; charset=UTF-8"%><%@ taglib prefix="s" uri="/struts-tags"%><html><head><title>Invalid User Name or Password</title></head><body>Wrong user name or password provided.</body></html>

struts.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN""http://struts.apache.org/dtds/struts-2.0.dtd"><struts><constant name="struts.devMode" value="true" /><package name="helloworld" extends="struts-default"><action name="loginaction" class="com.tutorialspoint.struts2.LoginAction"method="execute"><result name="success">/success.jsp</result><result name="error">/error.jsp</result></action></package></struts>

原文：http://www.tutorialspoint.com/struts_2/struts_database_access.htm

源代码：http://pan.baidu.com/share/link?shareid=451814&uk=3878681452