我给你一个添加数据的JSP你看看
<html>
<head>
<title>添加</title></head>
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
e.printStackTrace() ;
}
return "null";
}
%>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:myku";
Connection cn=DriverManager.getConnection(url);
Statement sta=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
<%
String sql;
String id=getStr(request.getParameter("id")) ;
String name=getStr(request.getParameter("name") );
String jczl=getStr(request.getParameter("jczl")) ;
String data=getStr(request.getParameter("data"));
String jcyy=getStr(request.getParameter("jcyy")) ;
String jcpzdw=getStr(request.getParameter("jcpzdw"));
String data1=getStr(request.getParameter("data1"));
String juchuyy=getStr(request.getParameter("juchuyy")); sql="insert into familytable values('" +id + "','" + name +"','"+jczl+"','"+data+"','"+jcyy+"','"+jcpzdw+"','"+data1+"','"+juchuyy+"')";
sta.executeUpdate(sql);%>
<%
sta.close() ;
cn.close() ;%><body bgcolor="#FFFFFF" text="#000000">
<p align="center"><font size="4" color="#FF0000">数据添加成功!</font></p>
<p align="center"><font size="2"><a href="family.jsp">|继续添加| </a></font></p>
<p align="center"><font size="2"><a href="index.jsp">|返回主页|</a></font></p>
</body>
</html>
<html>
<head>
<title>添加</title></head>
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
e.printStackTrace() ;
}
return "null";
}
%>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:myku";
Connection cn=DriverManager.getConnection(url);
Statement sta=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
<%
String sql;
String id=getStr(request.getParameter("id")) ;
String name=getStr(request.getParameter("name") );
String jczl=getStr(request.getParameter("jczl")) ;
String data=getStr(request.getParameter("data"));
String jcyy=getStr(request.getParameter("jcyy")) ;
String jcpzdw=getStr(request.getParameter("jcpzdw"));
String data1=getStr(request.getParameter("data1"));
String juchuyy=getStr(request.getParameter("juchuyy")); sql="insert into familytable values('" +id + "','" + name +"','"+jczl+"','"+data+"','"+jcyy+"','"+jcpzdw+"','"+data1+"','"+juchuyy+"')";
sta.executeUpdate(sql);%>
<%
sta.close() ;
cn.close() ;%><body bgcolor="#FFFFFF" text="#000000">
<p align="center"><font size="4" color="#FF0000">数据添加成功!</font></p>
<p align="center"><font size="2"><a href="family.jsp">|继续添加| </a></font></p>
<p align="center"><font size="2"><a href="index.jsp">|返回主页|</a></font></p>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货