delete.java

这是用java进行数据库操作的全部源代码 可以帮助大家更明确的学习利用java操作数据库！

import java.sql.* ;
import java.util.* ;

class User
{
	private String mName ;
	private String mPhone ;
	
	public User( String name, String phone )
	{
		mName = name ;
		mPhone = phone ;
	}
	
	public String getName( ) 
	{ 
		return mName ; 
	}
	
	public String getPhone( ) 
	{ 
		return mPhone ; 
	}
	
	public void setName( String name ) 
	{ 
		mName = name ; 
	}
	public void setPhone( String phone ) 
	{ 
		mPhone = phone ; 
	}
}

class Delete
{
	public static void main( String [] args )
	{
		try
		{
			Class.forName( "com.mysql.jdbc.Driver" ) ;
		}
		catch ( ClassNotFoundException classNotFound )
		{
			System.out.println( "ERR: load driver." ) ;
			return ;
		}
		
		try
		{
			Connection connection = DriverManager.getConnection(
				"jdbc:mysql://127.0.0.1/Hello"
					+ "?useUnicode=true&characterEncoding=utf8",
				"root",
				""
			) ;
			
			Statement statement = connection.createStatement( ) ;

			int rowCount = statement.executeUpdate(
				"DELETE FROM User WHERE name = 'gao'"
			) ;
			System.out.println( "rowCount = " + rowCount ) ;
			
			statement.close( ) ;
			
			connection.close( ) ;
		}
		catch ( SQLException sql )
		{
			System.out.println( "ERR: select." ) ;
		}
	}
}