文章目录
MySQL配置环境变量navicat部署tomcat导入驱动修改代码连接mysql数据库运行:MySQL配置环境变量
mysql肯定是必不可少的,这个就不用多说了,自己去官网下载就行我们来配置一下mysql的环境变量
步骤:
我的电脑右键——属性——高级系统——环境变量
在系统变量下点击新建:
变量名:MYSQL_HOME变量值:C:\phpStudy\PHPTutorial\MySQL
这里的变量值填的是自己mysql所在的文件夹,以自己电脑路径为准
然后找到path,点击编辑,然后新建一个
%MYSQL_HOME%\bin
点击确定(共三个)
测试
在windows命令行下输入
mysql -u root -p
按下回车,输入密码即可进入数据库
navicat
我自己电脑用的是phpstudy,感觉更方便一点,集成环境,并且有可视化工具,这里推荐使用navicat(有破解教程)
链接:/s/1ehhsB_mMObOI32ER54OPaA 提取码:5138
部署tomcat
我们点击菜单栏windows>>preference>>在左边栏找到server>>Runtime Environme
点击add,添加tomcat
选择需要的版本,点击next,选择自己安装的tomcat路径
点击finish:
tomcat版本不要太高,不然可能会出现报错;
新建一个web项目
其他选择默认,next>>next>>next>>finish
将tomcat服务器显示在控制台上,以及将web应用部署到tomcat中
1、window>>show view>>servers
2、点击控制台链接:No servers are available. Click ths link to create a new server.
3、在弹出的对话框中选择tomcat版本
4、点击next,添加我们的项目:选中我们的项目,点击add,finish。
我们会在右边菜单栏看到文件夹servers,里边就是tomcat的一些相关文件
右键面板中的tomcat v8.0…点击start,开启服务器即可
导入驱动
导入的驱动一定不能过高,最好和自己电脑mysql版本一致
我电脑上的mysql是5.5.53,用的驱动是5.1.47,可用!
驱动:链接:/s/1F2VZrqvMhO64-U10AFcoCA 提取码:ge4p
下载好解压,直接将jar包拖入lib中,右键build path一下
这样就是导入成功!
修改代码
找到我们创建的inc.jsp,修改下列代码,以自己电脑为准,这个是和代码相匹配的
另外,所有web文件都要放在WEB-INF下
连接mysql数据库
连接名随意,默认端口为3306
在数据库中我们要创建一个数据库库名为demo,表名为users,
添加字段:username、password、email
这就相当于登陆的用户名和密码,可直接在数据库中添加,也可通过注册界面
填写注册信息,同样会显示在数据库中
运行:
(1)login.jsp<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><base href="<%=basePath%>"><title>My JSP 'login.jsp' starting page</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!--<link rel="stylesheet" type="text/css" href="styles.css">--></head><body><form name="form1" action="login_action.jsp" method="post"><table width="200" border="1"><tr><td colspan="2">登录窗口</td><tr><td>用户名</td><td><input type="text" name="username" size="10"></td></tr><tr><td>密码</td><td><input type="password" name="password" size="10"></td></tr><tr><td colspan="2"><input type="submit" name="submit" value="登录"> <ahref="register.jsp">注册新用户</a></td></tr></table></form></body></html>(2)login_action.jsp<%@ page pageEncoding="utf-8" %><%@ include file="inc.jsp"%><%//get parametersString username = request.getParameter("username");String password = request.getParameter("password");//check nullif (username == null || password == null) {response.sendRedirect("login.jsp");}//validateboolean isValid = false;String sql = "select * from users where username='"+username+"' and password='"+password+"'";try {Class.forName(drv).newInstance();Connection conn = DriverManager.getConnection(url, usr, pwd);Statement stm = conn.createStatement();ResultSet rs = stm.executeQuery(sql);if(rs.next())isValid = true;rs.close();stm.close();conn.close();} catch (Exception e) {e.printStackTrace();out.println(e);} finally {}if (isValid) {session.setAttribute("username", username);response.sendRedirect("welcome.jsp");} else {response.sendRedirect("login.jsp");}%>(3)register.jsp<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><base href="<%=basePath%>"><title>My JSP 'register.jsp' starting page</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!--<link rel="stylesheet" type="text/css" href="styles.css">--></head><body><form name="form1" action="register_action.jsp" method="post"><table width="200" border="1"><tr><td colspan="2">注册窗口</td><tr><td>用户名</td><td><input type="text" name="username" size="10"></td></tr><tr><td>密码</td><td><input type="password" name="password1" size="10"></td></tr><tr><td>确认密码</td><td><input type="password" name="password2" size="10"></td></tr><tr><td>Email</td><td><input type="text" name="email" size="10"></td></tr><tr><td colspan="2"><input type="submit" name="submit" value="注册"> <ahref="login.jsp">返回</a></td></tr></table></form></body></html>(4)register_action.jsp<%@ page pageEncoding="utf-8" %><%@ include file="inc.jsp"%><%//get parametersString username = request.getParameter("username");String password1 = request.getParameter("password1");String password2 = request.getParameter("password2");String email = request.getParameter("email");//check nullif (username == null || password1 == null || password2 == null || !password1.equals(password2)) {response.sendRedirect("register.jsp");}//validateboolean isValid = false;String sql = "select * from users where username='"+username+"'";try {Class.forName(drv).newInstance();Connection conn = DriverManager.getConnection(url, usr, pwd);Statement stm = conn.createStatement();ResultSet rs = stm.executeQuery(sql);if(!rs.next()) {sql = "insert into users(username,password,email) values('"+username+"','"+password1+"','"+email+"')";stm.execute(sql);isValid = true;}rs.close();stm.close();conn.close();} catch (Exception e) {e.printStackTrace();out.println(e);}if (isValid) {response.sendRedirect("login.jsp");} else {response.sendRedirect("register.jsp");}%>(5)welcome.jsp<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><base href="<%=basePath%>"><title>My JSP 'welcome.jsp' starting page</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!--<link rel="stylesheet" type="text/css" href="styles.css">--><style type="text/css">body{background-color: beige;}</style></head><body><table width="100%"><tr><td><img src="images/111.jpgA,LDYVS." height="90"></td></tr><tr><td colspan="2"><hr></td></tr><tr><td><table><tr><td><a href="welcome.jsp">Main</a></td></tr><tr><td><a href="menu1.jsp">Menu1</a></td></tr><tr><td><a href="menu2.jsp">Menu2</a></td></tr><tr><td><a href="menu3.jsp">Menu3</a></td></tr><tr><td><a href="menu4.jsp">Menu4</a></td></tr><tr><td><a href="menu5.jsp">Menu5</a></td></tr><tr><td><a href="menu6.jsp">Menu6</a></td></tr><tr><td><a href="menu7.jsp">Menu7</a></td></tr><tr><td><a href="menu8.jsp">Menu8</a></td></tr></table></td><td><form name="form1" action="logout.jsp" method="post"><table width="200" border="1"><tr><td colspan="2">登录成功</td><tr><td>欢迎你,</td><td><%=(String) session.getAttribute("username")%></td></tr><tr><td colspan="2"><input type="submit" name="submit" value="退出"></td></tr></table></form></td></tr></table></body></html> (6)logout.jsp<%session.removeAttribute("username");response.sendRedirect("login.jsp");%>(7)inc.jsp<%@ page import="java.sql.Connection"%><%@ page import="java.sql.DriverManager"%><%@ page import="java.sql.Statement"%><%@ page import="java.sql.ResultSet"%><%@ page import="java.sql.ResultSetMetaData"%><%String drv = "com.microsoft.sqlserver.jdbc.SQLServerDriver";String url = "jdbc:sqlserver://localhost:1433;DatabaseName=Demo";String usr = "sa";String pwd = "";%>