e1702.java

java小程序

import java.sql.*;
public class E1702
{
public static void main(String args[])
{
String[] name={"陈十全","林二圣","李三多","许四纬","蔡五福"};
String[] sex={"男","女","男","女","男"};
String[] birthday={"19680101","19690202","19700303","19710404","19720505"};
String[] tel={"[phone]","[phone]","[phone]","[phone]","[phone]"};
String[] mail={"[e-mail]","[e-mail]","[e-mail]","[e-mail]","[e-mail]"};
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("insert into mailTab values(?,?,?,?,?,?)");
for(int i=0;i<name.length;i++)
{
pstmt.setString(1,name[i]);
pstmt.setString(2,sex[i]);
pstmt.setString(3,birthday[i]);
pstmt.setString(4,tel[i]);
pstmt.setString(5,mail[i]);
pstmt.setString(6,"");
pstmt.executeUpdate();
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
}
}