jsp+mysql 데이터베이스 작업에 대한 일반적인 방법의 예 요약
- 高洛峰원래의
- 2016-12-27 13:41:362013검색
이 문서의 예에서는 jsp+mysql 데이터베이스 작업의 일반적인 방법을 설명합니다. 참고할 수 있도록 모든 사람과 공유하세요. 세부 내용은 다음과 같습니다.
1. 보기:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><style type="text/css">
<!--
body {
background-color: #99CCFF;
}
-->
</style>
<BODY>
<font color="#FFFFFF">
<center>
<% Connection con;
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
Statement sql;
ResultSet rs;
try
{
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
out.print("<Table Border style='font-size: 10pt'>");
out.print("<TR><td colspan=5 align=center>考生数据</td></tr>");
out.print("<TR><td colspan=5 align=center><a href='add.jsp' target='_self'>添加考生信息</a></td></tr>");
out.print("<TR>");
out.print("<Td width=50 >"+"姓名");
out.print("<Td width=100 >"+"年龄");
out.print("<Td width=100>"+"出生日期");
out.print("<Td width=100 colspan=2>"+"操作");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getString(3)+"</TD>");
out.print("<TD >"+rs.getString(4)+"</TD>");
String idstr=rs.getString(1);
out.print("<TD><a href='delete.jsp?id="+idstr+"'>删除</a></TD>");
out.print("<TD><a href='update.jsp?id="+idstr+"'>修改</a></TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！！！！");
}
%>
</center>
</BODY>
</HTML>2. 추가:
<%@ page contentType="text/html;charset=gb2312" %>
<HTML><HEAD>
<style type="text/css">
<!--
body {
background-image: url();
background-color: #CCCCFF;
}
.STYLE5 {font-family: "Courier New", Courier, monospace; font-size: 14px; }
.STYLE6 {
font-family: "Courier New", Courier, monospace;
font-size: 24px;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></HEAD>
<BODY>
<Font size=2>
<p align="center" class="STYLE6">添加考生信息</p>
<CENTER>
<FORM action="insert.jsp" name=form>
<table>
<tr><td height="36"><span class="STYLE5">姓名:</span></td>
<td><Input name="name" type=text size="15" ></td></tr>
<tr>
<td height="36"><span class="STYLE5">年龄:</span></td>
<td><Input name="age" type=text size="15"></td></tr>
<tr>
<td height="36"><span class="STYLE5">出生年月:</span></td>
<td><Input name="birth" type=text size="15"></td></tr>
</table>
<table width="165">
<tr><td width="42" wnameth="42"><Input type=submit name="g" value="添加"></td>
<td width="28" wnameth="50"> </td>
<td width="42" wnameth="50"><Input type="reset" name="h" value="重置"></td>
<td width="33" wnameth="42"> </td>
</tr>
</table>
</Form></CENTER>
</Body></HTML>3. 삭제:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>删除操作</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
background-color: #FFCCFF;
}
-->
</style></head>
<body>
<center>
<% Connection con;
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
Statement stmt;
Statement s;
ResultSet rs;
String id=request.getParameter("id");
try
{
stmt=con.createStatement();
String sql="delete from student where id="+id;
stmt.executeUpdate(sql);
s=con.createStatement();
rs=s.executeQuery("SELECT * FROM student");
out.print("<Table Border style='font-size: 10pt'>");
out.print("<TR><td colspan=5 align=center>考生数据</td></tr>");
out.print("<TR><td colspan=5 align=center><a href='add.jsp' target='_self'>添加考生信息</a></td></tr>");
out.print("<TR>");
out.print("<Td width=50 >"+"姓名");
out.print("<Td width=100 >"+"年龄");
out.print("<Td width=100>"+"出生日期");
out.print("<Td width=100 colspan=2>"+"操作");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getString(3)+"</TD>");
out.print("<TD >"+rs.getString(4)+"</TD>");
String idstr=rs.getString(1);
out.print("<TD >"+idstr+"</TD>");
out.print("<TD><a href='delete.jsp?id="+idstr+"'>删除</a></TD>");
out.print("<TD><a href='update.jsp?id="+idstr+"'>修改</a></TD>");
out.print("</TR>") ;
}
out.print("</Table>");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！！！！");
}
%>
</center>
</body>
</html>4. 업데이트 예시 1:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #FFCCFF;
}
-->
</style></head>
<body>
<%String id=request.getParameter("id");
Connection con;
String name=null;
String age=null;
String birth=null;
String id1=null;
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
Statement sql;
ResultSet rs;
try
{
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
while(rs.next())
{
name=rs.getString(2);
age=rs.getString(3);
birth=rs.getString(4);
id1=rs.getString(1);
}
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！！！！");
}
%>
<center>
<form action="update2.jsp">
<center>
<p> </p>
<p>姓名：
<input name="name" type="text" size="15" value="<%=name%>">
</p>
<p>
年龄：
<input name="age" type="text" size="15" value="<%=age%>">
</p>
<p>出生日期：
<input name="birth" type="text" size="15" value="<%=birth%>">
<input name="id1" type="hidden" value="<%=id1%>" />
</p>
<p><input name="g" type="submit" value="修改"> <input name="h" type="reset" value="重置"></p>
</form>
</center>
</body>
</html>5. 업데이트 예시 2:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%
String name=request.getParameter("name");
String age=request.getParameter("age");
String birth=request.getParameter("birth");
String id1=request.getParameter("id1");
System.out.println(id1);
Connection con=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
Statement sql;
sql=con.createStatement();
String sql2="update student set name='"+name+"',age='"+age+"',birth='"+birth+"' where id="+id1;
System.out.print(sql2);
int s=sql.executeUpdate(sql2);
}
catch(Exception e){
System.out.println(e);
}
%>
恭喜你，修改成功！<br />
<a href="chakan.jsp">查看</a>6. 데이터베이스 삽입
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%
String name=request.getParameter("name");
String age=request.getParameter("age");
String birth=request.getParameter("birth");
Connection con=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456");
Statement sql;
sql=con.createStatement();
String sql2="insert into student(name,age,birth) values('"+name+"','"+age+"','"+birth+"')";
System.out.print(sql2);
int s=sql.executeUpdate(sql2);
}
catch(Exception e){
System.out.println(e);
}
%>
恭喜你，添加成功！<br />
<a href="chakan.jsp">查看</a>🎜>
/* MySQL Data Transfer Source Host: localhost Source Database: student Target Host: localhost Target Database: student Date: 2009-3-27 13:24:01 */ SET FOREIGN_KEY_CHECKS=0; create database student; use student; -- ---------------------------- -- Table structure for student -- ---------------------------- CREATE TABLE `student` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `age` varchar(255) default NULL, `birth` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;이 글이 모든 분들의 JSP 프로그래밍 설계에 도움이 되기를 바랍니다. jsp+mysql 데이터베이스 작업에 대한 일반적인 방법에 대한 더 많은 예와 요약을 보려면 PHP 중국어 웹사이트에 주목하세요!
성명：
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
이전 기사：Joomla 데이터베이스 작업 샘플 코드다음 기사：Joomla 데이터베이스 작업 샘플 코드