Mybatis学习----知识储备(1)jdbc-连接01

jdbc连接

1.获取InputStream

//1.获取连接
		InputStream is = PreparedStartment.class.getClassLoader().getResourceAsStream("jdbc.properties");
		Properties pros = new Properties();
		pros.load(is);
		
		String user = pros.getProperty("user");
		String password = pros.getProperty("password");
		String url = pros.getProperty("url");
		String driverClass = pros.getProperty("driverClass");

2.加载驱动

	//2.加载驱动
		Class.forName(driverClass);

3.获取连接

//3.建立连接
		Connection conn = DriverManager.getConnection(url,user,password);
		System.out.println(conn);

4.sql预编译

//4.创建sql语句
		String sql = "insert into departments(department_name,manager_id,location_id) value(?,?,?)";//问号为占位符
		PreparedStatement ps = conn.prepareStatement(sql);

5.sql注入语句

//5.填充占位符
		ps.setObject(1,"技术部");
		ps.setObject(2, "789");
		ps.setObject(3, 1700);

6.sql执行

//6.执行sql语句
		ps.execute();

7.资源关闭

//7.关闭资源
		ps.close();
		conn.close();
		is.close();

需要导入mysql驱动文件