[java] view plain copy 1. import java.sql.Connection; 2. import java.sql.DriverManager; 3. import java.sql.ResultSet; 4. import java.sql.SQLException; 5. import java.sql.Statement; 6. import java.util.logging.Level; 7. import java.util.logging.Logger; 8. 9. public class UseJdbc { 10. 11. public void Jdbc() { 12. try { 13. Class.forName("com.mysql.cj.jdbc.Driver");//加载驱动程序 14. System.out.println("Ok"); 15. //建立连接 16. Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/Contacts?serverTimezone=UTC", "root", "Cc229654512"); 17. System.out.println("Database connected"); 18. //创建语句 19. Statement statement = connection.createStatement(); 20. //用executeQuery执行SQL查询语句 21. ResultSet resultSet = statement.executeQuery("select Name, PhoneNumber, Email, QQ, Note from Contacts"); 22. //获取并输出返回结果 23. while (resultSet.next()) { 24. System.out.println(resultSet.getString(1) + "\t" + resultSet.getString(2) + "\t" + resultSet.getString(3) + "\t" + resultSet.getString(4) + "\t" 25. + resultSet.getString(5)); 26. } 27. //关闭连接 28. connection.close(); 29. } catch (Exception ex) { 30. ex.printStackTrace(); 31. } 32. } 33. } |
[java] view plain copy 1. public void test_insert() 2. { 3. String driver="oracle.jdbc.driver.OracleDriver"; 4. String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";//orcl为sid 5. String user="briup"; 6. String password="briup"; 7. Connection conn=null; 8. Statement stat=null; 9. try { 10. //1、注册驱动 11. Class.forName(driver); 12. //2、获取连接 13. conn= DriverManager.getConnection(url, user, password); 14. //System.out.println(conn); 15. //3、创建statement对象 16. stat=conn.createStatement(); 17. //4、执行sql语句 18. String sql="insert into lover values(5,'suxingxing',to_date('21-9-2016','dd-mm-yyyy'))"; 19. stat.execute(sql); 20. //System.out.println(stat.execute(sql)); 21. //5、处理结果集,如果有的话就处理,没有就不用处理,当然insert语句就不用处理了 22. } catch (Exception e) { 23. e.printStackTrace(); 24. } 25. finally{ 26. //6、关闭资源 27. try { 28. if(stat!=null)stat.close(); 29. } catch (SQLException e) { 30. e.printStackTrace(); 31. } 32. try { 33. if(conn!=null)conn.close(); 34. } catch (SQLException e) { 35. e.printStackTrace(); 36. } 37. } 38. } |