如何通过eplise将数据表写入workbench中

最新推荐文章于 2024-05-30 14:59:09 发布

我不是猫猫头

最新推荐文章于 2024-05-30 14:59:09 发布

阅读量93

点赞数

文章标签：数据库 mysql

本文链接：https://blog.csdn.net/sjskbxiqznkqk/article/details/126997446

版权

如何通过eplise将数据表写入workbench中

先创建前端文件addEmployee.jsp

<%@ page language="java" contentType="text/html; charset=gb2312" %> 
<html> 
 	<head> 
 			<title>员工信息录入</title> 
 	</head> 
  <body> 
 	请填写员工相关数据<br><br> 
 	<form action="addEmployInDB.jsp" method="post"> 
	 	编号: <input type="text" name="id"><br> 
	 	姓名: <input type="text" name="xname"><br> 
	 	email: <input type="text" name="email"><br> 
	 	电话: <input type="text" name="phone"><br> 
	 	部门: <input type="text" name="depart"><br> 
	 	职能: <input type="text" name="role"><br> 
 		<input type="submit" value="提交"><input type="reset" value="重填"> 
 	</form> 
 </body> 
</html>

再同一个文件夹下创建后端文件addEmployInDB.jsp

<%@page contentType="text/html; charset=gb2312" pageEncoding="gb2312"%> 
<%@page language="java" import="java.util.*"%> 
<%@page import="java.sql.*"%> 
<html> 
 <head> 
 <title>QIS 增加用户</title> 
 </head> 
 <body> 
 <p align="center"> 增加新用户 </p> 
 <% 
 Class.forName("com.mysql.jdbc.Driver").newInstance(); 
 String url="jdbc:mysql://localhost:3306/qis?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"; 
 String user="root"; 
 String password="此处输入你的密码"; 
 Connection conn=DriverManager.getConnection(url,user,password); 
 String id=request.getParameter("id"); 
 String name1=request.getParameter("xname"); 
 String phone=request.getParameter("phone"); 
 String email1=request.getParameter("email"); 
 String depart1=request.getParameter("depart"); 
 String role1=request.getParameter("role"); 
 String name=new String(name1.getBytes("ISO-8859-1"),"gb2312"); 
 String email=new String(email1.getBytes("ISO-8859-1"),"gb2312"); 
 String depart=new String(depart1.getBytes("ISO-8859-1"),"gb2312"); 
 String role=new String(role1.getBytes("ISO-8859-1"),"gb2312"); 
 try{ 
 //创建语句对象 Statement 
 Statement pst=conn.createStatement(); 
 String sql="insert into table1(userId,password,name,phone,email," 
 + "department,role) values('"+id+"','123456','"+name+"'" 
 + ",'"+phone+"','"+email+"','"+depart+"','"+role+"')"; 
 pst.executeUpdate(sql); 
 out.println("添加用户成功");
 }catch(SQLException e){ 
 out.println("添加用户失败"); 
 } 
 %> 
 <script type="text/javascript">setTimeout("history.go(-1)", 1000); </script> 
 </body> 
</html>