📄 insert.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%
// 获取用户输入的参数
String no = request.getParameter("no");
String name = request.getParameter("name");
String email = request.getParameter("email");
String person_phone = request.getParameter("person_phone");
String qq = request.getParameter("qq");
String home_phone = request.getParameter("home_phone");
%>
<%!
// 定义数据库驱动程序
String DBDRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
// 定义数据库连接地址
String DBURL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\Documents and Settings\\Administrator\\jbproject\\MyWebProject\\MyWebApp\\Student.mdb";
// 定义数据库连接对象，属于java.sql包中的接口
Connection conn = null;
// 定义PrepareStatement对象，用于操作数据库
PreparedStatement stmt = null;
// 定义一字符串变量，用于保存SQL语句
String sql = null;
%>
<%
// 加载驱动程序
try
{
Class.forName(DBDRIVER);
}
catch(Exception e)
{
out.println("加载驱动器失败");
}
// 连接数据库
try
{
conn = DriverManager.getConnection(DBURL);
}
catch(Exception e)
{
out.println("数据库连接失败");
}
// 操作数据库
try
{
sql = "insert into student(no,name,email,person_phone,qq,home_phone) values(?,?,?,?,?,?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1,no);
stmt.setString(2,name);
stmt.setString(3,email);
stmt.setString(4,person_phone);
stmt.setString(5,qq);
stmt.setString(6,home_phone);
stmt.executeUpdate();
}
catch(Exception e)
{
out.println("操作数据库失败");
}
// 关闭数据库
try
{
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println("数据库关闭失败");
}
%>
<html>
<head>
<title>
Insert
</title>
</head>
<body bgcolor="#ffffff">
<jsp:forward page="Success.jsp"/>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -