PrepareStatement ps = con.prepareStatement("insert into xxxtable value(?,?,?));
ps.setInt(1,id);
ps.setString(2,desc);
ps.setString(3,name);
int recordCount = ps.executeQuery();
这样就可以了!
ps.setInt(1,id);
ps.setString(2,desc);
ps.setString(3,name);
int recordCount = ps.executeQuery();
这样就可以了!
ResultSet rst = roleList.executeQuery(str);
rst.moveToInsertRow();
// rst.updateInt("¹ã¸æID",adID);
rst.updateInt("λÖÃID",placeID);
rst.updateInt("¿Í»§ID",customerID);
rst.updateString("ÀàÐÍ",leixing);
rst.updateString("ÎļþÃû",filename);
rst.updateString("Á´½Ó",lianjie);
rst.updateString("¹Ø¼ü×Ö",keyword);
rst.updateInt("Ͷ·Å",toufang);
rst.updateString("Æðʼʱ¼ä",StartTime);
rst.updateString("½áÊøʱ¼ä",EndTime);
rst.updateInt("ÏÔʾÊý",showTimes);
rst.updateInt("µã»÷Êý",hits);
rst.updateString("λÖñê¼Ç",placeMark);
rst.updateString("λÖóߴç",placeSize); //rst.updateDate("StartTime",StartTime);
rst.insertRow();
<%@ page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="gkgl.database.LinkSQL"/>
<jsp:useBean id="jsp" scope="page" class="gkgl.include.OutString"></jsp:useBean>
<html><head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
String strId = request.getParameter("id");
String strgkyydm = request.getParameter("gkyydm");
String strgkyymc = request.getParameter("gkyymc");
String strswyydm = request.getParameter("swyydm");
String strswyymc = request.getParameter("swyymc");boolean bolZt=false;
String strSql="";if (strId.length()==0) {
strSql="insert into dm_tkyy (gkyy_dm,gkyy_mc,swyy_dm,swyy_mc) values('"+strgkyydm+"','"+jsp.reconvert(strgkyymc)+"','"+strswyydm+"','"+jsp.reconvert(strswyymc)+"')";
}else{
strSql="update dm_tkyy set gkyy_dm='" + strgkyydm + "',gkyy_mc='" + jsp.reconvert(strgkyymc) + "',swyy_dm='" + strswyydm + "',swyy_mc='" + jsp.reconvert(strswyymc) + "' where rowid='" + strId+"'";
}
//out.println(strSql);
bolZt=conn.execute(strSql);
conn.close();
if (bolZt) {
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
alert('操作成功');
parent.window.form1.ok.disabled=false;
parent.window.form1.ok.value='添 加';
parent.window.form1.reset();
self.location.replace('tkyy_bgload.jsp');
//-->
</SCRIPT>
<%
}else{
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
alert('操作失败');
parent.window.form1.ok.disabled=false;
//-->
</SCRIPT>
<%
}
%>
<SCRIPT LANGUAGE="JavaScript">
<!--
window.location.replace('about:blank');
//-->
</SCRIPT>
</BODY>
</HTML>
在这儿讲也讲不清楚。
很容易的。