package bistu.demo.web.action;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import bistu.demo.bean.Users;
import bistu.demo.dbcon.ConnectionFactory;
import com.opensymphony.xwork2.Action;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
public class LoginAction extends ActionSupport{
private static final long serialVersionUID = -7654893710211643709L;
private Users user;
private List<Users> users;
private String username;
private String password;
private int loginType;
@SuppressWarnings("unchecked")
public String login() throws SQLException{
Connection conn =ConnectionFactory.getConnection();
PreparedStatement pstmt = conn.prepareStatement("select * from area");
ResultSet rs = pstmt.executeQuery();
List<Map<String,String>> columns = new ArrayList<Map<String,String>>();
ResultSetMetaData meta = rs.getMetaData();
for(int i=1; i<=meta.getColumnCount(); i++){
Map<String,String> columnMap = new HashMap<String,String>();
String columnName = meta.getColumnName(i);
String columnTypeName = meta.getColumnTypeName(i);
columnMap.put("columnName", columnName);
columnMap.put("columnTypeName", columnTypeName);
columns.add(columnMap);
}
System.out.println("类数：" + columns.size());
List<Map<String,Object>> result = new ArrayList<Map<String,Object>>();
while(rs.next()){
Map<String,Object> resultMap = new HashMap<String,Object>();
for(int i=0; i<columns.size(); i++){
String columnName = columns.get(i).get("columnName");
String columnTypeName = columns.get(i).get("columnTypeName");
Object columnValue = null;
if(columnTypeName != null && "DATE".equalsIgnoreCase(columnTypeName)){
columnValue = rs.getTimestamp(columnName);
}else{
columnValue = rs.getString(columnName);
}
resultMap.put(columnName, columnValue);
}
result.add(resultMap);
}
System.out.println("记录数：" + result.size());
for(int i=0; i<result.size(); i++){
Map dataMap = (Map)result.get(i);
for(int m=0; m<columns.size(); m++){
Map colMap = (Map)columns.get(m);
if(m == columns.size() - 1){
System.out.println(dataMap.get(colMap.get("columnName")));
}else{
System.out.print(dataMap.get(colMap.get("columnName")) + "****");
}
}
}
System.out.println(ActionContext.getContext().getLocale().getDisplayLanguage());
return "UsersSuccess";
}
public Users getUser() {
return user;
}
public void setUser(Users user) {
this.user = user;
}
public List<Users> getUsers() {
return users;
}
public void setUsers(List<Users> users) {
this.users = users;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getLoginType() {
return loginType;
}
public void setLoginType(int loginType) {
this.loginType = loginType;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
}
struts2 demo
需积分: 9 179 浏览量
2011-11-14
09:26:43
上传
评论
收藏 4.1MB RAR 举报
Struts2.rar （44个子文件） 
Struts2 src 
language_zh_CN.properties 537B struts.xml 1KB language_en_US.properties 378B struts.properties 103B bistu demo dbcon ConnectionFactory.java 842B bean Users.java 2KB Admin.java 480B web filter RightFilter.java 1KB action LoginAction.java 3KB interceptor LanguageInterceptor.java 779B RightInterceptor.java 976B .classpath 1KB .mymetadata 294B .myeclipse .project 1KB WebRoot META-INF MANIFEST.MF 39B sql create.sql 2KB admin addUser.jsp 5KB showUsers.jsp 1KB result.jsp 416B update.jsp 5KB index.jsp 2KB users success.jsp 486B WEB-INF classes language_zh_CN.properties 537B struts.xml 1KB language_en_US.properties 378B struts.properties 103B bistu demo dbcon ConnectionFactory.class 986B bean Users.class 3KB Admin.class 952B web filter RightFilter.class 2KB action LoginAction.class 5KB interceptor LanguageInterceptor.class 1KB RightInterceptor.class 2KB lib 
xwork-2.0.4.jar 445KB commons-fileupload-1.2.1.jar 56KB struts2-core-2.0.11.1.jar 2.22MB commons-logging-1.0.4.jar 37KB freemarker-2.3.8.jar 784KB jstl.jar 20KB standard.jar 384KB ognl-2.6.11.jar 164KB commons-io-1.3.2.jar 86KB web.xml 1KB
Struts2Demo.doc 469KB资源评论
