当前位置：Gxlcms > 数据库问题 > JAVA EE 连接MySql数据库

JAVA EE 连接MySql数据库

时间：2021-07-01 10:21:17 帮助过：35人阅读

  我们得先下载Mysql的驱动包：mysql-connector-java-5.1.41-bin.jar

  下载之后 导入：

技术分享

技术分享

完成这个之后我们打开MySql Workbench 开启本地数据库 并创建 USERINFO 库

然后再到index.jsp中写入：

  1. <span style="background-color: #ffff00; color: #000000"><%</span><span style="background-color: #f5f5f5; color: #000000">@ page language</span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">java</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000"> import</span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">java.util.*,java.sql.*</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000"> pageEncoding</span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">ISO-8859-1</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #ffff00; color: #000000">%></span>
  2. <span style="background-color: #ffff00; color: #000000"><%</span>
  3. <span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> path </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> request.getContextPath();
  4. </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> basePath </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> request.getScheme()</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">://</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #000000">request.getServerName()</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">:</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #000000">request.getServerPort()</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #000000">path</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">/</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">;
  5. </span><span style="background-color: #ffff00; color: #000000">%></span>
  6. <span style="color: #0000ff"><!</span><span style="color: #ff00ff">DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"</span><span style="color: #0000ff">></span>
  7. <span style="color: #0000ff"><</span><span style="color: #800000">html</span><span style="color: #0000ff">></span>
  8.   <span style="color: #0000ff"><</span><span style="color: #800000">head</span><span style="color: #0000ff">></span>
  9.     <span style="color: #0000ff"><</span><span style="color: #800000">base </span><span style="color: #ff0000">href</span><span style="color: #0000ff">="<%=basePath%>"</span><span style="color: #0000ff">></span>
  10.     
  11.     <span style="color: #0000ff"><</span><span style="color: #800000">title</span><span style="color: #0000ff">></span>My JSP ‘index.jsp‘ starting page<span style="color: #0000ff"></</span><span style="color: #800000">title</span><span style="color: #0000ff">></span>
  12.     <span style="color: #0000ff"><</span><span style="color: #800000">meta </span><span style="color: #ff0000">http-equiv</span><span style="color: #0000ff">="pragma"</span><span style="color: #ff0000"> content</span><span style="color: #0000ff">="no-cache"</span><span style="color: #0000ff">></span>
  13.     <span style="color: #0000ff"><</span><span style="color: #800000">meta </span><span style="color: #ff0000">http-equiv</span><span style="color: #0000ff">="cache-control"</span><span style="color: #ff0000"> content</span><span style="color: #0000ff">="no-cache"</span><span style="color: #0000ff">></span>
  14.     <span style="color: #0000ff"><</span><span style="color: #800000">meta </span><span style="color: #ff0000">http-equiv</span><span style="color: #0000ff">="expires"</span><span style="color: #ff0000"> content</span><span style="color: #0000ff">="0"</span><span style="color: #0000ff">></span>    
  15.     <span style="color: #0000ff"><</span><span style="color: #800000">meta </span><span style="color: #ff0000">http-equiv</span><span style="color: #0000ff">="keywords"</span><span style="color: #ff0000"> content</span><span style="color: #0000ff">="keyword1,keyword2,keyword3"</span><span style="color: #0000ff">></span>
  16.     <span style="color: #0000ff"><</span><span style="color: #800000">meta </span><span style="color: #ff0000">http-equiv</span><span style="color: #0000ff">="description"</span><span style="color: #ff0000"> content</span><span style="color: #0000ff">="This is my page"</span><span style="color: #0000ff">></span>
  17.     <span style="color: #008000"><!--</span><span style="color: #008000">
  18.     <link rel="stylesheet" type="text/css" href="styles.css">
  19.     </span><span style="color: #008000">--></span>
  20.   <span style="color: #0000ff"></</span><span style="color: #800000">head</span><span style="color: #0000ff">></span>
  21.   
  22.   <span style="color: #0000ff"><</span><span style="color: #800000">body</span><span style="color: #0000ff">></span>
  23.     <span style="background-color: #ffff00; color: #000000"><%</span>
  24.    <span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">声明Connection对象
  25.         Connection con;
  26.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">驱动程序名
  27.         </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> driver </span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">com.mysql.jdbc.Driver</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">;
  28.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">URL指向要访问的数据库名mydata
  29.         </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> url </span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">jdbc:mysql://localhost:3306/USERINFO</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">;
  30.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">MySQL配置时的用户名
  31.         </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> user </span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">root</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">;
  32.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">MySQL配置时的密码
  33.         </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> password </span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">699307</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">;
  34.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">遍历查询结果集
  35.          Connection conn </span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #0000ff">null</span><span style="background-color: #f5f5f5; color: #000000">;
  36.         try {
  37.             </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">加载驱动程序
  38.             Class.forName(driver);
  39.             </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #800080">1</span><span style="background-color: #f5f5f5; color: #000000">.getConnection()方法，连接MySQL数据库！！
  40.             conn </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> DriverManager.getConnection(url,user,password);
  41.             </span><span style="background-color: #f5f5f5; color: #0000ff">if</span><span style="background-color: #f5f5f5; color: #000000">(!conn.isClosed())
  42.                 System.out.println(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">Succeeded connecting to the Database!</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  43.             </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #800080">2</span><span style="background-color: #f5f5f5; color: #000000">.创建statement类对象，用来执行SQL语句！！
  44.             Statement st </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> conn.createStatement();
  45.         
  46.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">执行sql语句
  47.          </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> sql </span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">select * from USERINFO</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">;
  48.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">增删改查表中的内容，用executeUpdate方法
  49.        st.executeUpdate(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">insert into USERINFO(USERID, USERNAME) values (1, ‘NOSTRING‘)</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  50.        st.executeUpdate(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">insert into USERINFO(USERID, USERNAME) values (2, ‘BECHAR‘)</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  51.        st.executeUpdate(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">insert into USERINFO(USERID, USERNAME) values (3, ‘ALEXVIEW‘)</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  52.        
  53.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">读取表的内容，用executeQuery方法
  54.         ResultSet rs </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> st.executeQuery(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">select * from USERINFO</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  55.         </span><span style="background-color: #f5f5f5; color: #000000">//</span><span style="background-color: #f5f5f5; color: #000000">循环输出内容
  56.         </span><span style="background-color: #f5f5f5; color: #0000ff">while</span><span style="background-color: #f5f5f5; color: #000000">(rs.next()){
  57.             </span><span style="background-color: #f5f5f5; color: #0000ff">int</span><span style="background-color: #f5f5f5; color: #000000"> userID </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> rs.getInt(</span><span style="background-color: #f5f5f5; color: #800080">1</span><span style="background-color: #f5f5f5; color: #000000">);
  58.             </span><span style="background-color: #f5f5f5; color: #0000ff">String</span><span style="background-color: #f5f5f5; color: #000000"> username </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> rs.getString(</span><span style="background-color: #f5f5f5; color: #800080">2</span><span style="background-color: #f5f5f5; color: #000000">);
  59.             out.println(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">-------------------<br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  60.             out.println(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">uerid:</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #000000"> userID </span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000"><br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  61.             out.println(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">username:</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #000000"> username </span><span style="background-color: #f5f5f5; color: #000000">+</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000"><br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  62.             out.println(</span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000">-------------------<br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  63.         }
  64.         
  65.     }catch(SQLException e){
  66.         out.print(e.getErrorCode() </span><span style="background-color: #f5f5f5; color: #000000">+</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000"><br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  67.         out.print(e.getCause() </span><span style="background-color: #f5f5f5; color: #000000">+</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000"><br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  68.         out.print(e.getMessage() </span><span style="background-color: #f5f5f5; color: #000000">+</span> <span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #800000"><br></span><span style="background-color: #f5f5f5; color: #800000">"</span><span style="background-color: #f5f5f5; color: #000000">);
  69.         </span><span style="background-color: #f5f5f5; color: #0000ff">if</span><span style="background-color: #f5f5f5; color: #000000">(conn !</span><span style="background-color: #f5f5f5; color: #000000">=</span> <span style="background-color: #f5f5f5; color: #0000ff">null</span><span style="background-color: #f5f5f5; color: #000000"> )
  70.             conn.close();
  71.     }
  72.  </span><span style="background-color: #ffff00; color: #000000">%></span>
  73.   <span style="color: #0000ff"></</span><span style="color: #800000">body</span><span style="color: #0000ff">></span>
  74. <span style="color: #0000ff"></</span><span style="color: #800000">html</span><span style="color: #0000ff">></span>

写入之后日常访问：

技术分享

JAVA EE 连接MySql数据库

标签：jar   sys   写入   creat   round   connector   desc   from   result   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！