📄 insertdata.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="javax.naming.NamingException" %>
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=GBK">
<TITLE>插入数据</TITLE></HEAD>
<BODY>
<%
Connection conn=null;
try {
request.setCharacterEncoding("GBK");
InitialContext ic=new InitialContext();
DataSource ds=(DataSource)ic.lookup("jdbc/DBConnCoreDS");
conn=ds.getConnection();
if(!conn.isClosed()) {
out.println("数据库连接成功!");
}
Statement st=conn.createStatement();
st.executeUpdate("INSERT into emp(emp_id,emp_name,dept_id,emp_age,emp_job,emp_salary)"+
"values('103','李晓一','10',33,'计划员',2300.00)");
out.println("\n记录插入完毕!");
st.close();
}
catch(SQLException e) {
out.println("\n数据库连接失败!");
}
finally {
conn.close();
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -