|
JSP实现留言板的JavaBean类和分页显示的源码(2) String connectionUrl="jdbc:mysql://localhost/"+dbName; try{ Class.forName("org.gjt.mm.mysql.Driver"); connection=DriverManager.getConnection(connectionUrl,dbUser,dbPass); } catch(Exception e){ System.out.println(e.toString()); } } public void dbQueryMemos(){ try{ memoVector=new Vector(); Statement stmt=connection.createStatement(); ResultSet rs=stmt.executeQuery("select * from memo;"); while(rs.next()){ memoBean temp=new memoBean(); temp.setId(rs.getString(2)); temp.setEmail(rs.getString(3)); temp.setContent(rs.getString(4)); memoVector.add(temp); } } catch(SQLException e){ System.out.println(e.toString()); } }
public void setDbName(String s){ this.dbName=s; } public void setDbUser(String s){ this.dbUser=s; } public void setDbPass(String s){ this.dbPass=s; } public String getDbName(){ return this.dbName; } public String getDbUser(){ return this.dbUser; } public String getDbPass(){ return this.dbPass; } public Vector getMemoVector(){
|