一个简单的orcale查询问题 WHEREselect * from table WHERE name =?? AND age= AND .... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我的sql代码倒是知道"select * from table_name where id="+sid; sid是外部传进来的. public class A{ private String str; public void setStr(String str){ ResultSet set = stat.executeQuery("select * from table where name ="+str); while(set.next()){ this.str = set.getString("sid"))+set.getString("name"))+set.getString("age")); } public String toString(){ return str; }} Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@192.168.0.1:1521:ora9i","scott","123"); Statement stat = conn.createStatement(); A a = new A().setStr(name); System.out.println(a);//是不是要这种效果 写出来了.可惜还是有点问题.public Student QueryStudentById(int sid) { Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; // 1.获取sid, // 2.从库中取出其中一个符合条件的对象; // 3.返回此对象; Student student = new Student(); StringBuilder sql = new StringBuilder(); sql.append(" select sid,sname,major,score,birth from student where id=" + sid); try { pstmt = con.prepareStatement(sql.toString()); rs = pstmt.executeQuery(sql.toString()); if (rs.next()) { student.setSid(rs.getInt(1)); student.setSname(rs.getString(2)); student.setMajor(rs.getString(3)); student.setScore(rs.getFloat(4)); } } catch (SQLException e) { e.printStackTrace(); } System.out.println(student.getSid() + student.getSname()); return student; } public static void main(String ar[]) { StudentDAO sd = new StudentDAO(); System.out.println(sd.QueryStudentById(2).getSname()); }} Java获取163、QQ邮箱联系人列表(在控制台打印出来) struts2在启动的时候跟请求的时候会发出警告,怎么回事? hibernate的NamingStrategy能在配置文件中配置么 java 变量名称的问题 SSH整合出现问题 Hibernate单向一对多怎么自定义中间表 发现j2ee高手QQ群:13269894 高手进。新手,不常在线者,学生莫入 配置好JDBC,在EJB中通过JNDI如何连接到数据库? 这是什么问题?cmp 请问各位J2EE是JAVA 2 企业版,是指?? 【求助】一个循环中的Update死锁问题 如何取得mail服务器上的原始mail文件的文件名
sid是外部传进来的.
private String str;
public void setStr(String str){
ResultSet set = stat.executeQuery("select * from table where name ="+str);
while(set.next()){
this.str = set.getString("sid"))+set.getString("name"))+set.getString("age"));
} public String toString(){
return str;
}
}
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@192.168.0.1:1521:ora9i","scott","123");
Statement stat = conn.createStatement();
A a = new A().setStr(name);
System.out.println(a);
//是不是要这种效果
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null; // 1.获取sid,
// 2.从库中取出其中一个符合条件的对象;
// 3.返回此对象;
Student student = new Student();
StringBuilder sql = new StringBuilder();
sql.append(" select sid,sname,major,score,birth from student where id="
+ sid);
try {
pstmt = con.prepareStatement(sql.toString());
rs = pstmt.executeQuery(sql.toString());
if (rs.next()) {
student.setSid(rs.getInt(1));
student.setSname(rs.getString(2));
student.setMajor(rs.getString(3));
student.setScore(rs.getFloat(4));
} } catch (SQLException e) {
e.printStackTrace();
}
System.out.println(student.getSid() + student.getSname()); return student; } public static void main(String ar[]) {
StudentDAO sd = new StudentDAO();
System.out.println(sd.QueryStudentById(2).getSname());
}}