最近刚学习Java Web于是自己动手做了一个简单的登录界面,在这里没有选择JDBC链接数据库,而是采用的ODBC,具体代码如下:
登录界面:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<html>
<body>
<form action="Login/login.action" method="post">
<center>
学号:<input type="text" name="account" style="width:150px"><br>
密码:<input type="password" name="password" style="width:150px"><br>
<input type="submit" value="登录"style="width:198px"><br>
<input type="reset" value="取消" style="width:198px">
</center>
</form>
</body>
</html>
LoginAction.java代码:
package login;
public class LoginAction {
private String account;
private String password;
public String getAccount(){
return account;
}
public void setAccount(String account){
this.account=account;
}
public String getPassword(){
return password;
}
public void setPassword(String password){
this.password=password;
}
public String execute()throws Exception{
boolean result;
Query_db query_db=new Query_db();
result=query_db.queryResult(account,password);
if(result){
return "success";
}else{
return "fail";
}
}
}
查询数据库代码:Query_db.java
package login;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Query_db {
public boolean queryResult(String account,String password) throws Exception{
Connection conn=null;
boolean result;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:DSLxh";
conn=DriverManager.getConnection(url);
Statement stat=conn.createStatement();
String sql="select stuno,stuPassword from student where stuno='"+account+"' and stuPassword='"+password+"'";
System.out.println(sql);
ResultSet rs=stat.executeQuery(sql);
if(rs.next()){
result=true;
}else{
result=false;
}
rs.close();
stat.close();
return result;
}
}
登录成功的跳转页面代码:loginSuccess.jsp
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<html>
<body>
登陆成功<br>
</body>
</html>
登录失败的跳转页面代码:loginFail.jsp
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<html>
<body>
登陆失败<br>
</body>
</html>
struts.xml配置文件代码:
<?xml version="1.0" encoding="UTF-8" ?>
<struts>
<package name="struts2" extends="struts-default">
<action name="login" class="login.LoginAction">
<result name="success">/loginSuccess.jsp</result>
<result name="fail">/loginFail.jsp</result>
</action>
</package>
</struts>
web.xml代码:
<?xml version="1.0" encoding="UTF-8"?>
<display-name>Login</display-name>
<filter>
<filter-name>struts2</filter-name>
<filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
工程结构: