(3)编写JAVABEAN:DBBean.java
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;
public class DBBean
{
public static void main(String args[]){
Connection conn=null;
Statement stmt=null;
ResultSet rst=null;
System.out.println("hello");
}
public DBBean()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(""+e);
}
}
public ResultSet executeQuery(String sql)
{
ResultSet rst=null;
try
{
System.out.println("jdbc:odbc:myweb");
Connection conn=DriverManager.getConnection("jdbc:odbc:myweb","sa","") ;
Statement stmt=conn.createStatement();
rst=stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.out.println(""+ex);
}
return rst;
}
public int executeUpdate(String sql)
{
int result=0;
try
{
Connection conn=DriverManager.getConnection("jdbc:odbc:myweb","sa","") ;
Statement stmt=conn.createStatement();
ResultSet rst=stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.out.println(""+ex);
}
return result;
}
public void close()
{
Connection conn=null;
Statement stmt=null;
ResultSet rst=null;
try{ rst.close();
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.out.println(""+ex.getMessage());
}
}
}