我是菜鸟,初学者,求jsp从javabean如何获得数据代码

bingquan2646 2006-05-23 05:09:35
下面是我的javabean代码
package sciencedata.Person;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
import org.apache.struts.action.*;
import javax.servlet.http.*;
import java.io.IOException;
import javax.servlet.ServletException;


public class Person1Action extends Action {
public ActionForward execute(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) throws IOException,
ServletException{
/**@todo: complete the business logic here, this is just a skeleton.*/
PersonForm personform = (PersonForm) form;

String b_date=personform.getB_date();
String d_identity=personform.getD_identity();
String degree=personform.getDegree();
String e_mail=personform.getE_mail();
String f_language=personform.getF_language();
String g_school=personform.getG_school();
String g_time=personform.getG_time();
String mobile=personform.getMobile();
String p_note=personform.getP_note();
String phone=personform.getPhone();
String post=personform.getPost();
String qq=personform.getQq();
String sect=personform.getSect();
String sex=personform.getSex();
String t_id=personform.getT_id();
String t_name=personform.getT_name();
String x_ray=personform.getX_ray();

System.out.println("t_id============"+t_id);
System.out.println("t_name============"+t_name);

Connection conn = null;
ResultSet rs;
int result = 0;
String sqlstr = "";

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url = "jdbc:odbc:lj";
conn = DriverManager.getConnection(url);

//DatabaseMetaData dbMetaData=conn.getMetaData();

Statement stmt = conn.createStatement();

System.out.println("t_id============"+t_id);

//if (!t_id.equals(null) && t_name.equals(null))
// sqlstr = "select * from [person] where" + " t_id=" +"'" + t_id+"'";
//else if(!t_name.equals(null) && t_id.equals(null))
//sqlstr = "select t_id from [person] where" + " and t_name="+"'"+t_name+"'";
//else
if(!t_id.equals(null) && !t_name.equals(null))
sqlstr = "select * from [person] where" + " t_id=" +"'"+ t_id+"'"
+ " and t_name= "+ "'"+t_name+"'";

System.out.println(sqlstr);

rs = stmt.executeQuery(sqlstr);

System.out.println(sqlstr);

//ResultSetMetaData resultSetMetaData=rs.getMetaData();
//int column=resultSetMetaData.getColumnCount();
if(rs.next()) {
t_id = rs.getString("t_id");

System.out.println("0");

t_name = rs.getString("t_name");

System.out.println("01");

sex=rs.getString("sex");

System.out.println("1");

d_identity = rs.getString("d_identity");

System.out.println("2");

post=rs.getString("post");

System.out.println("3");

degree=rs.getString("degree");

System.out.println("4");

x_ray=rs.getString("x_ray");

System.out.println("5");

g_school=rs.getString("g_school");

System.out.println("6");

g_time=rs.getString("g_time");

System.out.println("7");

f_language=rs.getString("f_language");

System.out.println("8");

mobile=rs.getString("mobile");

System.out.println("9");

phone=rs.getString("phone");

System.out.println("10");

qq=rs.getString("qq");

System.out.println("11");

e_mail=rs.getString("e_mail");

System.out.println("12");

p_note=rs.getString("p_note");

System.out.println("13");

b_date=rs.getString("b_date");

System.out.println("14");

sect=rs.getString("sect");

System.out.println("15");

personform.setT_id(t_id);
personform.setT_name(t_name);
personform.setSex(sex);
personform.setB_date(b_date);
personform.setD_identity(d_identity);
personform.setSect(sect);
personform.setPost(post);
personform.setDegree(degree);
personform.setX_ray(x_ray);
personform.setG_school(g_school);
personform.setG_time(g_time);
personform.setF_language(f_language);
personform.setMobile(mobile);
personform.setPhone(phone);
personform.setQq(qq);
personform.setE_mail(e_mail);
personform.setP_note(p_note);

System.out.println("t_id:" + t_id);
System.out.println("t_name:" + t_name);
System.out.println("sex:" + sex);
System.out.println("b_date:" + b_date);
System.out.println("d_identity:" + d_identity);
System.out.println("sect:" + sect);
System.out.println("post:" + post);
System.out.println("degree:" + degree);
System.out.println("x_ray:" + x_ray);
System.out.println("g_school:" + g_school);
System.out.println("g_time:" + g_time);
System.out.println("f_language:" + f_language);
System.out.println("mobile:" + mobile);
System.out.println("phone:" + phone);
System.out.println("qq:" + qq);
System.out.println("e_mail:" + e_mail);
System.out.println("p_note:" + p_note);

}
else result = 1;
}
catch (ClassNotFoundException e) {
result = 1;
System.err.println(e.getMessage());
}
catch (SQLException e) {
result = 1;
System.err.println(e.getMessage());
}
finally {
try {
if (conn != null)
conn.close();
}
catch (Exception e) {
result = 1;
System.out.println(e.toString());
}
if (result == 0) {
return mapping.findForward("successed");
}
else {
return mapping.findForward("failed");
}
}
}
}
...全文
105 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
johnhzjx 2006-05-25
  • 打赏
  • 举报
回复
我用的是struts架构,仁兄可以加具体点吗
如何传入request,session怎么获取阿
额是菜鸟级了

那最好从网络和书上先学起....还有就是借鉴已有的代码或则看他人的例子
lixin1020 2006-05-24
  • 打赏
  • 举报
回复
session.setAttribute("loginName",loginName); 送给下个页面值
欢迎<%=session.getAttribute("loginName")%>可以在另个页面取值
bingquan2646 2006-05-24
  • 打赏
  • 举报
回复
我用的是struts架构,仁兄可以加具体点吗
如何传入request,session怎么获取阿
额是菜鸟级了
johnhzjx 2006-05-23
  • 打赏
  • 举报
回复
你应该也用到一些类似SPRING的MVC架构.
if (result == 0) {
return mapping.findForward("successed");
}
else {
return mapping.findForward("failed");
}

你可以传入request,那你可以直接把你的personform set到SESSION中后,在页面上直接通过SESSION GET出来,然后用(personform ) 去实例,再一个个取出对应的.get();

81,116

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧