📄 ex5_2.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title>添加数据</title>
</head>
<body>
<h2>添加客户信息</h2>
<form name="form1" method="post" action="Ex5_2.jsp?action=submit">
<table width="59%" height="156" border="0" cellpadding="0"
cellspacing="0">
<tr>
<td width="21%">客户名:</td>
<td width="79%"><input name="name" type="text" size="10"></td>
</tr>
<tr>
<td>电话：</td>
<td><input name="tel" type="text" size="10"></td>
</tr>
<tr>
<td>Email：</td>
<td><input name="email" type="text" size="10"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="添加"></td>
</tr>
</table>
</form>
<font size=2>
<% //连接需要的对象
Connection conn = null;
Statement stmt = null;
String sql = null;
ResultSet rs = null;
int ret;
String action = request.getParameter("action");
if ("submit".equals(action)) {
String name = request.getParameter("name");
String tel = request.getParameter("tel");
String email = request.getParameter("email");
Timestamp addtime = new Timestamp(System.currentTimeMillis());
try {
Class.forName("com.mysql.jdbc.Driver"); //载入JDBC驱动程序
String strCon = "jdbc:mysql://localhost:3306/JspSamples"; //连接字
conn = DriverManager.getConnection(strCon, "root", "root"); //连接数据库
stmt = conn.createStatement(); //初始化查询
sql = "insert into customers (Name, Tel, addTime, Email) values('" //插入数据
+ name + "','" + tel + "','" + addtime + "','" + email + "')";
ret = stmt.executeUpdate(sql); //执行插入数据
stmt.close(); //关闭查询
conn.close(); //关闭连接
} catch (ClassNotFoundException e) { //意外处理，驱动程序无法找到
e.printStackTrace();
out.println("<h1>无法找到数据库驱动</h1>");
} catch (SQLException e1) { //意外处理，数据库操作失败
e1.printStackTrace();
out.println("<h1>数据库操作失败</h1>");
}
out.println("<h1>插入数据到JspSamples的customers表成功</h1>");
}
%> </font>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -