java查询数据库返回表,从index页面传 id到数据库，数据库查询表，把查询结果返回result...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

求大神帮忙看看，新手，不是很明白，代码：

index.jsp

请输入要查询的id:

------------------------------------------------------------

user.java

package domain;

import com.opensymphony.xwork2.ActionSupport;

public class User extends ActionSupport {

private String id;

private String name;

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String toString() {

return "id = "+ id +", name = "+ name;

}

}

------------------------------------------------------------

configuration.xml

-------------------------------------------------------------

user.xml

select * from user where id = #{id}

--------------------------------------------------------------------

struts.xml

id

/result.jsp

------------------------------------------------------------------------

SqlOperation.java

package domain;

import domain.User;

import java.io.IOException;

import java.io.Reader;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.opensymphony.xwork2.ActionSupport;

public class SqlOperation extends ActionSupport {

public String execute() throws IOException {

String resource = "domain/configuration.xml";

Reader reader = Resources.getResourceAsReader(resource);

SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);

SqlSession session = ssf.openSession();

try {

User user = new User();

user = (User)session.selectOne("selectAsId", user.getId());

}

catch(Exception e) {

e.printStackTrace();

}

finally {

session.close();

}

return SUCCESS;

}

}

----------------------------------------------------------------

result.jsp

查询结果：

------------------------------------------------------------------

以上是代码，由于刚学了struts和mybatis，不太会用，求大神把代码修改完整准确，谢谢！