jsp页面提交表单到sql

最新推荐文章于 2022-03-28 15:43:31 发布

呵呵哒呵呵705

最新推荐文章于 2022-03-28 15:43:31 发布

阅读量3k

点赞数 3

分类专栏：数据库文章标签： jsp sql

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

insert.jsp

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%> 
<%@ page contentType="text/html;charset=utf-8"%> 
<%  
   request.setCharacterEncoding("UTF-8");  
   response.setCharacterEncoding("UTF-8");  
   response.setContentType("text/html; charset=utf-8");  
%>  
<html> 
<head> 
<title>add message into table </TITLE> 
</head> 
<body> 
<% 
String id=request.getParameter("id"); //从表单获得 
String name=request.getParameter("name"); //从表单获得 
String sex=request.getParameter("sex"); //从表单获得 
String age=request.getParameter("age"); //从表单获得 

java.util.Date date=new java.util.Date(); 
String datetime=new Timestamp(date.getTime()).toString(); 
try 
{ 
/** 连接数据库参数 **/ 
String driverName = "com.mysql.jdbc.Driver"; //驱动名称 
String DBUser = "root"; //mysql用户名 
String DBPasswd = "XXXXXX"; //mysql密码 
String DBName = "html_db"; //数据库名 

String connUrl = "jdbc:mysql://localhost:3306/" + DBName + "?user=" + DBUser + "&password=" + DBPasswd; 

 //"jdbc:mysql://localhost:3306/test?"
 //       + "user=root&password=XXXXXX&useUnicode=true&characterEncoding=UTF8"
Class.forName(driverName).newInstance(); 
Connection conn = DriverManager.getConnection(connUrl); 
Statement stmt = conn.createStatement(); 
stmt.executeQuery("SET NAMES UTF8"); 
String insert_sql = "insert into person_tb values('" + id + "','" + name + "','" + sex + "','" + age + "')"; 
String query_sql = "select * from person_tb"; 

try { 
stmt.execute(insert_sql); 
}catch(Exception e) { 
e.printStackTrace(); 
} 
try { 
ResultSet rs = stmt.executeQuery(query_sql); 
while(rs.next()) { 
%> 
ID：<%=rs.getString("ID")%> </br> 
姓名：<%=rs.getString("name")%> </br> 
性别：<%=rs.getString("sex")%> </br> 
年龄：<%=rs.getString("age")%> </br> </br> 
<% 
} 
}catch(Exception e) { 
e.printStackTrace(); 
} 
//rs.close(); 
stmt.close(); 
conn.close(); 
}catch (Exception e) { 
e.printStackTrace(); 
} 
%> 
</body> 
</html>

index.jsp

<%@ page language="java" pageEncoding="utf-8"%> 
<%@ page contentType="text/html;charset=utf-8"%>  
<%  
   request.setCharacterEncoding("UTF-8");  
   response.setCharacterEncoding("UTF-8");  
   response.setContentType("text/html; charset=utf-8");  
%>  
<html> 
<head> 
</head> 
<body> 
<form action="insert.jsp" method="post"> 
ID :<input type = "text" name="id" value="0"/> 
姓名 :<input type = "text" name="name" value="aaa"/> 
性别 :<input type = "text" name="sex" value="female"/> 
年龄 :<input type = "text" name="age" value="20"/> 
</br> 
<input type = "submit" value="提交"/> 
</form> 
</body> 
</html>

jsp页面

jsp页面

数据库中显示内容

数据库中显示内容

呵呵哒呵呵705

关注

3
点赞
踩
18

收藏

觉得还不错? 一键收藏
2
评论
jsp页面提交表单到sql

insert.jsp<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%> <%@ page contentType="text/html;charset=utf-8"%> <% request.setCharacterEncoding("UTF-8"); respons
复制链接

扫一扫

专栏目录