JDBC

JDBC方法

#1.创建实体类
方法
#2.JDBC
2.2删除方法

						public class delete {
			public static void main(String[] args) {
				Connection conn=null;
				try {
				Class.forName("com.mysql.jdbc.Driver");//加载驱动
					conn = 	DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1701d","root","root");//创建数据库连接
				PreparedStatement pr = conn.prepareStatement("delete from tb_car2 where id=?");	
				pr.setString(1, "5");//创建sql语句
			
			int insert = pr.executeUpdate();
			if (insert>0) {
				System.out.println("删除成功");
			}else{
				System.out.println("删除失败");
			}
			
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				if (conn!=null) {
					try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
		}
	2.3添加方法
					public class insert {
		public static void main(String[] args) {
			Connection conn=null;
			try {
				Class.forName("com.mysql.jdbc.Driver");
				conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1701d","root","root");
			PreparedStatement pr = conn.prepareStatement("insert into tb_car2 (name,ys,jg,scd,rq) values (?,?,?,?,?)");	
			pr.setString(1, "测试3");
			pr.setString(2, "蓝色");
			pr.setString(3, "300.0");
			pr.setString(4, "国产");
			pr.setString(5, "2000-09-10");
			int insert = pr.executeUpdate();
			if (insert>0) {
				System.out.println("添加成功");
			}else{
				System.out.println("添加失败");
			}
			
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				if (conn!=null) {
					try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
		}
		2.4搜索方法
					public static void main(String[] args) {
		Connection conn=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1701d","root","root");
		PreparedStatement pr = conn.prepareStatement("select * from tb_car2");	
		ResultSet re = pr.executeQuery();
		List<Tb>list=new ArrayList<Tb>();
		while (re.next()) {
			int id = re.getInt("id");
			String name = re.getString("name");
			String ys = re.getString("ys");
			String jg = re.getString("jg");
			String scd = re.getString("scd");
			String rq = re.getString("rq");
			Tb tb=new Tb(id, name, ys, jg, scd, rq);
			list.add(tb);
		}
		for (Tb tb : list) {
			System.out.println(tb);
		}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			if (conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}