JSP list集合 用脚本直接插入的话把每一条记录当成一个数组 把每个数组保存在list中循环插入 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 先把信息放到javabean中,然后再放到list中去。 谢谢楼上的回答,本人刚刚学习JSP,请问在JSP中怎么实现啊? 你会JDBC吗?这五条数据,封装个Bean中,然后添加到List中。最后遍历list,循环添加到数据库就行了! 可以写5条insert,以分号隔开,执行以下就可以了。不过要写在事务里面 将数据库的数据查询出来放在javabean中,而后添加到集合中,在页面循环显示数据。 给你贴代码jsp 的 数据库连接 你自己改下吧 我随便写个odbc的 表的字段名和 类里的属性名称是一样的<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><%@page import="java.sql.Connection"%><%@page import="java.sql.DriverManager"%><%@page import="java.util.List"%><%@page import="dd.bean"%><%@page import="java.util.ArrayList"%><%@page import="java.sql.PreparedStatement"%><%@page import="java.sql.Statement"%><html><head><title>Insert title here</title><script type="text/javascript" src="js/jquery-142min.js"></script><script></script></head><body><% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:jia"; String user="sa"; String pass="sa123"; Connection con=DriverManager.getConnection(url,user,pass); System.out.println("连接数据库成功........."); Statement s=con.createStatement(); bean b = new bean(); int[] id = {1,2,3,4}; String[] uname ={"张三","李四","王五","赵六"}; String[] tel = {"88888888","88888888","88888888","88888888"}; String[] addres = {"广东广州","广东广州","广东广州","广东广州"}; int[] postal_code = {50000,50000,50000,50000}; List list = null; String sql = ""; for(int i = 0;i < 4;i++){ list = new ArrayList(); b.setId(id[i]); b.setUname(uname[i]); b.setTel(tel[i]); b.setAddres(addres[i]); b.setPostal_code(postal_code[i]); sql="insert into reg values("+b.getId()+",'"+b.getUname()+"','"+b.getTel()+"','"+b.getAddres()+"',"+b.getPostal_code()+")"; System.out.println(sql); s.executeUpdate(sql); } s.close(); con.close();%></body></html>bean类 在dd包下:package dd;public class bean { public int id; public String uname; public String tel ; public String addres ; public int postal_code ; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUname() { return uname; } public void setUname(String uname) { this.uname = uname; } public String getTel() { return tel; } public void setTel(String tel) { this.tel = tel; } public String getAddres() { return addres; } public void setAddres(String addres) { this.addres = addres; } public int getPostal_code() { return postal_code; } public void setPostal_code(int postalCode) { postal_code = postalCode; } } 如果有看不懂的加我qq632167558 小弟我也是菜鸟一个写的代码很一般 应该没问题我测试了 ie 火狐 对cookie的影响 jsp mail发送问题 struts2中action如何重新初始化? 谁用过cajo,小弟找不到他的下载连接,如能帮忙50分送上。谢谢! 学习Spring的小小心得(重新整理版) myeclipse中我把项目重编译了一下,再启动的时候就报错了,请各位牛人帮忙看下,多谢。 跪求高手帮助 JBoss在安装配置时后运行出现问题,请进来指点!谢谢! jb9中连接数据库sql server2000(struts1.1) 请高手指正一段Struts代码,编译通过,但不能显示 请教Java的基础知识,详细点!谢谢! ms sql 和sql server 有什么联系?
你会JDBC吗?这五条数据,封装个Bean中,然后添加到List中。最后遍历list,循环添加到数据库就行了!
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%><%@page import="java.util.List"%>
<%@page import="dd.bean"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Statement"%><html>
<head>
<title>Insert title here</title>
<script type="text/javascript" src="js/jquery-142min.js"></script>
<script>
</script>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jia";
String user="sa";
String pass="sa123";
Connection con=DriverManager.getConnection(url,user,pass);
System.out.println("连接数据库成功.........");
Statement s=con.createStatement();
bean b = new bean();
int[] id = {1,2,3,4};
String[] uname ={"张三","李四","王五","赵六"};
String[] tel = {"88888888","88888888","88888888","88888888"};
String[] addres = {"广东广州","广东广州","广东广州","广东广州"};
int[] postal_code = {50000,50000,50000,50000};
List list = null;
String sql = "";
for(int i = 0;i < 4;i++){
list = new ArrayList();
b.setId(id[i]);
b.setUname(uname[i]);
b.setTel(tel[i]);
b.setAddres(addres[i]);
b.setPostal_code(postal_code[i]);
sql="insert into reg values("+b.getId()+",'"+b.getUname()+"','"+b.getTel()+"','"+b.getAddres()+"',"+b.getPostal_code()+")";
System.out.println(sql);
s.executeUpdate(sql);
}
s.close();
con.close();
%>
</body>
</html>
bean类 在dd包下:package dd;public class bean {
public int id;
public String uname;
public String tel ;
public String addres ;
public int postal_code ; public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getUname() {
return uname;
} public void setUname(String uname) {
this.uname = uname;
} public String getTel() {
return tel;
} public void setTel(String tel) {
this.tel = tel;
} public String getAddres() {
return addres;
} public void setAddres(String addres) {
this.addres = addres;
} public int getPostal_code() {
return postal_code;
} public void setPostal_code(int postalCode) {
postal_code = postalCode;
}
}
如果有看不懂的加我qq632167558 小弟我也是菜鸟一个写的代码很一般 应该没问题我测试了