JDBC项目案例经典实现.docVIP

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class Main { /** * @param args * @throws */ public static void main(String[] args) { // 1加载驱动类 try { Class.forName(com.mysql.jdbc.Driver); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } // 查询全部的元素 ListPerson list = new ArrayList(); list = selAllPerson(); for (Person p : list) { System.out.print(p.getId() + ); System.out.print(p.getName() + ); System.out.print(p.getAge() + ); System.out.println(p.getAddress()); } // 根据Id地址进行查询操作 /* * Person p = selPersonById(1); System.out.print(p.getId()+ ); * System.out.print(p.getName()+ ); * System.out.print(p.getAge()+ ); * System.out.println(p.getAddress()); */ // 增加操作 /* * Person p=new Person(); p.setId(3); p.setName(zxs); p.setAge(30); * p.setAddress(beijing); addPerson(p); */ // 删除操作 // delPersonById(3); // 修改元素（传入P） /* * Person p=new Person(); p.setId(3); p.setName(zhuxiaoshuai); * p.setAge(22); p.setAddress(beijing); updatePerson(p); */ } // 2创建连接对象，供一下代码使用 public static Connection connff() { Connection conn = null; try { conn = DriverManager.getConnection( jdbc:mysql://localhost:3306/javab, root, 123456); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } public static void addPerson(Person p) { // insert into person values(null,zhangsan,10,anhuihefei) // TODO Auto-generated method stub Connection conn = null; Statement stmt = null; String sql = insert into person values( + p.getId() + , + p.getName() + , + p.getAge() + , + p.getAddress() + ); // id不是自增长的时候不是null try { conn = connff(); stmt = conn.createStatement(); stmt.executeUpdate(sql); } catch (SQLExcepti