Java web 连接MySQL数据库

来自CloudWiki
跳转至： 导航， 搜索

创建数据表

create database ditigal1;

use ditigal1;

create table user_info(


create table product_info(
id int(4) not null primary key,
name varchar(225) not null,
code varchar(16) not null,
type varchar(16),
num int(4),
price float);

insert into product_info values(01,'gouliang','00001','chongwu',22,120);

导入数据库驱动

详见 Eclipse 导入mysql驱动程序（Java web项目）

连接数据库并在页面显示

Jw1-8.png

index.jsp的代码如下： 

<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML >
<html>
  <head>
    <title>小脚本测试</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="jsp base">
<meta http-equiv="description" content="This is my first jsp page">
  </head>
  <body>
    <div align="center">连接数据库</div>
    <%
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ditigal1","root","000000");
String sql="select * from product_info";
PreparedStatement pstmt=conn.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
%>
<table border="1" bgcolor="#9999dd"  align="center">
<tr>
  <td>商品ID</td>
  <td>商品名称</td>
  <td>商品编号</td>
  <td>类别</td>
  <td>库存量</td>
</tr>
<%
while(rs.next()){
 
out.println("<tr align='center'>");
out.println("<td>"+rs.getString(1)+"</td>");
out.println("<td>"+rs.getString(2)+"</td>");
out.println("<td>"+rs.getString(3) +"</td>");
out.println("<td>"+rs.getString(4)+"</td>");
out.println("<td>"+rs.getInt(5) +"</td>");
 out.println("</tr");
 }
 %>
</table>
  </body>
</html>

编写完之后,项目名称上右击，run as -> run on server

Jw1-7.png

取自“http://www.openbrains.net/mediawiki/index.php?title=Java_web_连接MySQL数据库&oldid=9125”