Question

在jsp里面，怎么获取数据库里面的值

如题

Answer 1

<% Connection conn=null; Statement sqlStmt=null; ResultSet rs=null; try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=XXX;Password=XXX;DatabaseName=web"); sqlStmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); } catch(Exception e) { System.err.println(e.getMessage()); } String sql="select * from Table where typeid=1"; try { rs=sqlStmt.executeQuery(sql); while(rs.next()) { //输出一下内容 out.print(rs.getString("")); out.print(rs.getString("")); } } catch(Exception ex) { System.err.println(ex.getMessage()); } %>

Answer 2

rs.getString("字段名");