数据库连接

 Connection conn = null;
  Statement stat = null;
  ResultSet rs = null;
  try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   conn = DriverManager.getConnection("jdbc:odbc:stuDB");
   stat = conn.createStatement();
   stat.execute("delete from stuinfo");
   stat.execute("insert into stuInfo(name,sex) values('test1',1)");
   rs = stat.executeQuery("select * from stuInfo");
   while (rs.next())
   {
    String name = rs.getString(2);
    String sex = rs.getString(3);
    System.out.println("name:"+name);
    System.out.println("sex:"+sex);
    System.out.println("=============");
   }
   stat.close();
   conn.close(); 
  }
  catch (Exception e)
  {
   System.out.println(e);
  }