一个纯粹在JSP 页面实现对数据增删改的例子

最新推荐文章于 2023-02-20 20:54:54 发布

iteye_7452

最新推荐文章于 2023-02-20 20:54:54 发布

阅读量297

点赞数

分类专栏：工作文章标签： JSP SQL C# C++ C

工作专栏收录该内容

15 篇文章 0 订阅

订阅专栏

xml 代码

<%@ page contentType="text/html; charset=GB2312"%>
<%@ page language="java" import="java.sql.*"%>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
function btnClick(type){
var fm=document.form1
if(type=='add'){
fm.c.value=1;
return true;
}else if(type=='edt'){
fm.c.value=2;
return true;
}else{
fm.c.value=3;
return true;
}
}
SCRIPT>
<TITLE>增加记录TITLE>
HEAD>
<BODY>
<%
Connection con = null;
Statement sql = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
out.println("连接没成功");
}
String Std_id=null;
String Std_name=null;
String Std_sex=null;
String Std_cj=null;
try {
con = DriverManager.getConnection("jdbc:odbc:LocalServer",
"exmple", "exmple");
sql = con.createStatement();
String parm = request.getParameter("c");
if(parm==null)
{
parm="";
}
String std_id=request.getParameter("std_id");
String std_name=request.getParameter("std_name");
String std_sex=request.getParameter("std_sex");
String std_cj=request.getParameter("std_cj");
if (parm.equals("1")) {
String condition = "insert into student values" + "(" + "'"
+ std_id + "','" + std_name + "','" + std_sex
+ "','" + std_cj + "')";
sql.executeUpdate(condition);
}else if (parm.equals("2")) {
String condition = "update student set std_name='"
+ std_name + "',std_sex='" + std_sex + "',std_cj='"
+ std_cj + "' where std_id='" + std_id + "'";
sql.executeUpdate(condition);
} else if(parm.equals("3")){
String condition = "delete from student where std_id='"
+ std_id + "'";
sql.executeUpdate(condition);
}else{}
rs=sql.executeQuery("select * from student order by std_id");
// rs.afterLast();
//rs.last();
while(rs.next()){
Std_id = rs.getString(1);
Std_name = rs.getString(2);
Std_sex =rs.getString(3);
Std_cj = rs.getString(4);
out.print(Std_id);
}
con.close();
} catch (SQLException e) {
}
%>
<center>
<form id="form1" name="form1" method="post">
<br>
学号:
<input type="text" name="std_id" value="" >
<br>
名字:
<input type="text" name="std_name" value="" >
<br>
性别:
<input type="text" name="std_sex" value="" >
<br>
成绩:
<input type="text" name="std_cj" value="">
<br>
<input type="hidden" name="c" id="c">
<input type="button" name="add" value="新增" onclick="btnClick('add')">
<input type="button" name="edt" value="修改" onclick="btnClick('edt')">
<input type="button" name="del" value="删除" onclick="btnClick('del')">
<input type="submit" name="save" value="保存">
</form>
</center>
</BODY>
</HTML>

iteye_7452

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
一个纯粹在JSP 页面实现对数据增删改的例子

xml 代码 &lt;%@ page contentType="text/html; charset=GB2312"%&gt; &lt;%@ page language="java" import="java.sql.*"%&gt; &lt;HTML&gt; &lt;HEAD&gt;
复制链接

扫一扫

专栏目录