网页显示mysql数据库到表格数据_在网页中如何将数据库的数据显示出来

你要有一个jsp页面，你可以查下jsp怎么连接对应数据库

编写连接数据库的程序，以下是jsp连接oracle程序

---

Connection conn = null;

PreparedStatement stmt = null;

ResultSet rs = null;

request.setCharacterEncoding("GBK");

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

}

catch(ClassNotFoundException ce){

out.println(ce.getMessage());

}

try{

String url="jdbc:oracle:thin:@localhost:1521:orcl";

conn=DriverManager.getConnection(url,"scott","tiger");

stmt=conn.prepareStatement("select * from emp");

rs=stmt.executeQuery();

out.print("

out.print("

"+" Empno"+"");

out.print("

"+" Ename"+"");

out.print("

"+" Job"+"");

out.print("

"+" Mgr"+"");

out.print("

"+" hiredate"+"");

out.print("

"+" Sal"+"");

out.print("

"+" Comm"+"");

out.print("

"+" Deptno"+"");

while(rs.next()){

out.print("

"+rs.getString(1)+"");

out.print("

"+rs.getString(2)+"");

out.print("

"+rs.getString(3)+"");

out.print("

"+rs.getString(4)+"");

out.print("

"+rs.getString(5)+"");

out.print("

"+rs.getString(6)+"");

out.print("

"+rs.getString(7)+"");

out.print("

"+rs.getString(8)+"");

}

out.print("

");

rs.close();

stmt.close();

conn.close();

}

catch(Exception e){

System.out.println(e.getMessage());

}

%>