最近接触Java web的内容,连接数据库验证用户名和密码应该是最基本的操作。整理下刚刚学到的内容,和大家分享。
一、建立数据库对应的表格
在sql server中建立了叫usertable的表格,表格中有username、password两项。随意输入数据,username=11,password=11
二、Java建立与数据库的连接
这里用的是sql server,需要使用专门的jar做驱动,因此下载了个sqljdbc4.jar,放到WEB-INF\lib目录中。然后建立conn类,与数据库进行连接(conn.java)
Connection conn = (Connection) DriverManager.getConnection(inserturl, user, password);
只要执行这条命令就能连接上数据库,还是蛮简单的
package com.jkxy.conn;
import java.sql.Connection;
import java.sql.DriverManager;
import util.PropertiesUtils;
public class conn {
public Connection getCon()
{
String searchurl = null;
String inserturl = "jdbc:sqlserver://localhost:1433;databaseName=jkstudent";
String user = "sa";
String password = "123Pp";
String settime = null;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = (Connection) DriverManager.getConnection(inserturl, user, password);
System.out.println(conn.getMetaData().getURL()); //测试程序,连接成功会显示log
return conn;
}
catch(Exception e){
e.printStackTrace();
return null;
}
}
}
1、index.jsp页面可以输入username和password的值,然后提交validate表单,最后通过数据库验证该用户是否在数据库中
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>欢迎来到即可!!</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<span style="white-space:pre"> </span><h1>欢迎pinpin!!</h1>
<span style="white-space:pre"> </span><form action="validate.jsp" name="login">
<span style="white-space:pre"> </span>username <input type="text" name="username"><br/>
<span style="white-space:pre"> </span>password <input type="password" name="password"><br/>
<span style="white-space:pre"> </span><input type="submit">
<span style="white-space:pre"> </span></form>
</body>
</html>
2、validate.jsp表单内容
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="user" class="com.jkxy.model.userTable"></jsp:useBean>
<jsp:useBean id="userservice" class="com.jkxy.service.userservice"></jsp:useBean>
<jsp:setProperty property="*" name="user"/>
<%
out.print(user.getUsername());
out.print(user.getPassword());
if(userservice.valiUser(user)) //如果输入的用户在数据库中,则显示“成功”
out.print("success");
else
out.print("error");
%>
</body>
</html>
说明:
<jsp:useBean id="user" class="com.jkxy.model.userTable"></jsp:useBean>
这句表示从userTable类(后面会给出)中找到user对象,在index页面可以对它进行操作
<jsp:useBean id="userservice" class="com.jkxy.service.userservice"></jsp:useBean>
这句表示从userservice类(后面会给出)中找到uservice对象,即连接数据库后,通过sql语句
<jsp:setProperty property="*" name="user"/>
property的属性可以设置成“*",表示是将表单中与同名称的属性值赋给Javabean对象中的同名属性,此处是赋给user
3、其他Java类
userTable.java
package com.jkxy.model;
public class userTable {
private String username = null;
private String password = null;
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;
}
}
package com.jkxy.service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.jkxy.model.userTable;
public class userservice {
private Connection conn = null;
private PreparedStatement pstmt = null;
public userservice(){
conn = new com.jkxy.conn.conn().getCon();
}
public boolean valiUser(userTable user){
try {
pstmt = conn.prepareStatement("select * from usertable where usrname=? and password=?");
pstmt.setString(1, user.getUsername());
pstmt.setString(2, user.getPassword());
ResultSet re = pstmt.executeQuery();
if(re.next())
return true;
else
return false;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}
}
总结:
这个验证demo中,JSP集成了部分Java的函数,特别是通过“jsp:useBean”方式使用javabean封装,让JSP直接使用Java的类,这种用法应该在Java web开发中很常见!!
点此下载源代码