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();
}
}
}
}