you should get 2 db connections
解决方案 »
- servlet中,请问怎样输出一个有链接的文字,连到jsp页面里,这样写错在哪里?
- sql查询
- 问问问!!!!!
- 将数据从JSP的JAVA程序段中传送到JAVAScript中
- 请教一段jsp文件代码?(急)
- 在javabean中访问oracle的问题:java.sql.SQLException: 无效的列索引?
- 老板让做一个中英文的网站,要用一份code,请各路高手给点思路~~~~~~~~~~~~
- 請教一個Expression Language與格式化的問題
- 搞不懂!!怎么理解这些单引号得意义呢
- tomcat配置两个端口,每个端口指向不同的页面!
- jsp中如何实现打印功能?
- 如何将int 转换成String
String title;
String content;
String post_date;
String sqlList;
ResultSet rs;
%>
<%
sqlList="select * from bbs";
rs=stm.executeQuery(sqlList);
while(rs.next()){
%>
<%
String thisuser=rs.getString("username");
String sql="select * from users where username='"+thisuser+"'";
//out.print(sql);
ResultSet rs2;
rs2=stm.executeQuery(sql);
while(rs2.next()){
out.print(rs2.getString("username"));
}
%>
<b>Username</b>:<%
out.print(rs.getString("username")+"<br>");
%>
<b>Title</b>: <%
out.print(rs.getString("title")+"<br>");
%>
<b>Content</b>: <%
out.print(rs.getString("content")+"<br>");
%>
<b>Date</b>: <%
out.print(rs.getString("post_date")+"<br>"); %>
<hr>
<%
}
%>
一个查询bbs表
一个查询user表
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection connection =
java.sql.DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=sa"); java.sql.Statement statement = connection.createStatement();
java.sql.ResultSet resultSet =
statement.executeQuery("use LC SELECT * FROM teacherinfo"); java.sql.Statement statementb1 = connection.createStatement();
java.sql.Statement statementc1 = connection.createStatement(); java.sql.ResultSet resultSetb1, resultSetc1; while (resultSet.next()) {
resultSetb1 =
statementb1.executeQuery(
"use LC SELECT * FROM teachertitle where titlenum='"
+ resultSet.getString("teachertitlenum").trim()
+ "'");
resultSetc1 =
statementc1.executeQuery(
"use LC SELECT * FROM collegeinfo where collegenum='"
+ resultSet.getString("collegenum").trim()
+ "'"); out.println(
"<TR><TD align=center><INPUT type=checkbox name=checkbox value=on>"
+ "</TD><TD align=center>");
out.println(resultSet.getString("teachernum") + "</TD><TD align=center>");
out.println(resultSet.getString("teachername") + "</TD><TD align=center>");
out.println(resultSet.getString("sex") + "</TD>");
out.println("<TD align=center>");
while (resultSetb1.next()) {
out.println(resultSetb1.getString("titlename"));
break;
}
out.println("</TD>");
out.println("<TD align=center>");
while (resultSetc1.next()) {
out.println(resultSetc1.getString("collegename"));
break;
}
out.println("</TD></TR>");
}
System.out.println("数据库连接成功!");
} catch (Throwable e) {
out.println("<font color=red>读取数据库中出错!</font>");
}
String title;
String content;
String post_date;
String sqlList;
ResultSet rs;
ResultSet rs2;
Statement stm2=null;
stm2=conn.createStatement();//for rs2
sqlList="select * from bbs";
rs=stm.executeQuery(sqlList);
while(rs.next()){ String thisuser=rs.getString("username");
String sql="select * from users where username='"+thisuser+"'";
//out.print(sql);
rs2=stm2.executeQuery(sql);
while(rs2.next()){
out.print(rs2.getString("username"));
}
%>
<b>Username</b>:<%
out.print(rs.getString("username")+"<br>");
%>
<b>Title</b>: <%
out.print(rs.getString("title")+"<br>");
%>
<b>Content</b>: <%
out.print(rs.getString("content")+"<br>");
%>
<b>Date</b>: <%
out.print(rs.getString("post_date")+"<br>"); %>
<hr>
<%
}
%>
也就是前面所说的定义两个statement和 resultset
最最感谢“xfounder(红色高棉) ”