sql.research源代码:
package sql;
import java.sql.*;
public class research
{
String url="jdbc:odbc:research";
Connection con=null;
public research()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("create():"+e.getMessage());
}
catch(SQLException e)
{
System.err.println("something error");
}
}
public boolean executeUpdate(String sql)
{
try
{
Statement stmt;
stmt=con.createStatement();
stmt.executeUpdate(sql);
return true;
}
catch(SQLException e)
{
System.err.println("aq.executeUpdate:"+e.getMessage());
}
return false;
}
public ResultSet executeQuery(String sql)
{
ResultSet rs=null;
try
{
Statement stmt;
stmt=con.createStatement();
rs=stmt.executeQuery(sql); }
catch(SQLException e)
{
System.err.println("aq.executeUpdate:"+e.getMessage());
}
return rs;
}
public void close()
{
try
{
con.close();
}
catch(Exception e)
{
System.out.println(e.toString());
}
}}
package sql;
import java.sql.*;
public class research
{
String url="jdbc:odbc:research";
Connection con=null;
public research()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("create():"+e.getMessage());
}
catch(SQLException e)
{
System.err.println("something error");
}
}
public boolean executeUpdate(String sql)
{
try
{
Statement stmt;
stmt=con.createStatement();
stmt.executeUpdate(sql);
return true;
}
catch(SQLException e)
{
System.err.println("aq.executeUpdate:"+e.getMessage());
}
return false;
}
public ResultSet executeQuery(String sql)
{
ResultSet rs=null;
try
{
Statement stmt;
stmt=con.createStatement();
rs=stmt.executeQuery(sql); }
catch(SQLException e)
{
System.err.println("aq.executeUpdate:"+e.getMessage());
}
return rs;
}
public void close()
{
try
{
con.close();
}
catch(Exception e)
{
System.out.println(e.toString());
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货