本文实例讲述了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. 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 删除:
<%@ 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. update 示例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 示例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. 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('"+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>
7. 创建数据库
/* 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

热AI工具

Undresser.AI Undress
人工智能驱动的应用程序,用于创建逼真的裸体照片

AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool
免费脱衣服图片

Clothoff.io
AI脱衣机

AI Hentai Generator
免费生成ai无尽的。

热门文章
R.E.P.O.能量晶体解释及其做什么(黄色晶体)
2 周前By尊渡假赌尊渡假赌尊渡假赌
仓库:如何复兴队友
4 周前By尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
4 周前By尊渡假赌尊渡假赌尊渡假赌
击败分裂小说需要多长时间?
3 周前ByDDD
R.E.P.O.保存文件位置:在哪里以及如何保护它?
3 周前ByDDD

热工具

SublimeText3 Mac版
神级代码编辑软件(SublimeText3)

mPDF
mPDF是一个PHP库,可以从UTF-8编码的HTML生成PDF文件。原作者Ian Back编写mPDF以从他的网站上“即时”输出PDF文件,并处理不同的语言。与原始脚本如HTML2FPDF相比,它的速度较慢,并且在使用Unicode字体时生成的文件较大,但支持CSS样式等,并进行了大量增强。支持几乎所有语言,包括RTL(阿拉伯语和希伯来语)和CJK(中日韩)。支持嵌套的块级元素(如P、DIV),

SublimeText3汉化版
中文版,非常好用

EditPlus 中文破解版
体积小,语法高亮,不支持代码提示功能

VSCode Windows 64位 下载
微软推出的免费、功能强大的一款IDE编辑器