大家来讨论一下怎么修改整张表? 噢,请原谅我没有说清楚,我的意思是:已经在jsp页面上显示了一张表出来,所有的数据项都是用text形式的,都可以修改。问题是:修改完之后怎么将数据项提交回数据库的表里面?我想到的方法很笨,希望有简单实用一点的方法。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 提交时还是只能交个另一个jsp文件处理,然后在那里逐个得到text项的值,然后连接数据库,存入就行了啊! 恩只能用手写的多条插入 给你个例子做参考//---------------- Insert/Update 操作 -------------------------------// 连接数据的信息 String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null; MM_editDriver = MM_carmanager_DRIVER; MM_editConnection = MM_carmanager_STRING; MM_editUserName = MM_carmanager_USERNAME; MM_editPassword = MM_carmanager_PASSWORD;// out.print(" SQL语句 "); //-->做调试用,查看SQL语句书写是否正确 Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance(); Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);// 在这里输入SQL执行 PreparedStatement MM_editStatement = MM_connection.prepareStatement(" SQL语句 "); MM_editStatement.executeUpdate();//插入多表,重复写上面二条语句 MM_connection.close();// 对数据库操作成功后要转向的页面 response.sendRedirect("../../../public/msg.jsp?msg="+"Success...");//--------------------- 事务 ------------------------------------------// 连接数据的信息try{ String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null; MM_editDriver = MM_dbmain_DRIVER; MM_editConnection = MM_dbmain_STRING; MM_editUserName = MM_dbmain_USERNAME; MM_editPassword = MM_dbmain_PASSWORD; Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance(); Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword); //事务开始 MM_connection.setAutoCommit(false); String mysql1=""; //要执行的SQL语句 String mysql2=""; //要执行的SQL语句 //执行第一条语句 PreparedStatement Statementd1 = MM_connection.prepareStatement(mysql1); ResultSet ds = Statementd1.executeQuery(); //执行第二条语句 PreparedStatement Statementd2 = MM_connection.prepareStatement(mysql2); Statementd2.executeUpdate(); //提交 MM_connection.commit(); //置回自动提交模式 MM_connection.setAutoCommit(true); //关闭数据集连接等 ds.close(); Statementd1.close(); Statementd2.close(); MM_connection.close();}catch(Exception x){ //错误处理out.print(x.toString());return;}// 对数据库操作成功后要转向的页面 String tmp="index.jsp?"; String msg="../../public/msg.jsp?msg=填加成功!&toURL="+tmp; msg=new String(tmp.getBytes("gb2312"),"iso8859-1"); response.sendRedirect(msg); //-----------------------------------------------------------------------------------------------//---------------- 中文显示 -------------------------------------String msg=new String("../../../public/msg.jsp?msg=您没有登陆".getBytes("gb2312"),"iso8859-1");//--------------------------------------------------------------- 假如你真的是以text形式显示的只有记住 各自name 然后提交另一个jsp 处理存储问题 to: zhangfan790913(笑月) 请问这个循环i的具体用法是.....? 请教正则表达式的问题~正则表达式达人请进 关于对数据排名问题! 急求javamail发送邮件的问题 关于用JSP做权限判断的问题 救命啊!java.exe占用cpu100%,weblogic启动不能! 急!如何在jsp中实现把大图片转换成小图片? 高分求教 关于参数传递出现的错误? 如何能不动用数据库,做一个简单的聊天室?用jsp加tomcat。 求解答!服务器尚未找到与请求的 URI (统一资源标识符)匹配的任何内容 JSP网站中,如何将图像插入数据库,又如何查询图像?(求救) 两个小问题!大家来看看啊!
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;
MM_editDriver = MM_carmanager_DRIVER;
MM_editConnection = MM_carmanager_STRING;
MM_editUserName = MM_carmanager_USERNAME;
MM_editPassword = MM_carmanager_PASSWORD;// out.print(" SQL语句 "); //-->做调试用,查看SQL语句书写是否正确
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);// 在这里输入SQL执行
PreparedStatement MM_editStatement = MM_connection.prepareStatement(" SQL语句 ");
MM_editStatement.executeUpdate();//插入多表,重复写上面二条语句
MM_connection.close();
// 对数据库操作成功后要转向的页面
response.sendRedirect("../../../public/msg.jsp?msg="+"Success...");//--------------------- 事务 ------------------------------------------
// 连接数据的信息
try
{
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;
MM_editDriver = MM_dbmain_DRIVER;
MM_editConnection = MM_dbmain_STRING;
MM_editUserName = MM_dbmain_USERNAME;
MM_editPassword = MM_dbmain_PASSWORD;
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword); //事务开始
MM_connection.setAutoCommit(false);
String mysql1=""; //要执行的SQL语句
String mysql2=""; //要执行的SQL语句
//执行第一条语句
PreparedStatement Statementd1 = MM_connection.prepareStatement(mysql1);
ResultSet ds = Statementd1.executeQuery();
//执行第二条语句
PreparedStatement Statementd2 = MM_connection.prepareStatement(mysql2);
Statementd2.executeUpdate();
//提交
MM_connection.commit();
//置回自动提交模式
MM_connection.setAutoCommit(true);
//关闭数据集连接等
ds.close();
Statementd1.close();
Statementd2.close();
MM_connection.close();
}
catch(Exception x)
{
//错误处理
out.print(x.toString());
return;
}// 对数据库操作成功后要转向的页面
String tmp="index.jsp?";
String msg="../../public/msg.jsp?msg=填加成功!&toURL="+tmp;
msg=new String(tmp.getBytes("gb2312"),"iso8859-1");
response.sendRedirect(msg);
//-----------------------------------------------------------------------------------------------//---------------- 中文显示 -------------------------------------
String msg=new String("../../../public/msg.jsp?msg=您没有登陆".getBytes("gb2312"),"iso8859-1");
//---------------------------------------------------------------
只有记住 各自name
然后提交另一个jsp 处理存储问题
请问这个循环i的具体用法是.....?