jsp 与 mysql连接
来源:互联网 发布:浦科特m8peg 软件 编辑:程序博客网 时间:2024/05/15 04:54
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@page import="java.sql.*"%>
<%@page contentType="text/html; charset=gb2312"%>
<html>
<style type="text/css">
<!--
.style1 {
font-family: "宋体";
font-size: 14px;
}
-->
</style>
<head>
<title>person_show</title>
</head>
<body>
<table>
<table width="800" border="1" cellspacing="0" bordercolor="#336666">
<tr>
<td align="center" nowrap>ID</td>
<td align="center" nowrap ><span class="style1">姓名</span></td>
<td align="center" nowrap><span class="style1">性别</span></td>
<td align="center" nowrap><span class="style1">年龄</span></td>
<td align="center" nowrap><span class="style1">电话</span></td>
<td align="center" nowrap><span class="style1">住址</span></td>
<td align="center" nowrap><span class="style1">Email</span></td>
<td align="center" nowrap><span class="style1">操作</span></td>
</tr>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/user_table","root","mzq8293");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users");
while(rs.next())
{
%>
<tr class="style1">
<td align="center" class="style1"><%=rs.getString("id")%></td>
<td align="center"><%=rs.getString("name")%></td>
<td align="center"><%=rs.getInt("sex") == 0 ? "男":"女"%></td>
<td align="center"><%=rs.getString("age")%></td>
<td align="center"><%=rs.getString("phone")%></td>
<td align="center"><%=rs.getString("address")%></td>
<td align="center"><%=rs.getString("email")%></td>
<td align="center">修改 || 删除</td>
</tr>
<%
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
</table>
<p align="center">添加 返回</p>
</body>
</html>
<%@page import="java.sql.*"%>
<%@page contentType="text/html; charset=gb2312"%>
<html>
<style type="text/css">
<!--
.style1 {
font-family: "宋体";
font-size: 14px;
}
-->
</style>
<head>
<title>person_show</title>
</head>
<body>
<table>
<table width="800" border="1" cellspacing="0" bordercolor="#336666">
<tr>
<td align="center" nowrap>ID</td>
<td align="center" nowrap ><span class="style1">姓名</span></td>
<td align="center" nowrap><span class="style1">性别</span></td>
<td align="center" nowrap><span class="style1">年龄</span></td>
<td align="center" nowrap><span class="style1">电话</span></td>
<td align="center" nowrap><span class="style1">住址</span></td>
<td align="center" nowrap><span class="style1">Email</span></td>
<td align="center" nowrap><span class="style1">操作</span></td>
</tr>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/user_table","root","mzq8293");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users");
while(rs.next())
{
%>
<tr class="style1">
<td align="center" class="style1"><%=rs.getString("id")%></td>
<td align="center"><%=rs.getString("name")%></td>
<td align="center"><%=rs.getInt("sex") == 0 ? "男":"女"%></td>
<td align="center"><%=rs.getString("age")%></td>
<td align="center"><%=rs.getString("phone")%></td>
<td align="center"><%=rs.getString("address")%></td>
<td align="center"><%=rs.getString("email")%></td>
<td align="center">修改 || 删除</td>
</tr>
<%
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
</table>
<p align="center">添加 返回</p>
</body>
</html>
- jsp 与 mysql连接
- JSP与mysql的连接
- jsp连接mysql与sqlserver
- Jsp与MySQL的JDBC连接
- Jsp与Mysql连接探究查错
- Jsp与Mysql连接探究查错
- JSP连接MySQL配置与使用
- 跪求 jsp与mysql连接配置
- jsp 与mysql 连接字符编码转换
- jsp通过jdbc驱动与mysql连接
- JSP 连接MySQL配置与使用
- jsp数据库基础之---jsp与MySQL数据库的连接
- JSP MySQL JSP连接MySQL
- Jsp 中连接MySQL
- JSP连接Mysql数据库
- JSP连接Mysql实战
- JSP连接Mysql实战
- jsp连接数据库---Mysql
- asp.net/c#字符格式化大总结
- 简洁实用的表单验证程序
- Undercut
- ASP.NET中用healthMonitor属性用
- Asp.net如何实现页面间的参数传递
- jsp 与 mysql连接
- 杂记
- C语言内联函数
- PHP连接MySQL的2种方法以及防止乱码
- Unix-center免费提供Unix/Linux体验和测试环境
- ASP.NET 2.0数据处理之高级分页/排序
- 博客开业啦~~~
- 求补原理
- ASP.NET中绑定枚举类型