主頁 > 知識庫 > jsp+mysql數(shù)據(jù)庫操作常用方法實例總結(jié)

jsp+mysql數(shù)據(jù)庫操作常用方法實例總結(jié)

熱門標簽:杭州語音電銷機器人軟件 地圖標注線上教程 電銷機器人是有一些什么技術(shù) 商洛電銷 北票市地圖標注 杭州ai語音電銷機器人功能 電銷機器人好賣么 四川保險智能外呼系統(tǒng)商家 高德地圖標注樣式

本文實例講述了jsp+mysql數(shù)據(jù)庫操作常用方法。分享給大家供大家參考。具體如下:

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>考生數(shù)據(jù)/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">nbsp;/td>
   td width="42" wnameth="50">Input type="reset" name="h" value="重置">/td>
   td width="33" wnameth="42">nbsp;/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>考生數(shù)據(jù)/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>nbsp; /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="修改">nbsp; nbsp; nbsp;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. 創(chuàng)建數(shù)據(jù)庫

/*
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程序設(shè)計有所幫助。

您可能感興趣的文章:
  • 國內(nèi)常用的js類庫大全(CDN公共庫)
  • Java幾種常用JSON庫性能比較詳解
  • Python常用的json標準庫
  • 常用的9個JavaScript圖表庫詳解
  • JSP中操作數(shù)據(jù)庫的常用SQL標簽用法總結(jié)
  • JavaScript 常用函數(shù)庫詳解
  • 簡單了解常用的JavaScript 庫

標簽:西藏 紅河 丹東 云浮 江西 宿州 貴州 青島

巨人網(wǎng)絡(luò)通訊聲明:本文標題《jsp+mysql數(shù)據(jù)庫操作常用方法實例總結(jié)》,本文關(guān)鍵詞  jsp+mysql,數(shù)據(jù)庫,操作,常用,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《jsp+mysql數(shù)據(jù)庫操作常用方法實例總結(jié)》相關(guān)的同類信息!
  • 本頁收集關(guān)于jsp+mysql數(shù)據(jù)庫操作常用方法實例總結(jié)的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章