比较实用的连接数据库的JAVABEAN程序

package db;
import java.sql.*;
public class ConnOracle {
 /**String serverName = "localhost";
  String sDBDriver = "oracle.jdbc.driver.OracleDriver";
 String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:ora9";//连接Oracle数据库**/
 String sConnStr="jdbc:odbc:ssss";//连接SQL2000
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
 Connection connect = null;
    ResultSet rs=null;
 public ConnOracle() {
  try {
   Class.forName(sDBDriver);
  }
  catch(java.lang.ClassNotFoundException e) {
   System.err.println( e.getMessage());
  }
 }
 public ResultSet executeQuery(String sql) {
  try {
   connect = DriverManager.getConnection(sConnStr, "sa", "111");
   Statement stmt = connect.createStatement();
   rs = stmt.executeQuery(sql);
  }
  catch(SQLException ex) {
   System.err.println(ex.getMessage());
  }
  return rs;
 }
 
 public int executeUpdate(String sql) {
  int result = 0;
  try {
   connect = DriverManager.getConnection(sConnStr, "sa", "111");
   Statement stmt = connect.createStatement();
   result = stmt.executeUpdate(sql);
  }
  catch(SQLException ex) {
   System.err.println(ex.getMessage());
  }
  return result;
 }  
 
 public static void main(String args[])
 {
 
  String sql="select * from student";
  ConnOracle s=new ConnOracle();
  try
  {
   ResultSet  rs=s.executeQuery(sql);
         while(rs.next())
       {
        String id=rs.getString("studentid");
        String name=rs.getString("studentname");
        System.out.println("id是"+id+"姓名为:"+name);
       }
  }
  
   catch(Exception e)
   {
   }
  }
}
简单使用

 <% ResultSet rs=null;
  rs = connc.executeQuery("select * from student");
 try{
 while(rs.next()) { %>
    <TR>
  <TD><%=rs.getString("studentid")%></TD>
  <TD><%=rs.getString("studentname")%></TD>
  <TD><%=rs.getString("gender")%></TD>
  <TD><%=rs.getString("phone")%></TD>
 </TR>
 <%}
 rs.close();
 }
 catch(Exception e){out.println(e);};
 %>