1.jdbc连接数据库要添加mysql-connector-java-5.1.38-bin.jar库2.odbc连接数据库要添加odbc数据源3.测试代码DBHelper.java代码jdbc连接数据库import java.beans.Statement;import java.sql.DriverManager;import com.mysql.jdbc.Connection;import com.mysql.jdbc.PreparedStatement;import com.sun.jndi.url.corbaname.corbanameURLContextFactory;public class DBHelper {public final String url = "jdbc:mysql://127.0.0.1:3306/School?useUnicode=true&characterEncoding=GBK";public final String username = "root";//用户名public final String name = "com.mysql.jdbc.Driver";public final String pswd = null;//密码public Connection conn = null;//连接public PreparedStatement pst = null;//准备执行的sql语句public DBHelper(String sql) {try {Class.forName(name);conn = (Connection) DriverManager.getConnection(url, username, pswd);pst = (PreparedStatement) conn.prepareStatement(sql);System.out.println("jdbc链接数据库");} catch (Exception e) {System.out.println("加载驱动失败" + e.toString());}}public PreparedStatement DBQ() {return pst;}public void CloseDB() {try {conn.close();pst.close();} catch (Exception e) {System.out.println("出现异常");}}}DBHelper1.java代码，ODBC连接数据库import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;public class DBHelper1 {public final String url="jdbc:odbc:TEST";public final String name = "root";public final String psd = null;public final String name1 = "sun.jdbc.odbc.JdbcOdbcDriver";public Connection conn1 = null;public PreparedStatement pst = null;public DBHelper1(String sql) {try {Class.forName(name1);conn1 = (Connection) DriverManager.getConnection(url,name, psd);pst = (PreparedStatement) conn1.prepareStatement(sql);System.out.println("ODBC链接数据库！");} catch (Exception e) {System.out.println("加载驱动失败" + e.toString());}}public PreparedStatement DBQ() {return pst;}public void CloseDB() {try {conn1.close();pst.close();} catch (Exception e) {System.out.println("出现异常");}}}程序的入口：MainUI.java实现程序的增删改查import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Set; public class MainUI {public static void main(String[] args) {String name=null;String age=null;String id=null;String sql="select *from teacher";String sql1="insert into teacher values(?,?,?)";String sql2="update teacher set age=age+1 where tid=?";String sql3="delete from teacher where tid=?";PreparedStatement pst=null;try {//************************************************************************************************////查询信息//************************************************************************************************//       DBHelper dbHelper=new DBHelper(sql);//生成数据库对象准备执行sql语句   pst=dbHelper.DBQ();//返回对象pst   pst.setString(1, "1234");//为占位符赋值ResultSet ret=pst.executeQuery();//执行sql语句获取结果集   while(ret.next())//取出结果集{id=ret.getString(1);name=ret.getString(2);    age=ret.getString(3);System.out.println(id+","+name+","+age);}   dbHelper.CloseDB();//************************************************************************************************////插入信息//************************************************************************************************//       DBHelper dbHelper1=new DBHelper(sql1);pst=dbHelper1.DBQ();pst.setString(1, "1239");pst.setString(2, "王二");   pst.setString(3, "54");   int f=pst.executeUpdate();   System.out.println(f);   if(f!=0)   {System.out.println("插入记录成功！");}else {        System.out.println("插入记录失败");   }dbHelper1.CloseDB();//************************************************************************************************////修改信息//************************************************************************************************//      DBHelper dbHelper2=new DBHelper(sql2);   pst=dbHelper2.DBQ();   pst.setString(1, "1234");   int t=pst.executeUpdate();   if(t!=0)   {    System.out.println("更新成功！");   }   else {    System.out.println("更新失败！");   }   dbHelper2.CloseDB();//**********************************************************************************************////删除信息//********************************************************************************************//DBHelper1 dbHelper3=new DBHelper1(sql3);pst=dbHelper3.DBQ();pst.setString(1, "1239");int d=pst.executeUpdate();if(d!=0){System.out.println("删除成功！");}else {System.out.println("删除失败！");}dbHelper3.CloseDB();} catch (Exception e) {System.out.println(e.toString());}}}