首先创建javaweb项目,可以参照以下:
附上项目结构:
1.重写登录页面index.jsp的内容
Created by IntelliJ IDEA.
User: LXJ'PC
Date: 2018/5/12
Time: 15:49
To change this template use File | Settings | File Templates.
--%>
登录用户名:
密码:
2.新建类DBUtil
package org.user.util;
import java.sql.*;
public class DBUtil {
//mysql驱动包名
private static final String DRIVER_NAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//数据库连接地址
private static final String URL = "jdbc:sqlserver://localhost:1433;integratedSecurity=true;DatabaseName=JavaWeb";
//用户名
private static final String USER_NAME = ".";
//密码
private static final String PASSWORD = "";
public static Connection getConnection(){
try {
//加载mysql的驱动类
Class.forName(DRIV