一、JDBC操作数据库
JDBC:Java database connection,Java数据库连接技术,通过代码来连接数据库,操作数据库的一种技术
环境搭建:导入jar包依赖
<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.38</version></dependency>
数据查询案例
publicclassJDBCDemo1{publicstaticvoidmain(String[]args){JDBCDemo1demo1=newJDBCDemo1();demo1.query();}//数据库查询publicvoidquery(){//?代表占位符Stringsql="SELECTid,nameFROMfalcon_c4_mobile_cityWHEREcode=?";try{Propertiesproperties=newProperties();InputStreamis=newFileInputStream(newFile("src/main/resources/Projects/Falcon/Env/jdbc.properties"));properties.load(is);Stringurl=properties.getProperty("jdbc.url");Stringusername=properties.getProperty("jdbc.username");Stringpassword=properties.getProperty("jdbc.password");//1.根据连接信息,获得数据库连接(连接数据库)Connectionconnection=DriverManager.getConnection(url,username,password);//2.获取PreparedStatement对象(此类型的对象有提供数据库操作方法)PreparedStatementpreparedStatement=connection.prepareStatement(sql);//3.设置条件字段的值preparedStatement.setObject(1,"110100");//4.调用查询方法,执行查询,返回ResultSet结果集ResultSetresultSet=preparedStatement.executeQuery();//5.从结果集取出查询数据while(resultSet.next()){Stringid=resultSet.getObject("id").toString();Stringname=resultSet.getObject("name").toString();System.out.println("id:"+id+",name:"+name);}}catch(Exceptione){e.printStackTrace();}}}jdbc.properties文件jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://1.1.1.1:3306/falcon?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8jdbc.username=testjdbc.password=test
二、数据工具类封装...
阅读全文