JDBC 学习--12.28笔记

Statement    VS    PreparedStatement

1.    Statement 每次编译，都需要数据库端解析成底层代码。对数据库压力大

2. PreparedStatement  允许带参sql语句

Statement

import java.sql.*;


public class Conn
{
	Connection  con;                                       //声明Connection对象
	public Connection getConnection()
	{
		try                                                //加载数据库驱动类
		{
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("数据库驱动加载成功");
		} catch (ClassNotFoundException e)
		{
			e.printStackTrace();
		}
		
		try                                               //通过访问数据库的URL获取数据库的连接对象
		{
			con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456");
			System.out.println("数据库连接成功");
		} catch (SQLException e)
		{
			e.printStackTrace();
		}
		
		return con;
		
	}

	public static void main(String[] args)
	{
		Conn c=new Conn();                         	//创建本类对象
		Connection con=c.getConnection();							//调用连接数据库的方法
		try
		{
			Statement sql=con.createStatement();
			ResultSet res=sql.executeQuery("SELECT * from people where 1=1");
			while (res.next())
			{
				String nameString=res.getString("name");
				String ageString=res.getString("age");
				String sexString=res.getString("sex");
				System.out.println("name: "+nameString+"       age: "+ageString+"     sex: "+sexString);
			}
		} catch (Exception e)
		{
			e.printStackTrace();
		}
	
	}

}

PreparedStatement

import java.sql.*;
public class Precon
{
	static Connection connection;
	static PreparedStatement preparedStatement;
	static ResultSet resultSet;
	
	public Connection getConnection()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456");
		} catch (Exception e)
		{
			e.printStackTrace();
		}
		
		return connection;
	}
	
	
	public static void main(String[] args)
	{
		Precon precon=new Precon();
		connection=precon.getConnection();
		try
		{
			preparedStatement=connection.prepareStatement("SELECT * from people where name= ? ");
			preparedStatement.setString(1, "张三");
			resultSet=preparedStatement.executeQuery();
			while(resultSet.next())
			{
				String nameString=resultSet.getString("name");
				String ageString=resultSet.getString("age");
				String sexString=resultSet.getString("sex");
				System.out.println("executeQuery 执行name 指定下 的  查询结果：");
				System.out.println("name: "+nameString+"       age: "+ageString+"     sex: "+sexString);
			}
		} catch (Exception e)
		{
			e.printStackTrace();
		}
		
		
		try
		{
			preparedStatement=connection.prepareStatement("insert into people values(?,?,?)");
			preparedStatement.setString(1, "高扁扁");
			preparedStatement.setString(2, "30");
			preparedStatement.setString(3, "女");
			System.out.println("executeUpdate 执行insert");
			preparedStatement.executeUpdate();
		} catch (Exception e)
		{
			e.printStackTrace();
		}
		
		try
		{
			preparedStatement=connection.prepareStatement("SELECT * from people where 1=1 ");
			resultSet=preparedStatement.executeQuery();
			while(resultSet.next())
			{
				String nameString=resultSet.getString("name");
				String ageString=resultSet.getString("age");
				String sexString=resultSet.getString("sex");
				System.out.println("check 插入结果：");
				System.out.println("name: "+nameString+"       age: "+ageString+"     sex: "+sexString);
			}
		} catch (Exception e)
		{
			e.printStackTrace();
		}

	}

}