2019年11月16日--学习关于web.xml配置，写一定用户登录demo的一些心得

1.写一个网页项目，首先浏览器加载的是一个html页面，页面上有跳转的“超链接”，什么是这里说的超链接，比如一个表单下的action属性值就是，这个属性值要跟xml文件扯上关系，就要把xml文件的url-pattern配置成action跳转的值。比如

`	<form action="/WEB14/login" method="post">
		用户名：<input type="text" name="username"><br /> 
	    密  码：<input type="password" name="password"><br /> 
    <input type="submit" value="登录"><br />

</form>`

要跳转的xml文件是这样的：

<servlet>
	<servlet-name>abc</servlet-name>
	<servlet-class>com.login.LoginServlet</servlet-class>
</servlet>

<servlet-mapping>
	<servlet-name>abc</servlet-name>
	<url-pattern>/login</url-pattern>
</servlet-mapping>

附加这天写的登录测试代码：

package com.login;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import domain.user;
import utils.DButils;

public class LoginServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String username = request.getParameter("username");
		String password = request.getParameter("password");

		String sql = "select * from [user] where username='" + username + "' and password='" + password + "'";
		// 获得用户名、密码
		try {
			/*
			 * Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//
			 * 驱动 Connection con; String url =
			 * "jdbc:sqlserver://localhost:1433;databaseName=web13"; String user
			 * = "sa"; String password1 = "123456"; con =
			 * DriverManager.getConnection(url, user, password1);
			 */

			Connection con = DButils.getConnection();
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			if (rs.next()) {
				response.getWriter().write("welcome");
			} else {
				response.getWriter().write("!!!sorry!!!");
			}
		} catch (SQLException e1) {
			// TODO 自动生成的 catch 块
			e1.printStackTrace();
		}
		// ------------------------------------------------------------------------------------------------------------------
		// 验证（数据库）
		/*
		 * String sql = "select * from [user] where username=? and password=?";
		 * // 根据返回结果给用户不同的显示信息 QueryRunner runner = new
		 * QueryRunner(DButils.getDatasouce()); user u = null; try { u =
		 * runner.query(sql, new BeanHandler<user>(user.class),
		 * password,username);
		 * 
		 * } catch (SQLException e) { e.printStackTrace(); } if (u != null) {//
		 * success response.getWriter().write(u.toString()); } else {// failure
		 * response.getWriter().write("sorry!!!"); }
		 */
		// ------------------------------------------------------------------------------------------------------------------
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}
}

Dbutils数据库工具类如下，记得导包与c3p0配置文件

package utils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class DButils {
	
	private static DataSource dataSource=new ComboPooledDataSource();
	
	private static ThreadLocal<Connection> tl=new ThreadLocal<Connection>();
	
	public static DataSource getDatasouce(){
		return dataSource;
	}
	
	public static Connection getConnection() throws SQLException {
		Connection con=tl.get();
		if(con==null){
			con=dataSource.getConnection();
			tl.set(con);
		}
		return con;
	}
	//开启事务
	public static void startTransaction() throws SQLException {
		Connection con = getConnection();
		if (con != null) {
			con.setAutoCommit(false);
		}
	}
	
	//事务回滚
	public static void rollback() throws SQLException {
		Connection con = getConnection();
		if (con != null) {
			con.rollback();
		}
	}
	// 提交并且 关闭资源及从ThreadLocall中释放
	public static void commitAndRelease() throws SQLException {
		Connection con = getConnection();
		if (con != null) {
			con.commit(); // 事务提交
			con.close();// 关闭资源
			tl.remove();// 从线程绑定中移除
		}
	}
	// 关闭资源方法
	public static void closeConnection() throws SQLException {
		Connection con = getConnection();
		if (con != null) {
			con.close();
		}
	}

	public static void closeStatement(Statement st) throws SQLException {
		if (st != null) {
			st.close();
		}
	}

	public static void closeResultSet(ResultSet rs) throws SQLException {
		if (rs != null) {
			rs.close();
		}
	}
}