这样改一下:
<% try {
Class.forName(CLASSFORNAME);
Connection con = DriverManager.getConnection(SERVANDDB,USER,PWD);
Statement statement=con.createStatement();
session.setAttribute("textfield",request.getParameter("textfield"));
session.setAttribute("textfield2",request.getParameter("textfield2"));
session.setAttribute("textfield3",request.getParameter("textfield3"));
session.setAttribute("textfield4",request.getParameter("textfield4"));
java.util.Date date=new java.util.Date();
String sqltime=new Timestamp(date.getTime()).toString();
String sqlstr=
"INSERT INTO web_moto_rate (from_date,to_date,rate,add_date,update_date) VALUES ("+"'"+textfield+"','"+textfield2+"','"+textfield3+"','"+textfield4+"','"+sqltime+"')"
try {
statement.execute(sqlstr);
statement.close();
out.print("insert ok...");
}
catch (Exception ex) {
ex.printStackTrace();
}
//pstmt.close();
con.close();
%>
<% try {
Class.forName(CLASSFORNAME);
Connection con = DriverManager.getConnection(SERVANDDB,USER,PWD);
Statement statement=con.createStatement();
session.setAttribute("textfield",request.getParameter("textfield"));
session.setAttribute("textfield2",request.getParameter("textfield2"));
session.setAttribute("textfield3",request.getParameter("textfield3"));
session.setAttribute("textfield4",request.getParameter("textfield4"));
java.util.Date date=new java.util.Date();
String sqltime=new Timestamp(date.getTime()).toString();
String sqlstr=
"INSERT INTO web_moto_rate (from_date,to_date,rate,add_date,update_date) VALUES ("+"'"+textfield+"','"+textfield2+"','"+textfield3+"','"+textfield4+"','"+sqltime+"')"
try {
statement.execute(sqlstr);
statement.close();
out.print("insert ok...");
}
catch (Exception ex) {
ex.printStackTrace();
}
//pstmt.close();
con.close();
%>
C:\Tomcat 5.0\work\Catalina\localhost\ODS_PEK\org\apache\jsp\rate\insert_005fdo_jsp.java:91: cannot resolve symbol
symbol : variable textfield
location: class org.apache.jsp.rate.insert_005fdo_jsp
String sqlstr="INSERT INTO web_moto_rate (from_date,to_date,rate,add_date,update_date) VALUES ("+"'"+textfield+"','"+"textfield2"+"','"+"textfield3"+"','"+"textfield4"+"','"+sqltime+"')";
句中'textfield','textfield2','textfield3','textfield4','sqltime'是什么?
你得先从session中取值啊
如:String s=session.getAttribute("textfield");
Date textfield=new Date(Long.parseLong(s));
出来是什么值,为空吗????
stat1.setString(1,userName);
stat1.setString(2,pwd);
stat1.execute();
看清楚没?
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
conn.commit();
其中executeUpdate(sql)这个才是更新操作的函数,包括insert和delete
然后要用conn.commit()进行更新库。