自己写的一个java小程序遇到了问题
我用java写一个程序,输入一个号码,能插入数据库,这项数据后有个状态栏设置为1,再输一遍同样的号码,状态栏更新为2,再输一遍,状态栏更新为3,目前把大部分代码写好了,但是不知道如何在main里调用写好的方法,请大家帮我
看看
package bean;
/**
*
* @author Hu
*
*/
public class product {
private int id;
private String IMEI;
private String status;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getIMEI() {
return IMEI;
}
public void setIMEI(String iMEI) {
IMEI = iMEI;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
}
package DAO;
import bean.product;
public interface productDao {
public boolean Firstscan(product p) throws Exception;
public boolean Secondscan(product p) throws Exception;
public boolean Thirdscan(product p) throws Exception;
}
package DaoImpl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import DAO.productDao;
import bean.product;
public class productDaoImpl implements productDao {
private Connection conn = null;
private PreparedStatement pstm = null;
public productDaoImpl(Connection conn) {
this.conn = conn;
}
@Override
public boolean Firstscan(product p) throws Exception {
pstm = null;
int result = 0;
String sql = "insert into device(imei,status)value(?,?)";
pstm = this.conn.prepareStatement(sql);
pstm.setString(1, p.getIMEI());
pstm.setString(2, "1");
pstm.close();
if (result == 1) {
return true;
}
return false;
}
@Override
public boolean Secondscan(product p) throws SQLException {
pstm = null;
int result = 0;
String sql = "update device set status =? where imei="+p.getIMEI();
pstm = this.conn.prepareStatement(sql);
pstm.setString(2, "2");
pstm.close();
if (result == 1) {
return true;
}
return false;
}
@Override
public boolean Thirdscan(product p) throws SQLException {
int result = 0;
pstm = null;
String sql = "update device set status =? where imei="+p.getIMEI();
pstm = this.conn.prepareStatement(sql);
pstm.setString(2, "3");
pstm.close();
if (result == 1) {
return true;
}
return false;
}
}
package test;
import java.util.Scanner;
import DAO.productDao;
import DaoImpl.productDaoImpl;
import bean.product;
public class test {
public static void main(String[] args) {
product p = new product();
Scanner sc = new Scanner(System.in);
String s = sc.nextLine();
p.setIMEI(s);
}
}
代码如上,接下来我应该如何写我不清楚了,请各位大佬教教我