Servlet注册登录增删改查1.0

Servlet注册登录增删改查2.0

先创建一个DBHelper工具类

package xyz.jrkang.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBHelper {
	private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=school";
	private static String name = "sa";
	private static String pwd = "123";

	public static Connection getConn() {
		 Connection conn = null;
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			conn = DriverManager.getConnection(url, name, pwd);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}

	public static void close(PreparedStatement ps, Connection conn, ResultSet rs) {
		try {
			if (conn != null)
				conn.close();

			if (ps != null)
				ps.close();

			if (rs != null)
				rs.close();
		} catch (SQLException e) {
			System.out.println("资源关闭失败!");
		}
	}
}

创建一个.jsp文件

里面写一些简单的html文件，作为前台展示的页面

<%@ page language="java" import="java.util.*" pageEncoding=