Java中jdbc的相关操作

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">一、向数据库中插入一条数据（增）</span>

</pre><pre name="code" class="java"><span style="font-size:18px;">public class Demo01 {
	private static final String URL="jdbc:mysql://localhost:3306/ph_test";
	private static final String USER="root";
	private static final String PASSWORD="ok";
	
	public static void main(String[] args) {
		Scanner input = new Scanner(System.in);
		System.out.print("请输入姓名：");
		String pname = input.nextLine();
		System.out.print("请输入年龄：");
		int age = input.nextInt();
		System.out.print("请输入身高：");
		int height = input.nextInt();
		
		try {
			//1.加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			
			//2.根据驱动管理器获取连接对象
			Connection conn =  DriverManager.getConnection(URL, USER, PASSWORD);
			
			//3.编写sql语句
			String sql = "insert into person values(null,?,?,?)";
			
			//4.创建预处理命令
			PreparedStatement pst = conn.prepareStatement(sql);
			
			//5.填充参数
			pst.setString(1,pname );
			pst.setInt(2, age);
			pst.setInt(3, height);
			
			//6.执行更新，返回一个整型变量，代表受影响函数
			int count = pst.executeUpdate();
			System.out.println(count>0? "添加成功":"添加失败");
			
			//7.释放资源
			pst.close();
			conn.close();
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}</span>