例12-7.txt

来自「这是一本java基础教程 对新手上路有很大帮助」· 文本 代码 · 共 42 行

import java.sql.*; 
import java.util.Calendar;
public class Example12_7{
    public static void main(String args[]){
         Connection con;
         PreparedStatement pre;
         ResultSet rs;
         Calendar calendar=Calendar.getInstance();
         calendar.set(2000,0,28); //注意0代表一月
         Date date=new Date(calendar.getTimeInMillis()); 
         try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
         }
         catch(ClassNotFoundException e){
               System.out.println(""+e);
         }
         try{   con=DriverManager.getConnection("jdbc:odbc:hello","","");
               String insertCondition="INSERT INTO message VALUES (?,?,?,?)";
               pre=con.prepareStatement(insertCondition);
               pre.setString(1,"008");     //设置的第1个?的值是字符串"008"
               pre.setString(2,"弘为大");  //设置的第2个?的值是字符串"弘为大"
               pre.setDate(3,date);       //设置的第3个?的值是日期对象date
               pre.setDouble(4,1.99);    //设置的第4个?的值是数值1.99
               int m=pre.executeUpdate();
               if(m!=0)
                  System.out.println("对表中插入"+m+"条记录成功");
               pre=con.prepareStatement("SELECT * FROM message");
               rs=pre.executeQuery();
               while(rs.next()){
                  String number=rs.getString(1);
                  String name=rs.getString(2);
                  Date birth=rs.getDate(3);
                  double height=rs.getDouble(4);
                  System.out.println(number+","+name+","+birth+","+height);
               }
               con.close();
         }
         catch(SQLException e){
               System.out.println(e);
         }
    }
}