import java.sql.*;
import java.io.*;
class Insert1 
{	
	public static void main(String[] args) 	
	{	  
		try		
		{		   
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	    
			Connection conn=DriverManager.getConnection("jdbc:odbc:test");	
			PreparedStatement stmt=conn.prepareStatement("INSERT INTO AccountInfo VALUES(?,?,?,?,?,?,?,?,?)");	
			//在表的各個(gè)字段插入數(shù)據(jù)
			stmt.setString(1,"A00001");
			stmt.setString(2,"Mike");
			stmt.setInt(3,10000);
			stmt.setString(4,"儲(chǔ)蓄帳戶");
			stmt.setString(5,"深圳");
			stmt.setString(6,"110108197685432");
			stmt.setString(7,"深圳市紅嶺中路1011號(hào)");
			stmt.setString(8,"82133846");
			stmt.setString(9,"mike@nonexisted.com.cn");
			//執(zhí)行修改
			int rows=stmt.executeUpdate();	
			System.out.println(rows+" row(s) affected");	
			conn.close();	 
		}
		catch(Exception e){System.out.print(e);}	
	}
}