Summary of examples of common methods for jsp+mysql database operations-PHP开发-php.cn

Home

php教程

PHP开发

Summary of examples of common methods for jsp+mysql database operations

高洛峰

Dec 27, 2016 pm 01:41 PM

The examples in this article describe common methods of jsp+mysql database operations. Share it with everyone for your reference. The details are as follows:

1. View:

<%@ 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=&#39;font-size: 10pt&#39;>"); 
out.print("<TR><td colspan=5 align=center>考生数据</td></tr>"); 
out.print("<TR><td colspan=5 align=center><a href=&#39;add.jsp&#39; target=&#39;_self&#39;>添加考生信息</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=&#39;delete.jsp?id="+idstr+"&#39;>删除</a></TD>"); 
out.print("<TD><a href=&#39;update.jsp?id="+idstr+"&#39;>修改</a></TD>"); 
out.print("</TR>") ; 
}
out.print("</Table>"); 
con.close(); 
} 
catch(SQLException e1) 
{ 
out.print("SQL异常！！！！"); 
} 
%> 
</center>
</BODY> 
</HTML>

2. add Add:

<%@ 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. delete Delete:

<%@ 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=&#39;font-size: 10pt&#39;>"); 
out.print("<TR><td colspan=5 align=center>考生数据</td></tr>");
out.print("<TR><td colspan=5 align=center><a href=&#39;add.jsp&#39; target=&#39;_self&#39;>添加考生信息</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=&#39;delete.jsp?id="+idstr+"&#39;>删除</a></TD>"); 
out.print("<TD><a href=&#39;update.jsp?id="+idstr+"&#39;>修改</a></TD>"); 
out.print("</TR>") ; 
} 
out.print("</Table>"); 
con.close(); 
} 
catch(SQLException e1) 
{ 
out.print("SQL异常！！！！"); 
} 
%>
</center>
</body> 
</html>

4. update Example 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. update Example 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=&#39;"+name+"&#39;,age=&#39;"+age+"&#39;,birth=&#39;"+birth+"&#39; 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. insert insert

<%@ 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(&#39;"+name+"&#39;,&#39;"+age+"&#39;,&#39;"+birth+"&#39;)";
System.out.print(sql2);
int s=sql.executeUpdate(sql2);
}
catch(Exception e){
System.out.println(e);
}
%>
恭喜你，添加成功！<br />
<a href="chakan.jsp">查看</a>

7. Create database

/*
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;

I hope this article will help everyone’s JSP Programming helps.

For more jsp+mysql database operation examples and summary of common methods and related articles, please pay attention to the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

What's New in Windows 11 KB5054979 & How to Fix Update Issues

3 weeks agoByDDD

How to fix KB5055523 fails to install in Windows 11?

2 weeks agoByDDD

InZoi: How To Apply To School And University

4 weeks agoByDDD

How to fix KB5055518 fails to install in Windows 10?

2 weeks agoByDDD

Roblox: Dead Rails – How To Summon And Defeat Nikola Tesla

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download

The most popular open source editor

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.