我是菜鸟,初学者,求jsp从javabean如何获得数据代码
下面是我的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");
}
}
}
}