运行效果:
点击提交
项目目录如下:
数据库表:
Index.jsp 代码:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServ erPort()+path+"/"; %>
登陆 <% if(request.getAttribute("msg")!=null){ %>
<%=request.getAttribute("msg") %><%} %>
Userbean.java 代码 package bean; public class UserBean { private int id; private String username; private String userpass; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsername() {
return username; } public void setUsername(String username) { this.username = username; } public String getUserpass() { return userpass; } public void setUserpass(String userpass) { this.userpass = userpass; } }
Dbutil.java 代码
package dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.
sql.Statement; import bean.UserBean; public class jdbcutil { private String url = "jdbc:sqlserver://localhost:1433;databaseName=test"; private String dbUserName = "sa"; private String dbUserPassword = "sa"; private Connection conn = null; private Statement stmt = null; private ResultSet rs = null; public void newJdbc() { try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public Connection getConnection() { try { conn = DriverManager.getConnection(url, dbUserName, dbUserPassword); } catch (SQLException e) { e.printStackTrace(); } return conn; } public void close(ResultSet rs, Statement stmt, Connection conn) { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } cat
ch (SQLException e) { e.printStackTrace(); } } } public boolean checkLogin(UserBean user) { System.out.println(user.getUsername()); System.out.println(user.getUserpass());
String sql="select * from userInfo where username='"+user.getUsername()+"' and userpass='"+user.getUserpass()+"'"; conn = this.getConnection(); try { stmt = conn.createStatement(); rs = stmt.executeQuery(sql); if(rs.next()) { return true; } else { System.out.println("false"); return false; } } catch(Exception e) { e.printStackTrace(); return false; } } }
Slogin.java 代码----sevlert
package sevlet; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpSer