struts-config.xml文件中
调用页面
MemberDao.jsp中
package com.xg.dao;
import com.xg.tool.JDBConnection;
import java.sql.*;
import java.util.*;
import com.xg.domain.MemberForm;
public class MemberDao {
private Connection connection = null;
private PreparedStatement ps = null;
private JDBConnection jdbc = null;
public MemberDao() {
jdbc = new JDBConnection();
connection = jdbc.connection;
}
public MemberForm selectMemberForm(String name) {
MemberForm member = null;
try {
ps = connection.prepareStatement("select * from userinfo where user_name=?");
ps.setString(1, name);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
member = new MemberForm();
member.setUser_id(Integer.valueOf(rs.getString(1)));
member.setUser_name(rs.getString(2));
member.setUser_password(rs.getString(3));
}
}
catch (SQLException ex) {
ex.printStackTrace();
}
return member;
}
}