JSP----mysql 增、删、改

来源：互联网发布：企业saas软件编辑：程序博客网时间：2024/06/06 02:53

<%@ page language="java" contentType="text/html; charset=gb2312"

pageEncoding="gb2312"%>

<%@page import="java.sql.*" %>

<%@page import="com.mysql.jdbc.Driver" %>

<%@page import="java.io.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

</head>

<body>

<h1 align="center">向数据库中添加数据</h1><hr>

String driverName = "com.mysql.jdbc.Driver";

String userName = "root";

String passWord = "root";

String dbName = "bd_table";

// String tableName = "usermanager";

String url = "jdbc:mysql://localhost/" + dbName +"?user=" + userName +"&password=" +passWord;

Class.forName(driverName).newInstance();

Connection conn = DriverManager.getConnection(url);

Statement stat = conn.createStatement();

//用statement 一次添加一条记录

String sql = "insert into usermanager values('1010','jack','m')";

stat.executeUpdate(sql);

out.println("statement,添加数据成功！<p>");

//用PreparedStatement 添加多条记录

String sql3 = "insert into usermanager values(?,?,?)";

PreparedStatement pre = conn.prepareStatement(sql3);

//添加第一条记录

pre.setString(1,"1005");

pre.setString(2,"燕妮");

pre.setString(3,"女");

pre.executeUpdate();

//添加第二天记录

pre.setString(1,"1006");

pre.setString(2,"张三");

pre.setString(3,"男");

pre.executeUpdate();

//添加第三条记录

pre.setString(1,"1007");

pre.setString(2,"Tom");

pre.setString(3,"男");

pre.executeUpdate();

out.println("PreparedStatement,添加数据成功！<p>");

//删除数据

String sql1 = "delete from usermanager where name = 'jack'";

int row1 = stat.executeUpdate(sql1);

out.print(row1 + "条记录被删除！");

//修改数据

String sql2 = "update usermanager set name='Mr_g' where num='1002'";

int row2 = stat.executeUpdate(sql2);

out.println(row2 + "条记录被修改！<p>");

stat.close();

conn.close();

<a href="test.jsp" >返回test.jsp页面,查看数据</a><br>

</center>

</body>

</html>

JSP----mysql 增、删 、改

JSP----mysql 增、删、改