e1703.java

java小程序

import java.sql.*;
public class E1703
{
public static void main(String args[])
{
String[] name={"陈十全","林二圣"};
String[] sex={"男","女"};
String[] birthday={"19680101","19690202"};
String[] tel={"[phone]","[phone]"};
String[] tel1={"[phone]","[phone]"};
String[] 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("update mailTab set tel=? where tel =?");
for(int i=0;i<name.length;i++)
{
pstmt.setString(1,tel1[i]);
pstmt.setString(2,tel[i]);
pstmt.executeUpdate();
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
}
}