如何在jsp页面中实现点击一个提交按钮就可以将页面上的数据存储到对应的数据库中的表中，具体的表是User，字段是id，name，data（时间），text（发布内容），我是初学者，麻烦哪个兄弟帮忙给提供下代码，用jsp编写
第1个回答 推荐于2017-11-23
register.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>这是一个注册页面</title>
</head>
<body>
<center>
<form action="adduser.jsp" method="post">
<table width="777" border="0" cellspacing="0" cellpadding="0" align="center" style="top: 131px; height: 30px;">
<tr>
<td align="left"><b><font size="3">用户序号:</font></b></td>
<td><input type="text" name="id" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">用户名:</font></b></td>
<td><input type="text" name="name" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">时间:</font></b></td>
<td><input type="date" name="date" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">发布内容:</font></b></td>
<textarea name="text" cols="40" rows="5">请在这里输入您要发布的内容</textarea>
</tr>
<tr><td><input type="submit" name="Submit" value="提交"></td></tr>
</table>
</form>
</center>
</body>
</html>
adduser.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="query" class="user.dbfunction" scope="page"></jsp:useBean>
<html>
<head>
<title>将用户信息加入数据库</title>
</head>
<body>
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String date = request.getParameter("date");
String text = request.getParameter("text");
ResultSet rs=null;
String str="select id,name,date,text from User where name='"+name+"';";
query.connect();
rs=query.select(str);
rs.last();
str="insert into User(id,name,date,text)values('"+id+"','"+name+"','"+date+"','"+text+"');";
query.update(str);
out.println("提交信息成功！");
out.print("本页面将在3秒后自动跳转到上一页面！");
out.print("<meta http-equiv="+"refresh"+" content=" +"3;url=register.jsp"+">");
%>
</body>
</html>
附加数据库操作类：
// 本类用来建立与数据库的连接
package user;
import java.sql.*;
public class dbfunction {
private static Connection con = null;
private static Statement stmt = null;
private static ResultSet rs = null;
public void connect(){
String url = "jdbc:mysql://localhost:3306/bookshop"; /在这里修改数据库名
try {
Class.forName("com.mysql.jdbc.Driver");/在这里修改数据库，我用的是Mysql
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/bookshop?user=root&password=123456&useUnicode=true&characterEncoding=GB2312");/在这里修改数据库Mysql的信息
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public ResultSet select(String query)
{
System.out.println(query);
try {
stmt = con.createStatement();
rs = stmt.executeQuery(query);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public void update(String upstr)
{
System.out.println(upstr);
try {
stmt = con.createStatement();
int rs = stmt.executeUpdate(upstr);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void close()
{
try {
stmt.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
我在我的机子上做了一遍可以，你试试吧。。。本回答被提问者采纳
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>这是一个注册页面</title>
</head>
<body>
<center>
<form action="adduser.jsp" method="post">
<table width="777" border="0" cellspacing="0" cellpadding="0" align="center" style="top: 131px; height: 30px;">
<tr>
<td align="left"><b><font size="3">用户序号:</font></b></td>
<td><input type="text" name="id" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">用户名:</font></b></td>
<td><input type="text" name="name" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">时间:</font></b></td>
<td><input type="date" name="date" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">发布内容:</font></b></td>
<textarea name="text" cols="40" rows="5">请在这里输入您要发布的内容</textarea>
</tr>
<tr><td><input type="submit" name="Submit" value="提交"></td></tr>
</table>
</form>
</center>
</body>
</html>
adduser.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="query" class="user.dbfunction" scope="page"></jsp:useBean>
<html>
<head>
<title>将用户信息加入数据库</title>
</head>
<body>
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String date = request.getParameter("date");
String text = request.getParameter("text");
ResultSet rs=null;
String str="select id,name,date,text from User where name='"+name+"';";
query.connect();
rs=query.select(str);
rs.last();
str="insert into User(id,name,date,text)values('"+id+"','"+name+"','"+date+"','"+text+"');";
query.update(str);
out.println("提交信息成功！");
out.print("本页面将在3秒后自动跳转到上一页面！");
out.print("<meta http-equiv="+"refresh"+" content=" +"3;url=register.jsp"+">");
%>
</body>
</html>
附加数据库操作类：
// 本类用来建立与数据库的连接
package user;
import java.sql.*;
public class dbfunction {
private static Connection con = null;
private static Statement stmt = null;
private static ResultSet rs = null;
public void connect(){
String url = "jdbc:mysql://localhost:3306/bookshop"; /在这里修改数据库名
try {
Class.forName("com.mysql.jdbc.Driver");/在这里修改数据库，我用的是Mysql
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/bookshop?user=root&password=123456&useUnicode=true&characterEncoding=GB2312");/在这里修改数据库Mysql的信息
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public ResultSet select(String query)
{
System.out.println(query);
try {
stmt = con.createStatement();
rs = stmt.executeQuery(query);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
public void update(String upstr)
{
System.out.println(upstr);
try {
stmt = con.createStatement();
int rs = stmt.executeUpdate(upstr);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void close()
{
try {
stmt.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
我在我的机子上做了一遍可以，你试试吧。。。本回答被提问者采纳
第2个回答 2018-07-18
register.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>这是一个注册页面</title>
</head>
<body>
<center>
<form action="adduser.jsp" method="post">
<table width="777" border="0" cellspacing="0" cellpadding="0" align="center" style="top: 131px; height: 30px;">
<tr>
<td align="left"><b><font size="3">用户序号:</font></b></td>
<td><input type="text" name="id" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">用户名:</font></b></td>
<td><input type="text" name="name" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">时间:</font></b></td>
<td><input type="date" name="date" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">发布内容:</font></b></td>
<textarea name="text" cols="40" rows="5">请在这里输入您要发布的内容</textarea>
</tr>
<tr><td><input type="submit" name="Submit" value="提交"></td></tr>
</table>
</form>
</center>
</body>
</html>
adduser.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="query" class="user.dbfunction" scope="page"></jsp:useBean>
<html>
<head>
<title>将用户信息加入数据库</title>
</head>
<body>
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String date = request.getParameter("date");
String text = request.getParameter("text");
ResultSet rs=null;
String str="select id,name,date,text from User where name='"+name+"';";
query.connect();
rs=query.select(str);
rs.last();
str="insert into User(id,name,date,text)values('"+id+"','"+name+"','"+date+"','"+text+"');";
query.update(str);
out.println("提交信息成功！");
out.print("本页面将在3秒后自动跳转到上一页面！");
out.print("<meta http-equiv="+"refresh"+" content=" +"3;url=register.jsp"+">");
%>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<html>
<head>
<title>这是一个注册页面</title>
</head>
<body>
<center>
<form action="adduser.jsp" method="post">
<table width="777" border="0" cellspacing="0" cellpadding="0" align="center" style="top: 131px; height: 30px;">
<tr>
<td align="left"><b><font size="3">用户序号:</font></b></td>
<td><input type="text" name="id" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">用户名:</font></b></td>
<td><input type="text" name="name" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">时间:</font></b></td>
<td><input type="date" name="date" size="12"></td>
</tr>
<tr>
<td align="left"><b><font size="3">发布内容:</font></b></td>
<textarea name="text" cols="40" rows="5">请在这里输入您要发布的内容</textarea>
</tr>
<tr><td><input type="submit" name="Submit" value="提交"></td></tr>
</table>
</form>
</center>
</body>
</html>
adduser.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="query" class="user.dbfunction" scope="page"></jsp:useBean>
<html>
<head>
<title>将用户信息加入数据库</title>
</head>
<body>
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String date = request.getParameter("date");
String text = request.getParameter("text");
ResultSet rs=null;
String str="select id,name,date,text from User where name='"+name+"';";
query.connect();
rs=query.select(str);
rs.last();
str="insert into User(id,name,date,text)values('"+id+"','"+name+"','"+date+"','"+text+"');";
query.update(str);
out.println("提交信息成功！");
out.print("本页面将在3秒后自动跳转到上一页面！");
out.print("<meta http-equiv="+"refresh"+" content=" +"3;url=register.jsp"+">");
%>
</body>
</html>
