\r\nwget https:\/\/dev.mysql.com\/get\/Downloads\/Connector-J\/mysql-connector-java-8.0.13.tar.gz\r\ntar -xzvf mysql-connector-java-8.0.13.tar.gz\r\ncd mysql-connector-java-8.0.13\r\ncp -R cp -R mysql-connector-java-8.0.13.jar \/opt\/tomcat\/lib\/ #\u5c06\u9a71\u52a8\u590d\u5236\u5230tomcat\u7684lib\u6587\u4ef6\u5939\u5185\uff0c\u6539\u8def\u5f84\u53ef\u80fd\u56e0\u5b89\u88c5\u914d\u7f6e\u4e0d\u540c\u800c\u6709\u6240\u5dee\u5f02\r\nsudo systemctl restart tomcat<\/textarea><\/pre>\n<\/div>\n<h1>\u914d\u7f6e\u6d4b\u8bd5\u7528jsp\u6587\u4ef6<\/h1>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\ncd \/opt\/tomcat\/webapps\/\r\nmkdir test\r\ncd test\/\r\nvi test.jsp<\/textarea><\/pre>\n<\/div>\n<p>\u4ee5\u4e0b\u662ftest.jsp \u7684\u4ee3\u7801\u90e8\u5206<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\n<%@ page language=\"java\" import=\"java.util.*\" pageEncoding=\"UTF-8\"%>\r\n<%@ page import=\"java.naming.*\" %>\r\n<%@ page import=\"java.sql.*\" %>\r\n<html>\r\n<head>\r\n\t<title>Tomcat2MySQL<\/title>\r\n<\/head>\r\n\u3000\u3000<body>\r\n\t<h1>\r\n\t\t<%\r\n\t\t\ttry \r\n\t\t\t{\r\n\t\t\t\t\/\/\u52a0\u8f7d\u9a71\u52a8\r\n\t\t\t\tClass.forName(\"com.mysql.jdbc.Driver\");\r\n\t\t\t\t\/\/\u5efa\u7acb\u8fde\u63a5,root\u4e3amysql\u7528\u6237\u540d passw0rd \u4e3aroot\u7684\u5bc6\u7801\r\n\t\t\t\tConnection con=DriverManager.getConnection(\"jdbc:mysql:\/\/localhost:3306\/tomcat2mysql\",\"root\",\"passw0rd\");\r\n\t\t\t\t\/\/\u521b\u5efa\u72b6\u6001\r\n\t\t\t\tStatement state=con.createStatement();\r\n\t\t\t\t\/\/\u63d2\u5165\u6570\u636e\r\n\t\t\t\tString sql1=\"insert into user(id,name) values('01','test')\";\r\n\t\t\t\tstate.executeUpdate(sql1);\r\n\t\t\t\tString sql2=\"select * from user\";\r\n\t\t\t\tResultSet rs=state.executeQuery(sql2);\r\n\t\t\t\twhile(rs.next())\r\n\t\t\t\t{\r\n\t\t\t\t\tString id=rs.getString(\"id\");\r\n\t\t\t\t\tString name=rs.getString(\"name\");\r\n\t\t\t\t\tout.println(\"id:\"+id+\" \"+\"name:\"+name+\"<br>\");\r\n\t\t\t\t}\r\n\t\t\t\tout.println(\"success...\"+\"<br>\");\r\n\t\t\t\tstate.close();\r\n\t\t\t\tcon.close();\r\n\t\t\t} \r\n\t\t\tcatch (Exception e) \r\n\t\t\t{\r\n\t\t\t\te.printStackTrace();\r\n\t\t\t}\r\n\t\t%>\r\n\t<\/h1>\r\n\t<\/body>\r\n<\/html>\r\n<\/html><\/textarea><\/pre>\n<\/div>\n<p>\u4fee\u6539\u62e5\u6709\u6743<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\ncd \/opt\/tomcat\/\r\nsudo chown -R tomcat webapps\/test\/\r\nsudo systemctl restart tomcat<\/textarea><\/pre>\n<\/div>\n<h1>\u521b\u5efa\u6570\u636e\u5e93<\/h1>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\n[root@localhost ~]# mysql -u root -p\r\nEnter password:\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 12\r\nServer version: 5.5.62 MySQL Community Server (GPL)\r\n\r\nCopyright (c) 2000, 2018, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n3 rows in set (0.00 sec)\r\n\r\nmysql> create database tomcat2mysql;\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| tomcat2mysql       |\r\n+--------------------+\r\n4 rows in set (0.00 sec)\r\n\r\nmysql> use tomcat2mysql;\r\nDatabase changed\r\nmysql> CREATE TABLE user (id VARCHAR(20),name VARCHAR(20));\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> exit ;\r\nBye<\/textarea><\/pre>\n<\/div>\n<h1>\u6d4b\u8bd5<\/h1>\n<p>\u6d4f\u89c8\u5668\u8bbf\u95ee\u6d4b\u8bd5<br \/>\nhttp:\/\/10.10.10.111:8080\/test\/test.jsp<\/p>\n<p><img loading=\"lazy\" class=\"alignnone  wp-image-406\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/tomcat2mysql03-300x134.png\" alt=\"\" width=\"569\" height=\"254\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/tomcat2mysql03-300x134.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/tomcat2mysql03.png 596w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/p>\n<p>\u6570\u636e\u5e93\u4fe1\u606f\u786e\u8ba4<\/p>\n<p><img loading=\"lazy\" class=\"alignnone  wp-image-407\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/tomcat2mysql04-300x113.png\" alt=\"\" width=\"584\" height=\"220\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/tomcat2mysql04-300x113.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/tomcat2mysql04.png 734w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e8b\u9879\u58f0\u660e \u5f53\u524d\u5df2\u7ecf\u5b89\u88c5\u5b8c\u6210Tomcat\uff08\u5b89\u88c5\u8def\u5f84\/opt\/tomcat\uff09\u3001MySQL5.5,\u7cfb\u7edf\u73af\u5883\u4e3aCentOS7-x86_64 …<\/p>\n","protected":false},"author":1,"featured_media":76,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[18,46],"_links":{"self":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/397"}],"collection":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=397"}],"version-history":[{"count":0,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/397\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/media\/76"}],"wp:attachment":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}