import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
class alter
{
String sql = null;
int index = 1;
public int toChose(Connection con, int chose, String str, String var)
{
sql = "update worker_main set "+str +" where workerid = ?";
return alterData(con ,sql, index, var);
}
private int alterData(Connection con ,String sql, int index, String var)
{
PreparedStatement pre = null;
int result = 0;
try
{
pre = con.prepareStatement(sql);
pre.setString(index, var);
result = pre.executeUpdate();
}
catch (SQLException e)
{
System.out.println("alter wrong");
e.printStackTrace();
}
return result;
}
}
java连接oracle之修改
最新推荐文章于 2024-10-16 11:14:53 发布