import java.sql.*;

public class testjdbc
{
  public static void main(String args[]) throws SQLException
  {

try
{
  String id,name,sex,age,chinese,maths,output;
  //这种连接方式是单线程方式，最后尽量避免
  /**
  * 另一种连接方式：
  *
  * Context ctx = new InitialContext();
  * javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("examples-dataSource-demoPool");
  * java.sql.Connection myConn = ds.getConnection();
  *
  */
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:student");
  //con.setAutoCommit(false);
  //Connection con = DriverManager.getConnection("jdbc:odbc:wombat", "login", "password");
  Statement sta = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY );
  //Statement sta = con.createStatement( );
  sta.executeUpdate("INSERT INTO student(name,sex,age,chinese,maths) VALUES('ss','男',10,100,95)");
  sta.executeUpdate("UPDATE student SET age = 30 WHERE name = '张三'");
  sta.executeUpdate("DELETE FROM student WHERE name = 'aaaa'");
  //ResultSet rs=sta.executeQuery("SELECT Name,Sex,Age,Chinese,Maths FROM student");
  ResultSet rs = sta.executeQuery("SELECT * FROM student");
  //System.out.println("Id Name Sex Age Chinese Maths");
  System.out.println("|---------------------------|");
  System.out.println(" Id 姓名 性别 年龄 语文 数学");
  System.out.println("|---------------------------|");
  //rs.next();
  //rs.updateString("name","111");

  rs.absolute(5);

  do
  {
    id=rs.getString(1);
    name=rs.getString(2);
    sex=rs.getString(3);
    age=rs.getString(4);
    chinese=rs.getString(5);
    maths=rs.getString;
    output="| " + id + " " + name + " " + sex + " " + age + " " + chinese + " " + maths + " |";
    System.out.println(output);
    System.out.println("|---------------------------|");
  }while(rs.next());
  //PreparedStatement updateAge=con.prepareStatement("UPDATE student SET age=28 WHERE name = '张三'");
  //updateAge.executeUpdate();
  //con.commit();
  //con.setAutoCommit(true);
  //sta2.executeUpdate("INSERT INTO student(name,sex,age,chinese,maths) VALUES('aaa,'男',10,100,95)");
  //sta2.executeUpdate("UPDATE student SET age = 100 WHERE name = '张三'");
}
catch(java.lang.Exception ex)
{
  (System.out.print(ex));
}

} 
}