insert.java

来自「B/S架构的软件项目实训；包括全部详细文档合源程序」· Java 代码 · 共 23 行

import java.sql.*;
import java.io.*;
class Insert 
{	
	public static void main(String[] args) 	
	{	  
		try		
		{		   
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	    
			Connection conn=DriverManager.getConnection("jdbc:odbc:test");	
			Statement stmt=conn.createStatement();		 
			String strInsert="INSERT INTO AccountInfo VALUES ('A00001','Mike',10000,'储蓄帐户','深圳','110108197685432','深圳市红岭中路1011号','82133846','[e-mail]')";	
			int rows=stmt.executeUpdate(strInsert);	
			System.out.println(rows+" row(s) affected");	
			conn.close();	 
		}
		catch(Exception e){System.out.print(e);}	
	}
}