controldatademo.java

本java源程序包括了大量的学习程序（共27章）方便大家学习

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;
import com.mysql.jdbc.*;

public class ControlDataDemo 
{
	public static void main(String[] args) 
	{
		try 
		{   //加载MySQL数据库驱动
			Class.forName("org.gjt.mm.mysql.Driver");
		} 
		catch (java.lang.ClassNotFoundException e)
		{
			System.out.print("Class not found exception occur. Message is:");
			System.out.print(e.getMessage());
		}

	//连接数据库，并添加用户记录
		try    
		{
			PreparedStatement  prepstmt1;
			Statement stmt;
			
			//声明并初始化数据库连接地址
			String url = "jdbc:mysql://localhost:3306/test";
			
			//声明并初始化数据库登陆用户名及密码
			String user = "root";
			String passwordOfDB = "root";
			Connection conn = null;
			
			//连接数据库并验证数据
			try 
			{
				conn = DriverManager.getConnection(url, user, passwordOfDB);
			} 
			catch (Exception ex) 
			{
				ex.printStackTrace();
			}
			
			//使用SQL语句操作数据库，在数据库表中添加数据记录
			String sql1 = "INSERT INTO userinfo (id,username,password,age,gender,email) " +
					"VALUES (10003,?,?,?,?,?)";			
			prepstmt1 = (PreparedStatement) conn.prepareStatement(sql1);
			prepstmt1.setString(1, "xugy");
			prepstmt1.setString(2, "111111");
			prepstmt1.setInt(3, 22);
			prepstmt1.setString(4, "male");
			prepstmt1.setString(5, "[e-mail]");
			prepstmt1.executeUpdate();
			
			//删除id为10001的记录
			String sql2 = "delete from userinfo where id=10001";
			stmt = (Statement) conn.createStatement();
			stmt.executeUpdate(sql2);
			
			//修改id为10002的记录，使其id为10001,age值为26
			String sql3 = "update userinfo set id=?,age=? where id=?";
			prepstmt1 = (PreparedStatement) conn.prepareStatement(sql3);
			prepstmt1.setInt(1, 10001);
			prepstmt1.setInt(2, 26);	
			prepstmt1.setInt(3, 10002);		
			prepstmt1.executeUpdate();
			
			prepstmt1.close();  //关闭PreparedStatement对象
			stmt.close();       //关闭Statement对象
			conn.close();       //关闭Connection连接对象
		} 
		catch (SQLException e) 
		{
			System.out.print("SQL Exception occur. Message is:");
			System.out.print(e.getMessage());
		}
	}
}