jsp里的数据库问题??
mysam 2003-10-17 01:45:53 我写了一个页面,
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@222.222.122.22:12f";
//orcl为你的数据库的SID
String user="11";
String password="11";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
int wdxh=20012976;
String sql="select * from STU WHERE STUID='"+wdxh+"'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
//在这里得到值后,再去另一数据表查值时报错,比如:
String depart=rs.getString("department");
out.println(depart);
//去另一表取信息,两个表在同一数据库下,是Oracle库
String depart_sql="select * from 另一数据库名字 WHERE 字段='"+depart+"'";
ResultSet depart_rs=stmt.executeQuery(depart_sql);
while(depart_rs.next())
{
String departwd=(depart_rs.getString("department"));
out.println("departwd");
}
}%>
我以前学的是PHP,经常这样写,可是在JSP里却不行???
请教高手帮忙!