基于注解方式的spring_mvc_jdbcTemplate

package net.spring.test; import java.sql.*; import net.spring.util.Log; import net.spring.util.MD5Helper; public class Login { private final static String DB_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver"; // "com.microsoft.jdbc.sqlserver.SQLServerDriver";// private final static String DB_CONNECTION = "jdbc:odbc:YoungTone"; private final static String DB_USER = "sa"; private final static String DB_PASSWORD = "yte123"; private final static String LOG_TAG = "Login"; String loginName; // 登录名 String userName; // 用户名 String passWord; // 密码 String ip; // ip地址 String relatedRules; // 帐号类型 String accountStatus; // 帐号状态 String loginCount; // 登录次数 String lastLoginTime; // 上次登录时间 String lastLoginIP; // 上次登录的ip boolean status = false; // 状态 String info = ""; // 信息 Connection conn; Statement sql; ResultSet rs; CallableStatement proc = null;// 执行sql存储过程的接口 public String getLoginName() { return loginName; } public void setLoginName(String loginName) { this.loginName = loginName; } 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 String getIp() { return ip; } public void setIp(String ip) { this.ip = ip; } public boolean isStatus() { return status; } public void setStatus(boolean status) { this.status = status; } public String getInfo() { return info; } public void setInfo(String info) { this.info = info; } public String getRelatedRules() { return relatedRules; } public void setRelatedRules(String relatedRules) { this.relatedRules = relatedRules; } public String getLoginCount() { return loginCount; } public void setLoginCount(String loginCount) { this.loginCount = loginCount; } public String getLastLoginTime() { return lastLoginTime; } public void setLastLoginTime(String lastLoginTime) { this.lastLoginTime = lastLoginTime; } public String getLastLoginIP() { return lastLoginIP; } public void setLastLoginIP(String lastLoginIP) { this.lastLoginIP = lastLoginIP; } public String getAccountStatus() { return accountStatus; } public void setAccountStatus(String accountStatus) { this.accountStatus = accountStatus; } public Login() { try { Class.forName(DB_DRIVER); } catch (ClassNotFoundException e) { Log.w(LOG_TAG, "没有找到对应的类" + e.toString()); } } public String getMessage() throws Exception { try { conn = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD); proc = conn.prepareCall("{? = call [up_Account_Login] (?,?,?)}"); proc.registerOutParameter(1, Types.INTEGER); proc.setString(2, getLoginName()); proc.setString(3, MD5Helper.gen(getPassWord())); proc.setString(4, getIp()); rs = proc.executeQuery();// 取得结果集 if (rs.next()) { setUserName(rs.getString("AccountName")); setRelatedRules( rs.getString("RelatedRules")); // 帐号类型 setAccountStatus(rs.getString("AccountStatus")); setLoginCount( rs.getString("LoginCount") ); // 登录次数 setLastLoginTime( rs.getString("LastLoginTime") ); // 上次登录时间 setLastLoginIP( rs.getString("LastLoginIP") ); // 上次登录的ip status = true; } Log.w(LOG_TAG, "数据库连接成功"); Log.w(LOG_TAG, getUserName()); Log.w(LOG_TAG, getRelatedRules()); Log.w(LOG_TAG, getAccountStatus()); Log.w(LOG_TAG, getLoginCount()); Log.w(LOG_TAG, getLastLoginTime()); Log.w(LOG_TAG, getLastLoginIP()); } catch (Exception e) { Log.w(LOG_TAG, "数据库连接失败" + e.toString()); } finally { if (rs != null) rs.close(); if (proc != null) proc.close(); if (conn != null) conn.close(); } return ""; } public static void main(String[] args) { try { Login login = new Login(); login.setLoginName("yttest"); login.setPassWord("yt"); login.setIp("192.168.1.1"); login.getMessage(); } catch (Exception e) { Log.w(LOG_TAG, "登录失败"); } // Log.w(LOG_TAG, "yt的密码是" + tool.MD5Helper.gen("yt")); } }